SPSS and PHP/MySQL Integration

Don picture Don · Jan 26, 2010 · Viewed 12.5k times · Source

I apologize up front for the broadness of this question, but I'm wondering if anyone has any suggestions/pointers.

A friend's company uses SPSS for statistical data, surveys, etc. They'd like to be able to slice and dice the info via a web interface. I have no knowledge of SPSS, so there may be a simple web front end, but being a PHP/MySQL guy, I wondered if SPSS data can be exported in a way that MySQL can import or PHP can parse. Then I could build an AJAX front end to return queries in real time.

The idea would be a results table that changes when you make selections like "Gender: Male", "Age: 20-25"... each change would update the results in the browser.

So...

1) Can SPSS accomplish this with some kind of front end?

2) Can the data be easily exported in a generic format?

I just want to know if I'm on a fools errand before I talk to my friend's boss about ideas.

TIA. Don

UPDATE: I had a meeting at my friend's company to discuss more specifics. It sounds like the SPSS data is stored in MS SQL Server, so I'm thinking that I could connect directly to the data if I can see some kind of schema logic and write my own web front end against it.

Alternatively, I may be able to do a scheduled data dump of the data into another format.

Answer

bpeterson76 picture bpeterson76 · Jun 30, 2010

http://www.spss.com/smartscore/

In addition, it appears that SPSS has an available API to make the SPSS information available to other apps. Assuming you could get a connection to the SPSS system, it'd be a matter of CURLing the information back and forth (a web service) Aside from the XML brain damage, this is one of the best ways to get two non-similar systems talking to each other.