17.20 - Adding a Data Source - ODBC Driver for Teradata

ODBC Driver for Teradata® User Guide

Product
ODBC Driver for Teradata
Release Number
17.20
Published
June 2022
Language
English (United States)
Last Update
2022-06-21
dita:mapPath
uqj1639470627591.ditamap
dita:ditavalPath
nkw1500504256726.ditaval

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_sb64.so:

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