ODBC Connector

Back Next

Configure the Netezza ODBC driver on Linux

Before you establish an ODBC connection to connect to Netezza on Linux, configure the ODBC driver.

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"

Add entries for the Netezza data sources in the

odbc.ini

file.

The following format 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.

Configure the ODBC driver

Download Guide

Watch

Comments

Cloud Connectivity Homepage

Communities

Knowledge Base

Success Portal