Adding a Data Source

ODBC Driver for Teradata® User Guide

prodname
ODBC Driver for Teradata
vrm_release
16.20
category
User Guide
featnum
B035-2526-108K

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 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 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