reading data from a remote (My)SQL-DB

Posted by drfg2008 on Mar 01, 2011; 3:12pm
URL: http://spssx-discussion.165.s1.nabble.com/reading-data-from-a-remote-My-SQL-DB-tp3405092.html

Generally, I would like to know if it is possible to read data from a remote DB (My-)SQL DB via Internet.


So, I wonder if there is a direct way to read it with SPSS-Syntax (maybe with a python plugin). I already checked into www.ibm.com/developerworks/spssdevcentral , but couldn't find sth.


Especially, I would like to read from our (remote) MySQL DB server directly, instead of exporting the tables with our php-programs. This would make things faster.

As a second option my question if it is possible to read data via SPSS Syntax from the amazon cloud (EC2 instance). Until now we only use amazon with the mozilla plugin, just as storage.

A third question: Amazon provides AMIs for Microsoft SQL Server Standard 2005/2008 or MySQL Enterprise. Is it possible to read from amazon DB with SPSS syntax (python)?

Thanks