Configuring ODBC Initialization Files - Parallel Transporter

Teradata® Parallel Transporter Reference

Product
Parallel Transporter
Release Number
17.00
Published
November 2020
Language
English (United States)
Last Update
2022-02-03
dita:mapPath
ric1544831938741.ditamap
dita:ditavalPath
obe1474387269547.ditaval
dita:id
B035-2436
lifecycle
previous
Product Category
Teradata Tools and Utilities

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