reading data from a remote (My)SQL-DB

[drfg2008]

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

[Albert-Jan Roskam]

GET DATA can also be used for accessing databases. Follow the wizard to get the connect string ad tweak it afterwards. Pyodbc is super for working with databases under Python. You can use e.g. regexes, something that dbms'es rarely can.

Cheers!!
Albert-Jan

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
All right, but apart from the sanitation, the medicine, education, wine, public order, irrigation, roads, a fresh water system, and public health, what have the Romans ever done for us?
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

---

From: drfg2008 <[hidden email]>
To: [hidden email]
Sent: Tue, March 1, 2011 4:12:23 PM
Subject: [SPSSX-L] reading data from a remote (My)SQL-DB

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

-----
FUB

--
View this message in context: http://spssx-discussion.1045642.n5.nabble.com/reading-data-from-a-remote-My-SQL-DB-tp3405092p3405092.html
Sent from the SPSSX Discussion mailing list archive at Nabble.com.

=====================
To manage your subscription to SPSSX-L, send a message to
[hidden email] (not to SPSSX-L), with no body text except the
command. To leave the list, send the command
SIGNOFF SPSSX-L
For a list of commands to manage subscriptions, send the command
INFO REFCARD

[drfg2008]

Thank you Albert-Jan,

especially for the hint: pyodbc. I found interesting information on
http://www.easysoft.com/developer/languages/python/pyodbc.html

However, I thougt, SPSS might already have a solution to access remote DBs via Internet.

(for amazon cloud especially, since more and more comp.s use the cloud)

Frank