Connecting Through ODBC - Teradata Index Wizard

Connecting Through ODBC

Teradata Index Wizard allows you to connect to a Teradata Database via ODBC.

To connect using ODBC

The ODBC connection procedure assumes you have already created a data source. If you have not defined a data source, do so before connecting. See “Defining a Data Source” on page 36.

1 Select File > Connect or click .

The Please Select a Data Source dialog box opens.

2 Select a data source, and click OK.

The Teradata Database Connect dialog box opens. To fill in the fields, refer to ODBC Driver for Teradata User Guide.

You are now logged on to the selected Teradata Database.

If errors occur, see “Connection Errors” on page 38.

3 Go to the next step, “Defining a Workload” on page 40.

Defining a Data Source

Use the ODBC Data Source Administrator to create ODBC data sources. You can also use the ODBC Data Source Administrator to configure some features of the drivers installed on your system.

To define a data source

1 Open the Microsoft ODBC Data Source Administrator using one of these options:

From the Teradata Index Wizard main window, select Tools > Define Data Source.

Or, from your Windows desktop, select Start > Programs > ODBC > 32-bit ODBC Administrator.

The ODBC Data Source Administrator dialog box opens.

2 Open the Create New Data Source dialog box using one of these options:

From the System DSN tab, click Add.

Or, from the User DSN tab, click Add.

3 From the Drivers list, select Teradata.

4 Click Finish.

The ODBC Driver Setup for Teradata Database dialog box opens. This dialog box is specific to your Teradata Database.

5 Fill out the information in this dialog box. Refer to ODBC Driver for Teradata User Guide.