ODBC Connector Guide > Introduction to ODBC Connector > Configuring the Teradata ODBC Driver on Linux
  

Configuring the Teradata ODBC Driver on Linux

Before you can run tasks to connect to Teradata using the ODBC connection from Linux, you must set the ODBCINI 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/adputf_9/cloud_td/ODBCINI/odbc.ini"
    2. To set the LD_LIBRARY_PATH environment variable, use the following syntax:
    setenv LD_LIBRARY_PATH "/opt/teradata/client/<Version>/lib64"
    3. Add entries for the Teradata data sources in the odbc.ini file.
    The following section shows a sample entry in the odbc.ini file:

    [Sample Teradata ODBC DSN]
    [ODBC Data Sources]
    <DSN_NAME>=tdata.so

    [<DSN_NAME>]
    Driver=<Teradata_ClientHome>/lib64/tdata.so
    Description=DataDirect 7.1 Teradata
    AccountString=
    AuthenticationDomain=
    AuthenticationPassword=
    AuthenticationUserid=
    CharacterSet=ASCII
    DBCName=<Teradata Server>
    Database=
    EnableDataEncryption=0
    EnableExtendedStmtInfo=0
    EnableLOBs=1
    EnableReconnect=0
    IntegratedSecurity=0
    LoginTimeout=20
    LogonID=
    MapCallEscapeToExec=0
    MaxRespSize=8192
    Password=
    PortNumber=1025
    PrintOption=N
    ProcedureWithSplSource=Y
    ReportCodePageConversionErrors=0
    SecurityMechanism=
    SecurityParameter=
    ShowSelectableTables=1
    TDProfile=
    TDRole=
    TDUserName=
    4. Restart the Secure Agent after you configure the environment variables.