Creating a Custom Driver Name - ODBC Driver for Teradata

ODBC Driver for Teradata User Guide

Product
ODBC Driver for Teradata
Release Number
16.10
Published
May 2017
Language
English (United States)
Last Update
2018-07-11
dita:mapPath
smj1488824663219.ditamap
dita:ditavalPath
Audience_PDF_product_legacy_odbc_include.ditaval
dita:id
B035-2526
lifecycle
previous
Product Category
Teradata Tools and Utilities

A custom driver name can be created using the instdrv tool. By default, the tool is located in /Library/Application Support/teradata/client/16.00/odbc/bin/odbcinst.ini file to include more driver names.

For example, suppose the driver name Teradata is hardcoded in your application and you need to connect using the driver name Teradata rather than the default name of Teradata Database ODBC Driver 16.00. Navigate to the directory that contains the instdrv tool and execute the following command:

sudo ./instdrv -i "Teradata;Driver=/Library/Application Support/teradata/client/16.00/lib/tdata.dylib;Setup=/Library/Application Support/teradata/client/16.00/lib/TeradataODBCSetup.bundle/Contents/MacOS/TeradataODBCSetup"

Below is the resulting odbcinst.ini file with two driver names for the16.00 driver.

[ODBC Drivers]
Teradata Database ODBC Driver 16.00 = Installed
Teradata = Installed 
[Teradata Database ODBC Driver 16.00]
Driver = /Library/Application Support/teradata/client/16.00/lib/tdata.dylib
Setup  = /Library/Application Support/teradata/client/16.00/lib/TeradataODBCSetup.bundle/Contents/MacOS/TeradataODBCSetup
[Teradata] 
Driver = /Library/Application Support/teradata/client/16.00/lib/tdata.dylib 
Setup = /Library/Application Support/teradata/client/16.00/lib/TeradataODBCSetup.bundle/Contents/MacOS/TeradataODBCSetup