Creating an ODBC Source for IBM Netezza® Analytics

To enable the connection between the IBM Netezza database 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.

Windows clients

  1. From your Netezza Client CD, run the nzodbcsetup.exe file to start the installer. Follow the on-screen instructions to install the driver. For full instructions, see the IBM Netezza ODBC, JDBC, and OLE DB Installation and Configuration Guide.
    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 NetezzaSQL from the list and click Finish.
  3. On the DSN Options tab of the Netezza ODBC Driver Setup screen, type a data source name of your choosing, the hostname or IP address of the IBM Netezza server, the port number for the connection, the database of the IBM Netezza instance you are using, and your username and password details for the database connection. Click the Help button for an explanation of the fields.
  4. Click the Test Connection button and ensure that you can connect to the database.
  5. When you have a successful connection, click OK repeatedly to exit from the ODBC Data Source Administrator screen.

Windows servers

The procedure for Windows Server is the same as the client procedure for Windows XP.

UNIX or Linux servers

The following procedure applies to UNIX or Linux servers (except zLinux, for which IBM Netezza ODBC drivers are not available).

  1. From your Netezza Client CD/DVD, copy the relevant <platform>cli.package.tar.gz file to a temporary location on the server.
  2. Extract the archive contents by means of the gunzip and untar commands.
  3. Add execute permissions to the unpack script that is extracted.
  4. Run the script, answering the on-screen prompts.
  5. Edit the modelersrv.sh file to include the following lines.
    . <SDAP Install Path>/odbc.sh
LD_LIBRARY_PATH_64=$LD_LIBRARY_PATH:/usr/local/nz/lib64; export LD_LIBRARY_PATH_64
NZ_ODBC_INI_PATH=<SDAP Install Path>; export NZ_ODBC_INI_PATH
    For example:
    . /usr/IBM/SPSS/SDAP/odbc.sh
LD_LIBRARY_PATH_64=$LD_LIBRARY_PATH:/usr/local/nz/lib64; export LD_LIBRARY_PATH_64
NZ_ODBC_INI_PATH=/usr/IBM/SPSS/SDAP; export NZ_ODBC_INI_PATH
  6. Locate the file /usr/local/nz/lib64/odbc.ini and copy its contents into the odbc.ini file that is installed with SDAP (the one defined by the $ODBCINI environment variable).

    Note: For 64-bit Linux systems, the Driver parameter incorrectly references the 32-bit driver. When you copy the odbc.ini contents in the previous step, edit the path within this parameter accordingly, for example:

    /usr/local/nz/lib64/libnzodbc.so
  7. Edit the parameters in the Netezza DSN definition to reflect the database to be used.
  8. Restart IBM SPSS Modeler Server and test the use of the Netezza in-database mining nodes on the client.