ODBC Connector > Introduction to ODBC Connector > Configuring the Netezza ODBC driver on Linux
  

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.
    1. 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"
    2. To set the ODBCINST environment variable, use the following syntax:
    setenv ODBCINST /data/home/qamercury/cloud_td/ODBCINI/odbcinst.ini
    3. 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"
    4. 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
    5. Restart the Secure Agent after you configure the environment variables.