Connect to SPSS data source

KNIME Analytics Platform
#1

Hi,

I'm working on a forecasting analysis and I'm using Linear Regression as my standard method, with SPSS as standard software. Now, I also want to analyse my dataset using data mining and since I've been using Knime previously, it was an easy choice.

Since I do not want two seperate data sources, I would like to find out if it is possible to connect a SPSS datasource (.sav) to Knime? I've been looking at drivers etc, but cannot figure out how to do it.

The way I do it now, export to .csv is not really working due to the size of the dataset and auto conversions of numeric to strings etc.

Can someone help me?

Jasper Kock

#2

Hi Jasper,

I see that this might be too late for you, but RapidMiner allows you to read SPSS sav files, and with RapidMiner integration you can import the data to KNIME (I have not tried it, as I do not have SPSS data around, but this should work).

Hope this helps, gabor