Enabling Integration with Oracle

To enable the IBM® SPSS® Modeler integration with Oracle Data Mining, you'll need to configure Oracle, create an ODBC source, enable the integration in the IBM SPSS Modeler Helper Applications dialog box, and enable SQL generation and optimization.

Configuring Oracle

To install and configure Oracle Data Mining, see the Oracle documentation—in particular, the Oracle Administrator’s Guide—for more details.

Creating an ODBC Source for Oracle

To enable the connection between Oracle and IBM SPSS Modeler, you need to create an ODBC system data source name (DSN).

Before creating a DSN, you should have a basic understanding of ODBC data sources and drivers, and database support in IBM SPSS Modeler.

If you are running in distributed mode against IBM SPSS Modeler Server, create the DSN on the server computer. If you are running in local (client) mode, create the DSN on the client computer.

  1. Install the ODBC drivers. These are available on the IBM SPSS Data Access Pack installation disk shipped with this release. Run the setup.exe file to start the installer, and select all the relevant drivers. Follow the on-screen instructions to install the drivers.
    1. Create the DSN.
      Note: The menu sequence depends on your version of Windows.
      • Windows XP. From the Start menu, choose Control Panel. Double-click Administrative Tools, and then double-click Data Sources (ODBC).
      • Windows Vista. From the Start menu, choose Control Panel, then System Maintenance. Double-click Administrative Tools, selectData Sources (ODBC), then click Open.
      • Windows 7. From the Start menu, choose Control Panel, then System & Security, then Administrative Tools. SelectData Sources (ODBC), then click Open.
    2. Go to the System DSN tab, and then click Add.
  2. Select the SPSS OEM 6.0 Oracle Wire Protocol driver.
  3. Click Finish.
  4. In the ODBC Oracle Wire Protocol Driver Setup screen, enter a data source name of your choosing, the hostname of the Oracle server, the port number for the connection, and the SID for the Oracle instance you are using.

    The hostname, port, and SID can be obtained from the tnsnames.ora file on the server machine if you have implemented TNS with a tnsnames.ora file. Contact your Oracle administrator for more information.

  5. Click the Test button to test the connection.

Enabling Oracle Data Mining Integration in IBM SPSS Modeler

  1. From the IBM SPSS Modeler menus choose:

    Tools > Options > Helper Applications

  2. Click the Oracle tab.

Enable Oracle Data Mining Integration. Enables the Database Modeling palette (if not already displayed) at the bottom of the IBM SPSS Modeler window and adds the nodes for Oracle Data Mining algorithms.

Oracle Connection. Specify the default Oracle ODBC data source used for building and storing models, along with a valid user name and password. This setting can be overridden on the individual modeling nodes and model nuggets.

Note: The database connection used for modeling purposes may or may not be the same as the connection used to access data. For example, you might have a stream that accesses data from one Oracle database, downloads the data to IBM SPSS Modeler for cleaning or other manipulations, and then uploads the data to a different Oracle database for modeling purposes. Alternatively, the original data might reside in a flat file or other (non-Oracle) source, in which case it would need to be uploaded to Oracle for modeling. In all cases, the data will be automatically uploaded to a temporary table created in the database that is used for modeling.

Warn when about to overwrite an Oracle Data Mining model. Select this option to ensure that models stored in the database are not overwritten by IBM SPSS Modeler without warning.

List Oracle Data Mining Models. Displays available data mining models.

Enable launch of Oracle Data Miner. (optional) When enabled, allows IBM SPSS Modeler to launch the Oracle Data Miner application. Refer to Oracle Data Miner for more information.

Path for Oracle Data Miner executable. (optional) Specifies the physical location of the Oracle Data Miner for Windows executable file (for example, C:\odm\bin\odminerw.exe). Oracle Data Miner is not installed with IBM SPSS Modeler; you must download the correct version from the Oracle Web site (http://www.oracle.com/technology/products/bi/odm/odminer.html) and install it at the client.

Enabling SQL Generation and Optimization

  1. From the IBM SPSS Modeler menus choose:

    Tools > Stream Properties > Options

  2. Click the Optimization option in the navigation pane.
  3. Confirm that the Generate SQL option is enabled. This setting is required for database modeling to function.
  4. Select Optimize SQL Generation and Optimize other execution (not strictly required but strongly recommended for optimized performance).