Adding a Data Source - ODBC Driver for Teradata

ODBC Driver for Teradata® User Guide

Product
ODBC Driver for Teradata
Release Number
16.20
Published
August 2020
Language
English (United States)
Last Update
2020-08-25
dita:mapPath
fxv1527114222338.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, and IBM AIX (.so). The file extension for Apple macOS 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 tdataodbc_sbu.so:

    financial=tdataodbc_sbu.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/tdataodbc_sbu.so
    Description=Teradata 5550H running Teradata Database