Menu
Simba Technologies
Simba Technologies

Simba Salesforce ODBC Driver with SQL Connector 1.2.5
Quickstart Guide for Windows

Using SPSS Statistics

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.

Important:

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:

  1. In SPSS Statistics, select File > Open Database > New Query. The Database Wizard opens at the Welcome page.
  2. From the ODBC Data Source list, select your DSN.
  3. Under Select the Table Types, select the check boxes corresponding to the types of tables you want to retrieve and then click Next.
  4. If you are prompted to provide your credentials, type your credentials for accessing the server in the dialog box, and click OK.
  5. 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.

  6. On the Select Data page, select and order the tables and fields that you want to retrieve and then click Next.
  7. If you selected more than one table, then on the Specify Relationships page, specify how the tables should be joined and then click Next.
  8. On the Limit Retrieved Cases page, specify how to limit the data you retrieve and then click Next.
  9. On the Define Variables page, specify how SPSS should define those variables and then click Next.
  10. On the Results page, review the generated SQL.
  11. Make sure that Retrieve the Data I Have Selected is selected and then click Finish.

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.

Note:

For more information about connecting to a database in SPSS Statistics, see the SPSS Statistics Help documentation that is provided in the application.