Netezza Connector

Back Next

Configuring the Netezza ODBC driver on Linux

Before you can run tasks to connect to Netezza using the ODBC connection from Linux, you must set the ODBCINI, ODBCINST, and LD_LIBRARY_PATH environmental variables for the driver and create the DSN entries.

Add the path of the

odbc.ini

file to the ODBCINI environment variable. For example,

setenv ODBCINI "/data/home/qamercury/cloud_td/ODBCINI/odbc.ini"

To set the ODBCINST environment variable, use the following syntax:

setenv ODBCINST /data/home/qamercury/cloud_td/ODBCINI/odbcinst.ini

To set the LD_LIBRARY_PATH environment variable, use the following syntax:

setenv LD_LIBRARY_PATH  ".:/export/qa_adp/thirdparty/netezza/linux.64/lib64:$LD_LIBRARY_PATH"

To set the NZ_ODBC_INI_PATH environment variable, use the following syntax:

setenv NZ_ODBC_INI_PATH "/path/to/directory/where/we/have/odbc.ini/file

Add entries for the Netezza data sources in the

odbc.ini

file.

The following section shows a sample entry in the

odbc.ini

file:


[Sample Netezza ODBC DSN]
Driver=/export/qa_adp/thirdparty/netezza/linux.64/lib64/libnzodbc.so
Description=NetezzaSQL ODBC
Servername=adaptersnz2.informatica.com
Port=5480
Database=ADPQA_DB
Username=adpqa
Password=adpqa
StripCRLF=false
ReadOnly=false
ShowSystemTables=false
DateFormat=1
NumericAsChar=false
DebugLogging=true

Restart the Secure Agent after you configure the environment variables.

Configuring a Netezza ODBC connection for SQL ELT optimization

Download Guide

Watch

Comments

Cloud Connectivity Homepage

Communities

Knowledge Base

Success Portal