Configuring ODBC Initialization Files - Parallel Transporter

Teradata Parallel Transporter Reference

Product
Parallel Transporter
Release Number
15.00
Language
English (United States)
Last Update
2018-09-27
dita:id
B035-2436
lifecycle
previous
Product Category
Teradata Tools and Utilities

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:

  • That a copy of the ODBC.INI (initialization) file has been installed on your Client platform, and
  • That the ODBC.INI (initialization) file has been configured on your Client platform to specify the:
  • DSNName
  • HostName
  • ServiceName.
  • 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.