Create or Edit a Database Connection | Vantage Analyst - 1.1 - Creating or Editing a Database Connection - Vantage Analyst

Vantage Analyst User Guide

prodname
Teradata Analytic Apps
Vantage Analyst
vrm_release
1.1
category
User Guide
featnum
B035-3805-099K
  1. Select "" > Configuration > Connections.
  2. Choose one of the following options:
    Option Action
    Create new Click CREATE NEW.
    Edit exiting Either click the connection or select > Edit.
  3. On the Connection details page, enter a unique Connection name and an optional Description.
  4. On the Connection type page, select Database then enter the Server name and Default database.

    If the Server name is longer than 128 characters, enter an IP address instead.

    You cannot change the Connection type after saving the connection.
  5. [Optional] Specify Connection Properties.

    The TMODE=TERA option prevents issues with table names and column names not matching in case usage (uppercase versus lowercase) when working with rules.

  6. On the Authentication page, enter the Analytical user name and Password. By default, the Analytical user will also perform Tactical tasks. The password is encrypted and cannot be edited after saving the connection. To change the password, click RESET and enter a new password.
    1. To have the Tactical user perform tactical tasks, clear the Use Analytical user for Tactical tasks check box, then enter the Tactical user name and Password.
    2. [Optional] Enter a name in User query band. Use this field to pass additional information to the database to support workload management or query logging.
  7. Click SAVE CONNECTION.