Specifying the Type of Connectivity - Visual Explain

Teradata Visual Explain User Guide

Product
Visual Explain
Release Number
15.10
Language
English (United States)
Last Update
2018-10-07
dita:id
B035-2504
lifecycle
previous
Product Category
Teradata Tools and Utilities

The type of connectivity used to log on to Teradata Database can be specified before logging on or changed after logging on to Teradata Database. The available connectivity types are ODBC or CLIv2.

Note: A connection to Teradata Database is required in order to use most features in Teradata VE.

1 From the menu bar, click Tools > Options.

The Options dialog box appears, and the Connectivity tab is selected.

2 Select ODBC or CLIv2.

3 Click Apply.

4 Click OK to close the Options dialog box.

For information on how to log on using ODBC, see “Defining a Data Source and Connecting through ODBC” on page 56. To log on using CLIv2, see “Connecting through CLIv2” on page 57.

To change connectivity type after connecting to a Teradata Database, follow this procedure.

Note: If the connectivity type is changed while an execution plan is open, a message appears warning that information about the plan will be lost and providing the option to continue.

1 Click Tools > Options.

The Options dialog box appears.

2 Click the Teradata Database Connectivity tab.

3 Click Specify Connection type (CLIv2/ODBC).

The Teradata Database Connectivity dialog box appears.

4 Select ODBC or CLIv2.

5 Click OK.

A message appears providing the option to terminate the connection.

6 Click Yes.

The connection is terminated. Clicking No retains the current connection and returns to the Teradata Database Connectivity dialog box.

For information on how to log on using ODBC, see “Defining a Data Source and Connecting through ODBC” on page 56. To log on using CLIv2, see “Connecting through CLIv2” on page 57.