Database source node
The Database source node can be used to import data from a variety of other packages using ODBC (Open Database Connectivity), including Microsoft SQL Server, Db2, Oracle, and others.
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, see the product compatibility matrices on the corporate Support site (http://www.ibm.com/support).
Where to Install Drivers
- 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.
Access data from a database
To access data from a database, complete the following steps.
- Install an ODBC driver and configure a data source to the database you want to use.
- In the Database node dialog box, connect to a database using Table mode or SQL Query mode.
- Select a table from the database.
- Using the tabs in the Database node dialog box, you can alter usage types and filter data fields.
More details on the preceding steps are given in the related documentation topics.
- Create a view based on the SELECT and choose the view in the Database source node
- Use the SELECT directly in the Database source node.