Configure a Netezza connection using ODBC on UNIX

Install the Netezza ODBC driver, and Netezza client libraries. Note If you are running a PowerCenter 32-bit Integration Service, make sure the Netezza 32-bit ODBC driver and client are installed and accessible. If you are running a PowerCenter 64-bit Integration Service, make sure the Netezza 64-bit ODBC driver and client are installed and accessible. Set the following environment variables: NZ_ODBC_INI_PATH Set NZ_ODBC_INI_PATH to $INFA_HOME/ODBCn.n/ Add $INFA_HOME/ODBCn.n/lib:{NetezzaInstallationDir}/lib64 to the shared library environment variable. Solaris LD_LIBRARY_PATH Linux LD_LIBRARY_PATH AIX LIBPATH HP-UX SHLIB_PATH For instance, use the following syntax for Solaris: LD_LIBRARY_PATH Add $INFA_HOME/ODBCn.n/lib:{your Netezza path}/lib64 to the library path ODBCINI Set ODBCINI to ${NZ_ODBC_INI_PATH}/odbc.ini Set the ODBCINI environment variable so that it points to the location of the odbc.ini file. Note If this variable is not set it will look for .odbc.ini in the us...