Setting Up a Teradata ODBC Data Source - Teradata Schema Workbench

Teradata Schema Workbench User Guide

Product
Teradata Schema Workbench
Release Number
16.20
16.10
15.10
Published
June 2015
Language
English (United States)
Last Update
2018-05-25
dita:mapPath
gvf1512702977003.ditamap
dita:ditavalPath
Audience_PDF_include.ditaval
dita:id
B035-4106
Product Category
Teradata Tools and Utilities
Define a data source for each Teradata Database prior to connecting with ODBC. Use the 32-bit Microsoft ODBC Data Source Administrator to create 32-bit ODBC DSNs.

To avoid being prompted for credentials, you can enter your password in the Teradata DSN.

If you do not type an authentication username and password in the ODBC Driver Setup for Teradata Database dialog box while creating a DSN, you will be prompted each time you attempt to access a data source in Teradata Schema Workbench.

Although you will receive a warning about entering a password for a Teradata DSN, it is stored and transmitted in encrypted form.

If you save usernames and passwords in your Teradata DSN, the user must be in either the TBI_WORKBENCH or TBI_USER role. If you plan to use a Teradata DSN with Teradata Schema Workbench, the user must be in the TBI_WORKBENCH role.

For 64-bit versions of Windows, you must use the 32-bit ODBC Data Source Administrator, which is not available from the Control Panel.

  1. Do one of the following:
    • From the Tools menu, click ODBC Admin 32bit.

      The ODBC Data Source Administrator dialog box appears.

    • (32-bit Windows systems) From the Windows Start menu, click Control Panel > Administrative Tools > Data Sources (ODBC).
    • (64-bit Windows systems) Use Windows Explorer to access the 32-bit version of ODBC Data Source Administrator. To do this, locate and run odbcad32.exe from the C:\%WINDIR%\SysWOW64\ directory.
  2. Click the System DSN tab.
  3. Click Add. The Create New Data Source dialog box appears.
  4. Select Teradata.
  5. Click Finish. The ODBC Driver Setup for Teradata Database dialog box appears. Refer to the ODBC Driver for Teradata User Guide (B035-2509) for assistance. See Additional Information.
  6. Type the Data Source Name and the Teradata Server Name(s) or IP address(es).
  7. [Optional] Type an Authentication Username and Password.
  8. Click OK.