15.10 - Adding a Data Source - ODBC Driver for Teradata

ODBC Driver for Teradata User Guide

prodname
ODBC Driver for Teradata
vrm_release
15.10
category
User Guide
featnum
B035-2509-035K

When adding or configuring a data source, the odbc.ini file is edited using a text editor.

Each data source listed in the ODBC Data Sources section of the odbc.ini file must have its own Data Source Specification section. See “ODBC Data Sources Section” on page 62 and “Data Source Specification Section” on page 63.

Note: The example in this procedure displays the file extension convention for Solaris, Linux, IBM AIX, and HP-UX Itanium (.so). The file extension for HP-UX PA RISC is .sl. The file extension for Apple OS X is .dylib

1 Open the odbc.ini file using any text editor.

2 Add an entry for the new data source and its corresponding driver in the [ODBC Data Sources] section.

For example, enter the following to assign a data source called [financial] and an ODBC driver called tdata.so:

financial=tdata.so

3 Add a descriptive entry for each data source listed in the [ODBC Data Sources] section to the Data Source Specification section.

For example, to set up a Data Source Specification section called [financial], specify the location of ODBC Driver for Teradata and add a description of the driver, similar to the following:

[financial]
Driver=/opt/teradata/client/ODBC_64/lib/tdata.so
Description=Teradata 5550H running Teradata Database