Data Source Specification Section - ODBC Driver for Teradata

ODBC Driver for Teradata User Guide

Product
ODBC Driver for Teradata
Release Number
15.10
Language
English (United States)
Last Update
2018-10-07
dita:id
B035-2526
lifecycle
previous
Product Category
Teradata Tools and Utilities

Each data source listed in the ODBC Data Sources section [<data-source-name>] of the odbc.ini file includes its own Data Source Specification section. These sections have the following format:

[<data-source-name>]
Driver=<driver-path>
Keyword=<attribute>

The lines following the data source name define the required and optional attributes.

Table 22 contains the available options that can be entered into the Data Source Specification section.

See Appendix D for examples of ODBC options files.

 

Table 22: Data Source Specification Section Keywords 

Keyword/Synonym

Description

Driver=<driver-path>

[Required] The full path to the ODBC Driver for Teradata shared objects.

  • Solaris, Linux, IBM AIX, and HP-UX Itanium - <Install_Dir>/teradata/client/ODBC/lib/tdata.so
  • HP-UX PA RISC - <Install_Dir>/teradata/client/ODBC/lib/tdata.sl
  • Apple OS X - /Library/Application Support/Teradata/Client/ODBC/lib/tdata.dylib
  • Description=<data-source-desc>

    [Optional] Descriptive text about the data source.

    DBCName=<IP-addr-or-alias>

    [Required] The IP address or FQDN (fully qualified domain name) of the Teradata server.

    When a name is specified, ODBC Driver for Teradata automatically detects associated COP entries. For example, if the name contains a COPx suffix. For more information, see “Cop Discovery” on page 51.

    Username=<name>

    Or

    UID=<name>

    [Optional] The default username for logging onto a Teradata server system.

    Password=<password>

    [Optional] The password required for the default Username.

    Notice:

    The odbc.ini file has no password security. The password is retained in unencrypted plain text and can be viewed by any user with read-access to the file. Using this feature is not recommended, because it is deprecated. For more information, see Appendix E: “Deprecated Features.”

    You can use a Teradata Wallet reference string instead of a plain text password by specifying the $tdwallet() token. For example:

    Password=$tdwallet(WalletRefString)

    For more information, see “Teradata Wallet” on page 98.

    DefaultDatabase=<database-name>

    Or

    Database=<database-name>

    [Optional] The default database associated with the specified data source.

    When no value is specified for this field, it is assigned the value of the user name as entered into the Username field.

    This field entry can be overridden when a new connection is specified.

    All catalog functions are associated with the default database if a table owner is not specified.