Database Access

To read or write to a database, you must have an ODBC data source that is installed and configured for the relevant database, with read or write permissions as needed. 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, 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 might 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. For IBM SPSS Modeler Server on UNIX systems, see also "Configuring ODBC drivers on UNIX systems" later in this section.
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.

Configuring Snowflake or Big Query databases

If you connect Snowflake or BigQuery using an SDAP driver, which works with either an Excel node or XML node that needs to start with the JVM instance, you might receive this error:

Internal Error. Failed to open Java VM.

To resolve this issue, edit the SDAP ODBC configuration for these databases so that Modeler and SDAP use the same JVM instance. The following are examples of how to configure the JVM instance for Snowflake.