Configuring access to Netezza databases on Microsoft Windows

If InfoSphere® Information Server runs on the Microsoft Windows operating system, you must create and configure the data source after you install the Netezza ODBC driver.

Before you begin

• Install database client libraries.
• On 64-bit Windows computers, make sure that you run the 32-bit version of the Microsoft ODBC Data Source Administrator C:\Windows\SysWOW64\odbcad32.exe, as InfoSphere Information Server is a 32-bit application. If you run the 64-bit version of the ODBC administrator application, the Netezza connector fails to locate the specified data source name. If the ODBC administrator application is not accessible through the File menu by default, use the Windows Explorer to access the application.
  • On 32-bit Windows, the 32-bit driver is installed in the C:\Windows\System32 directory.
  • On 64-bit Windows, you can install both 32-bit and 64-bit drivers. The 32-bit driver is installed in the C:\Windows\SysWOW64 directory and 64-bit version is installed in the C:\Windows\System32 directory.

1. Create the data source:
   1. Complete one of the following actions, depending on your operating system:
      • On a 32-bit Windows system, click Start > Control panel > Administrative Tools > Data Sources (ODBC).
      • On a 64-bit Windows system, use Explorer to navigate to C:\Windows\SysWOW64\odbcad32.exe.
   2. On the System DSN page, click Add.
   3. Define the system DSN by using the 32-bit ODBC Data Source Administrator. See Configuring the data source for detailed steps.
   4. On the Create New Data Source page, select NetezzaSQL as the driver to set up the data source for, and then click Finish.
2. Configure the ODBC driver:
   1. On the Netezza ODBC Driver Setup page, specify details about the data source.
   2. In the Server field, specify the host name or the IP address of the Netezza system to which the ODBC driver connects.
   3. To test the connection, specify the user name and password, and then click Test Connection.