Database Access

To read or write to a database, you must have an ODBC data source installed and configured for the relevant database, with read or write permissions as needed. The IBM® SPSS® Data Access Pack includes a set of ODBC drivers that can be used for this purpose, and these drivers are available from the download site. If you have questions about creating or setting permissions for ODBC data sources, contact your database administrator.

Supported ODBC Drivers

For the latest information on which databases and ODBC drivers are supported and tested for use with IBM SPSS Modeler 18, see the product compatibility matrices on the corporate Support site (http://www.ibm.com/support).

Where to Install Drivers

Note: ODBC drivers must be installed and configured on each computer where processing may occur.
  • If you are running IBM SPSS Modeler in local (standalone) mode, the drivers must be installed on the local computer.
  • If you are running IBM SPSS Modeler in distributed mode against a remote IBM SPSS Modeler Server, the ODBC drivers need to be installed on the computer where IBM SPSS Modeler Server is installed.
  • If you need to access the same data sources from both IBM SPSS Modeler and IBM SPSS Modeler Server, the ODBC drivers must be installed on both computers.
  • If you are running IBM SPSS Modeler over Terminal Services, the ODBC drivers need to be installed on the Terminal Services server on which you have IBM SPSS Modeler installed.