Connections > Netezza connection properties > Prerequisites

Prerequisites

Before you can use Netezza Connector, install the Netezza client on Windows or Linux.

Ensure that you have access to the Secure Agent directory that contains the success and error files. This directory path must be the same on each Secure Agent machine in the runtime environment selected for your connection.

Before you create a Netezza connection, be sure to configure the Netezza ODBC and JDBC drivers.

Download the Netezza JDBC Driver

1Download the Netezza JDBC driver version from the IBM website:

To download the Netezza JDBC driver on Windows, follow the instructions in the How to download the Netezza JDBC driver Knowledge article.

If you want to use the Netezza JDBC driver on Linux, you can use the Netezza JDBC driver downloaded for Windows on the Linux machine.

2After you download the Netezza JDBC driver, navigate to the following location:

<Secure Agent installation directory>/apps/Data_Integration_Server/ext/

3Manually create the following directory structure:

deploy_to_main/bin/rdtm-extra/Netezza

4Copy the Netezza JDBC driver jar file, nzjdbc.jar, to the following directory you created on the Secure Agent machine:

<Secure Agent installation directory>/apps/Data_Integration_Server/ext/deploy_to_main/bin/rdtm-extra/Netezza

5Restart the Secure Agent.

Download the Netezza ODBC Driver

1Download the Netezza ODBC driver version from the IBM website:

To download the Netezza ODBC driver, follow the instructions in the How to download the Netezza ODBC driver Knowledge article.

2Perform the following tasks to use the Netezza ODBC driver based on the operating system:

- On Windows, verify if the NetezzaSQL driver appears in the ODBC Data Source Administrator driver list.
- On Linux, add the driver entries in the odbcinst.ini file in the Secure Agent installation directory.

The following code shows a sample entry:

[NetezzaSQL]
Driver = /data/home/adputf_9/cloud_td/Netezza/installer/linux64/lib64/libnzodbc.so
Setup = /data/home/adputf_9/cloud_td/Netezza/installer/linux64/lib64/libnzodbc.so
APILevel = 1
ConnectFunctions = YYN
Description = Netezza ODBC driver
DriverODBCVer = 03.51
DebugLogging = true
LogPath = /tmp
UnicodeTranslationOption = utf8
CharacterTranslationOption = all
PreFetch = 256
Socket = 16384