Teradata Connector > Teradata ODBC SQL ELT optimization > Configuring the Teradata ODBC driver
  

Configuring the Teradata ODBC driver

Teradata supports Teradata ODBC drivers on Windows and Linux systems. You must install the Teradata ODBC 64-bit driver based on your system requirement.

Configuring Teradata ODBC driver on Windows

Before you establish an ODBC connection to connect to Teradata on Windows, you must configure the Teradata ODBC drivers.
Perform the following tasks to configure the Teradata ODBC driver on Windows:
  1. 1Download and install the Teradata ODBC 64-bit drivers on the machine where the Secure Agent is installed.
  2. 2Run the odbcad32.exe file.
  3. 3In the ODBC Data Source Administrator dialog box, click System DSN.
  4. 4Configure the applicable Teradata connection settings.

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 environment variables for the driver and create the DSN entries.
    1Add 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"
    2To set the LD_LIBRARY_PATH environment variable, use the following syntax:
    setenv LD_LIBRARY_PATH "/opt/teradata/client/<Version>/lib64"
    3Add 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=
    4Restart the Secure Agent after you configure the environment variables.