Table of Contents

Search

  1. Preface
  2. Introduction to ODBC Connector
  3. ODBC connections
  4. Synchronization tasks with ODBC Connector
  5. Mappings and mapping tasks with ODBC Connector
  6. SQL ELT optimization
  7. Data type reference

ODBC Connector

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.

0 COMMENTS

We’d like to hear from you!