Adding a Data Source - 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

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 and Data Source Specification Section.

The example in this procedure displays the file extension convention for Solaris, Linux, IBM AIX, and HP-UX Itanium (.so). 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