Selecting a Data Source

Use the first screen of the Database Wizard to select the type of data source to read.

ODBC Data Sources

If you do not have any ODBC data sources configured, or if you want to add a new data source, click Add ODBC Data Source.

  • On Linux operating systems, this button is not available. ODBC data sources are specified in odbc.ini, and the ODBCINI environment variables must be set to the location of that file. For more information, see the documentation for your database drivers.
  • In distributed analysis mode (available with IBM® SPSS® Statistics Server), this button is not available. To add data sources in distributed analysis mode, see your system administrator.

An ODBC data source consists of two essential pieces of information: the driver that will be used to access the data and the location of the database you want to access. To specify data sources, you must have the appropriate drivers installed. Drivers for a variety of database formats are included with the installation media.

Parent topic: Reading Database Files
Related information:
To Read Database Files
Distributed Analysis Mode
Selecting Data Fields
Creating a Relationship between Tables
Limiting Retrieved Cases
Creating a Parameter Query
Aggregating Data
Defining Variables
Sorting Cases
Results