Connecting to a Teradata Database

Teradata Visual Explain User Guide

brand
Teradata Tools and Utilities
prodname
Visual Explain
vrm_release
16.10
16.20
category
User Guide
featnum
B035-2504-086K
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>]

Example Commands for Connecting to Teradata Database

The following table describes commands used to connect to a Teradata Database.

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.
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.