If InfoSphere® Information Server runs
on the Microsoft Windows operating system, you
must create and configure the data source after you installthe 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.
Procedure
- To create the data source:
- Do one of the following actions depending on your Operating
System:
- On a 32-bit Windows system, click .
- On a 64-bit Windows system, use Explorer to navigate to C:\Windows\SysWOW64\odbcad32.exe.
- On the System DSN page, click Add.
- On the Create New Data Source page,
select NetezzaSQL as the driver to set up the
data source for, and then click Finish.
- To configure the ODBC driver:
- On the Netezza ODBC Driver Setup page,
specify details about the data source.
- In the Server field, specify
the host name or the IP address of the Netezza system to which the
ODBC driver connects.
- To test the connection, specify the username and password,
and then click Test Connection.