Step 1 - Define a Data Source
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.
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.
Type a unique description such as Payroll or Accounts Payable.
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.