Connecting to a Teradata Database - 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

Use the Teradata Visual Explain command line interface to log on to a Teradata Database.

To connect to Teradata Database, use the following command:

VEComp <Logon specification> [-d <qcdname>] 

Table 44 describes commands used to connect to a Teradata Database.

 

Table 44: Examples for Connecting to a Teradata Database 

Example

Command

Description

1

VEComp -l

Display the CLIv2 logon dialog box.

2

VEComp -l SysA\dbc\dbc

Use CLIv2to log on to server SysA.

3

VEComp -l SysA\dbc\dbc -d qcd

Use CLIv2 to log on to server SysA database qcd.

4

VEComp -c

Display the ODBC Data source selection dialog box.

5

VEComp -c SysA

Use the ODBC Data Source SysA to log on.

6

VEComp -l SysA\dbc\dbc -am td2\xxx

Use CLIv2 to log on to server SysA. The authentication mechanism is td2. The authentication parameter is xxx.

7

VEComp -l SysA\dbc\dbc -am NONE\NONE

Use CLIv2 to log on to server SysA. Extended security mechanism is not used.

8

VEComp -l SysA\dbc\dbc -am  td2

Use CLIv2 to log on to server SysA. The authentication mechanism is td2. No authentication parameter is used.

9

VEComp -l SysA\dbc\dbc -am td2\xxx -scs UTF16

Use CLIv2 to log on to source SysA. The authentication mechanism is td2, and xxx is the authentication parameter, using UTF-16 as the session character set.

10

VEComp -c SysA\pwd1 -am td2\xxx

Use ODBC to log on to source SysA. Assumes the DSN is configured with the user name. Connects using td2 as the authentication mechanism and xxx as the authentication parameter.

11

VEComp -c SysA\pwd1 -am td2\xxx -scs UTF16

Use ODBC to log on to source SysA. Assumes the DSN is configured with the user name. Connects using td2 as the authentication mechanism and xxx as the authentication parameter, using UTF-16 as the session character set.

12

VEComp -c SysA\pwd1 -am      xxx

Use ODBC to log on to source SysA. Assumes the DSN is configured with the user name and the authentication mechanism. Connects using xxx as the authentication parameter.

13

VEComp -c SysA\user1\pwd1 -am xxx

Use ODBC to log on to source SysA. Assumes the DSN is configured with the authentication mechanism. Connects using xxx as the authentication parameter.

14

VEComp -c SysA\pwd1 -am NONE\NONE

Use ODBC to log on to server SysA. Assumes the DSN is configured with the user name. No extended security mechanism is used.

Note: The -am switch is optional and should be used in conjunction with the -l or -c logon switches. It is possible to connect to Teradata Database using the direct user authentication mechanisms without specifying the -am switch. However, to use multiple connections (which are required when using the bulk compare feature or loading multiple online plans), the authentication mechanism must be supplied for all connections or none of the connections. That is, the -am switch must be supplied for all of the connections or not used for any connection.

To use an alternate logon mechanism for one server and not use any alternate logon mechanism for another specific server, the -am switch must be supplied for the specific server as -am NONE\NONE.