16.10 - Configuring ODBC Initialization Files - Parallel Transporter

Teradata Parallel Transporter Reference

Product
Parallel Transporter
Release Number
16.10
Published
July 2017
Content Type
Programming Reference
Publication ID
B035-2436-077K
Language
English (United States)

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