Creating a Custom Driver Name - ODBC Driver for Teradata

ODBC Driver for Teradata® User Guide - 17.20

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
Lake
VMware
Product
ODBC Driver for Teradata
Release Number
17.20
Published
June 2022
Language
English (United States)
Last Update
2023-11-18
dita:mapPath
uqj1639470627591.ditamap
dita:ditavalPath
nkw1500504256726.ditaval
dita:id
ktb1507075385726
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/17.20/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 17.20. Navigate to the directory that contains the instdrv tool and execute the following command:

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

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

The odbcinst.ini for SEN on Mac OS:

[ODBC Drivers]
Teradata Database ODBC Driver 17.20=Installed

[Teradata Database ODBC Driver 17.20]
Description=Teradata Database ODBC Driver 17.20
Driver=/Library/Application Support/teradata/client/17.20/lib/tdataodbc_sb64.dylib
Setup=/Library/Application Support/teradata/client/17.20/lib/TeradataODBCSetup.bundle/Contents/MacOS/TeradataODBCSetup