Connecting to the Database
Before working with Teradata WA, a connection to the Teradata Database as user tdwm must be established. No local mode is available.
Note: User tdwm must be created before continuing. Create this user by running a DIP script. For more information about DIP scripts, see Utilities: Volume 1 (A-K) (B035‑1102).
To connect to the Teradata Database as user tdwm
1 Open the Connect to Teradata Database dialog box by doing one of the following:
Ctrl+L
.
2 In the Connect to Teradata Database dialog box, enter the database connection parameters. See Table 1.
Option |
Description |
System (DBS) Name |
Name of the database to connect to; Teradata WA uses this to store workload definitions and related data. |
User Name |
Teradata WA requires the user to log on as user tdwm. The name in this field cannot be edited. |
Password |
Password associated with the user tdwm. Note: The default password for this user is tdwmadmin. To change this password, use the MODIFY USER statement. For information about using this statement, see Database Administration (B035‑1093). |
Session Character Set |
This option is not available. A DIP script creates a default character session set [ASCII for standard, KAJISJIS_0S for Kanji-enabled systems (Japanese)]. By default, a UTF-16 character set is displayed. For more information about DIP scripts, see Utilities: Volume 1 (A-K) (B035‑1102). |
3 [Optional] Click More to reveal advanced login options. See Table 2.
Option |
Description |
Authentication Mechanism |
Select the authentication mechanism value in the list box. |
Authentication Parameter |
Type the appropriate authentication parameter for the selected authentication mechanism. |
Default Database |
Select the default database used, if any. |
Account String |
Select the account string, if any. |
4 Click OK.
When connected, the Teradata Workload Analyzer window displays the following:
Ready
Logged on to
database_name as
user_name.
To disconnect from the database
✔ Disconnect from the database by doing one of the following:
CTRL+G
.