Step 1 - Define a Data Source - Teradata Administrator

Teradata Administrator User Guide

Teradata Administrator
Release Number
English (United States)
Last Update
Product Category
Teradata Tools and Utilities

Define a data source for each Teradata Database prior to connecting with ODBC. Use the ODBC Data Source Administrator to create ODBC data sources and to configure the drivers.

Note: When defining the UserId, do not use a collation sequence of EBCDIC as this might cause unpredictable sorting results.

Use the following procedure to define a data source.

1 From the main window, click File > Define Data Source.

The ODBC Data Source Administrator dialog box appears and displays the User DSN tab by default.

2 Click the Drivers tab, and ensure the required ODBC driver is installed on your system.

3 Click the System DSN tab or User DSN tab, and then click the Add button.

The Create New Data Source dialog box appears.

4 Select the Teradata ODBC driver, and then click Finish.

The ODBC Driver Setup for Teradata Database dialog box appears.

5 Enter the following fields.

For in depth information, refer to the ODBC Driver for Teradata User Guide.

  • Name – Name for the data source.
  • Type a unique description such as Payroll or Accounts Payable.

  • [Optional] Description – Descriptive text about this data source.
  • Name(s) and IP address(es) – Name or IP address of the server of your Teradata Database to connect to.
  • Do not resolve alias name to IP address – Select to not resolve alias names during set up. Clear this check box to allow aliases to be resolved whenever connecting to a database.
  • Use Integrated Security – Select to connect to the database through Single Sign On (SSO). The Mechanism, Parameter, Username and Password boxes are unavailable and your logon information is authenticated by network security when logging on to your computer.
  • [Optional] Mechanism – If a security mechanism is in place, select the authentication mechanism.
  • [Optional] Parameter – If a mechanism is selected, enter the applicable authentication string.
  • [Optional] Username – User name to use to log on to the Teradata Database.
  • [Optional] Password – Password for the user name.
  • [Optional] Default Database – Database to work in by default. Use unqualified object names only in this database; qualify all other objects using the database name. If this field is left blank, the default database is your username.
  • [Optional] Account String – Account string associated with the user name.
  • Session Character Set – Specify the default character set for the session. To use a different character set, select from the pull-down menu. The default is ASCII.
  • Note: When connecting to Teradata Database V2R6.2.x or earlier, do not use UTF8 or UTF16 session character sets if the system contains Kanji object names. If any Kanji Database or User names exist on the system, the initial loading of the database tree fails.

    Note: When connecting to Teradata Database 12.00.00 or later, do not choose ASCII if any Kanji Database or User names exist on the system. Choose UTF8 or UTF16 session character sets so that the information displays correctly on the page.

    6 Click OK twice.

    After these steps are completed, continue with the configuration by going to the next procedure, “Step 2a - Set Database Options” on page 35.