You can import Salesforce data into SPSS Statistics with a standard SQL query. The SPSS Database Wizard can automatically generate and execute an appropriate query based on parameters you specify.
The following procedure is written for SPSS Statistics 23. The Simba Salesforce ODBC Driver also supports earlier versions of SPSS.
Make sure that the bitness of the driver that you are using matches the bitness of SPSS. If you are using the 32-bit version of SPSS, then you need to use the 32-bit version of the driver. If you are using the 64-bit version of SPSS, then you need to use the 64-bit version of the driver. For more information about diagnosing the issue, see "Architecture Mismatch Problems" in Troubleshooting.
To retrieve data from your Salesforce data store using SPSS:
For information about obtaining a security token, see "Reset Your Security Token" in the Salesforce documentation:https://help.salesforce.com/apex/HTViewHelpDoc?id=user_security_token.htm.
Data retrieved from the selected tables is displayed in SPSS Statistics in a new Dataset window. You can now use SPSS Statistics to analyze the data.
For more information about connecting to a database in SPSS Statistics, see the SPSS Statistics Help documentation that is provided in the application.