Configuring ODBC Initialization Files
Before using the ODBC operator, you must configure the ODBC initialization file on your platform to designate the DSN (data source name) in 'ODBC Data Sources' to point to the proper data source.
Following is a sample ODBC.ini file for a Solaris client system. It shows data source information for Teradata, ORACLE, and SQLServer data sources.
[ODBC]
InstallDir=/usr/odbc
Trace=0
TraceFile=/usr/joe/odbcusr/trace.log
TraceAutoStop=0
[ODBC Data Sources]
testdsn=tdata.so
default=tdata.so
Teradata=tdata.so
Oracle=DataDirect 4.10 Oracle
SQLServer Wire Protocol=DataDirect 4.10 SQL Server Wire Protocol
[testdsn]
[default]
[Teradata]
[Oracle]
Driver=/opt/odbc/lib/ivor818.so
Description=DataDirect 4.10 Oracle
LogonID=oracle
Password=oracle
ServerName=DBCName=200.001.001.01
CatalogOptions=0
ProcedureRetResults=0
EnableDescribeParam=0
EnableStaticCursorsForLongData=0
ApplicationUsingThreads=1
[SQLServer Wire Protocol]
Driver=/opt/odbc/lib/ivmsss18.so
Description=DataDirect 4.10 SQL Server Wire Protocol
Database=db
LogonID=uid
Password=pwd
Address=sqlserverhost,1433
QuotedId=No
AnsiNPW=No
The Following is another sample ODBC.ini file for a Solaris client system, using Simba's Oracle ODBC Driver:
[ODBC]
InstallDir=/usr/odbc
Trace=0
TraceFile=/usr/joe/odbcusr/trace.log
TraceAutoStop=0
[ODBC Data Sources]
testdsn=tdata.so
default=tdata.so
Teradata=tdata.so
Oracle=Simba Oracle ODBC Driver 32-bit
[testdsn]
[default]
[Teradata]
[Oracle]
Driver=/opt/simba/oracleodbc_32/lib/libsimbaoracleodbc32.so
Description=Simba Oracle ODBC Driver(32-bit) DSN
HOST=200.001.001.01
PORT=1521
UID=oracle
PWD=oracle
SVC=oracle.service.name
MEMLIM=104857600
Prerequisites
Because using the ODBC operator in a Teradata PT job script requires:
This enables your Teradata PT script (through the DSNName in the ODBC.INI file and the same DSNName attribute for the ODBC operator) to know that name of the system on which the Oracle database resides (identified in the ODBC.INI file by the Oracle HostName and ServiceName).
For the procedure for configuring the ODBC.INI file on your Client platform with the DSNName and the Oracle HostName and ServiceName chapter 2.