Installing and Configuring the ODBC Driver - Teradata Meta Data Services

rpm -i RPM file name

where RPM file name is the name of the ODBC rpm file to install. For example:

rpm -i tdodbc-15.00.00.01-1.noarch.rpm

The Open Database Connectivity (ODBC) Driver for Teradata package installs a .odbc.ini file as shown in the following example:

[ODBC]
InstallDir=/usr/odbc
Trace=0
TraceFile=/usr/joe/odbcusr/trace.log
TraceAutoStop=0
[ODBC Data Sources]
MDSDSN=tdata.so
default=tdata.so
SYSTEMIDSN=tdata.so
[MDSDSN]
Driver=/usr/odbc/drivers/tdata.so
Description=MDS Repository
DBCName=208.199.59.208
LastUser=
Username=
Password=
Database=
DefaultDatabase=
[SYSTEM1DSN]
Driver=/usr/odbc/drivers/tdata.so
Description=Teradata V13.0 System
DBCName=208.199.59.209
LastUser=
Username=
Password=
Database=
DefaultDatabase=
[default]
Driver=/usr/odbc/drivers/tdata.so
Description=NCR 5500 running Teradata V13.0
DBCName=208.199.59.209
LastUser=
Username=
Password=
DefaultDatabase=

There must be a .odbc.ini file everywhere that MDS core files are (or will be) installed. The .odbc.ini file is usually in the /root directory, but the ODBCINI environment variable can be used to find the file if it is in another location.

1. In the [ODBC Data Sources] section, add a line with the DSN name as follows:
   • There is only one MDS repository system, and its DSN will be supplied to the mdsconfig utility later. Enter that DSN information into the .odbc.ini file now.
   • One or more Teradata Database systems will be tracked by MDS, and one of those systems might be the MDS repository system. Enter the DSN information for each of those systems if it is not already in the .odbc.ini file.

   The line has the form:

   DSN name a=tdata.so

2. For each DSN line added to the [ODBC Data Sources] section, add a new section with the following information:

   [DSN name x]
   Driver=/usr/odbc/drivers/tdata.so
   Description=
   DBCName=system name
   LastUser=
   Username=
   Password=
   Database=
   DefaultDatabase=