What you need

To perform database modeling, you need the following setup:

  • An ODBC connection to an appropriate database, with required analytical components installed (Microsoft Analysis Services or Oracle Data Miner).
  • In IBM® SPSS® Modeler, database modeling must be enabled in the Helper Applications dialog box (Tools > Helper Applications).
  • The Generate SQL and SQL Optimization settings should be enabled in the User Options dialog box in IBM SPSS Modeler as well as on IBM SPSS Modeler Server (if used). Note that SQL optimization is not strictly required for database modeling to work but is highly recommended for performance reasons.
Note: Database modeling and SQL optimization require that IBM SPSS Modeler Server connectivity be enabled on the IBM SPSS Modeler computer. With this setting enabled, you can access database algorithms, push back SQL directly from IBM SPSS Modeler, and access IBM SPSS Modeler Server. To verify the current license status, choose the following from the IBM SPSS Modeler menu.

Help > About > Additional Details

If connectivity is enabled, you see the option Server Enablement in the License Status tab.

See Connecting to IBM SPSS Modeler Server for more information.

For detailed information, see the subsequent sections on specific vendors.