Install and Configure - Connect_ETL

Connect connects to Netezza databases through the Netezza nzload client utility, which is a component of the Netezza client software package, and the Netezza Open Database Connectivity (ODBC) driver.

For Windows and UNIX systems, the client software package includes the Netezza client interface software and the Netezza ODBC driver.

To establish a connection to the Netezza database, install the Netezza client software package on the system on which the Connect client is installed.

Netezza client software package and driver installation

Windows systems

For Windows systems, the client software installation includes the following:

Install the Netezza client software package.

For procedures on installing the Netezza client software and ODBC driver, refer to the installation chapter of the IBM Netezza System Administration Guide.

The default Netezza client installation is located in the following directory:

C:\Program Files (x86)\IBM Netezza Tools

The default Netezza ODBC driver installation is located in the following directory:

C:\Program Files (x86)\IBM Netezza ODBC Driver

Verify that the ODBC driver libraries, which are dynamic linked libraries with the .dll extension, are installed successfully.

Verify that the Netezza ODBC driver installation directory is specified in the PATH.

Create and configure the ODBC DSN.

Specify the Netezza client utilities directory in the PATH.

For example, set the PATH as follows:

set PATH=%PATH%;C:\Program Files (x86)\IBM Netezza Tools\bin

Note: If the Netezza nzds and nzload client utilities are not in the PATH when Connect initiates a load to the Netezza database, Connect does the following:

nzds - Connect issues a performance warning message and establishes only one connection to the Netezza database.
nzload - Connect issues an error message and the Connect task aborts.

To run the nzds client utility, ensure that the database user account has the Manage Hardware privilege.

For additional information on required privileges, see the IBM Netezza System Administration Guide and the Netezza Data Loading Guide.

Verify the port number used to connect to the Netezza database.

When the NZ_DBMS_PORT environment variable is defined, Connect connects to the Netezza database using the value specified in NZ_DBMS_PORT; otherwise, Connect connects to the Netezza database using the default port number, 5480.

UNIX systems

For UNIX systems, the client software installation includes the following:

Install the Netezza client software package.

For procedures on installing the Netezza ODBC driver and the client software, refer to the installation chapter of the IBM Netezza System Administration Guide.

The default Netezza client installation is located in the following directory:

/usr/local/nz/bin

The default Netezza ODBC driver installation is located in the following directory:

/usr/local/nz/lib64

Create and configure the ODBC DSN.

Specify the Netezza client utilities directory in the PATH.

For example, export the PATH as follows:

export PATH=$PATH:/usr/local/nz/bin

Note: If the Netezza nzds and nzload client utilities are not in the PATH when Connect initiates a load to the Netezza database, Connect does the following:

nzds - Connect issues a performance warning message and establishes only one connection to the Netezza database.
nzload - Connect issues an error message and the Connect task aborts.

Set NZ_ODBC_INI_PATH to point to the directory where odbc.ini, without the leading period, ".", is located.

For example, set NZ_ODBC_INI_PATH as follows:

export NZ_ODBC_INI_PATH=$NZ_ODBC_INI_PATH:<directory_where_odbc.ini_is_located>