Netezza connection properties

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 from the following Knowledge Base article:

https://kb.informatica.com/howto/6/Pages/23/619186.aspx

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 from the following Knowledge Base article:

https://knowledge.informatica.com/s/article/HOW-TO-Download-the-Netezza-ODBC-driver?language=en_US

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

Connect to Netezza

Before you begin

Connection details

Property	Description
Connection Name	Name of the connection. Each connection name must be unique within the organization. Connection names can contain alphanumeric characters, spaces, and the following special characters: _ . + -, Maximum length is 255 characters.
Description	Description of the connection. Maximum length is 4000 characters.
Type	Netezza.
Runtime Environment	The name of the runtime environment where you want to run tasks. Specify a Secure Agent.
Database	The name of the Netezza database.
Schemaname	The schema used for the Netezza source or target. Schema name is case sensitive.
Servername	The Netezza database host name.
Port	Network port number used to connect to the database server. Default is 1521.
Username	Database user name with the appropriate read and write database permissions to access the database.
Password	Password for the database user name.

Advanced settings

Property	Description
Driver	The Netezza ODBC driver name that is used to connect to the Netezza database. The Netezza ODBC driver name is NetezzaSQL.
Runtime Additional Connection Configuration	Additional runtime attributes required to fetch data. For example, securityLevel=preferredUnSecured;caCertFile =
Metadata Additional Connection Configuration	The values to set the optional properties of the JDBC driver to fetch the metadata.