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 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

Connect to Netezza

Let's configure the Netezza connection properties to connect to Netezza.

Before you begin

Before you get started, you need to get Netezza database and authentication details from your Netetzza account. You also need to install Netezza client and drivers.

Check out Prerequisites to learn more about the tasks you must perform.

Connection details

The following table describes the basic connection properties:

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.
Use Secret Vault	Stores sensitive credentials for this connection in the secrets manager that is configured for your organization. This property appears only if secrets manager is set up for your organization. This property is not supported by Data Ingestion and Replication and the Data Access Management services. When you enable the secret vault in the connection, you can select which credentials that the Secure Agent retrieves from the secrets manager. If you don't enable this option, the credentials are stored in the repository or on a local Secure Agent, depending on how your organization is configured. Note: If you’re using this connection to apply data access policies through pushdown or proxy services, you cannot use the Secret Vault configuration option. For information about how to configure and use a secrets manager, see Secrets manager configuration.
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

The following table describes the advanced connection properties:

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.