Creating or Editing a Database Connection - Teradata Analytic Apps - Vantage Analyst

Vantage Analyst with Machine Learning Engine User Guide

Product
Teradata Analytic Apps
Vantage Analyst
Release Number
1.1
Published
December 2019
Language
English (United States)
Last Update
2020-08-06
dita:mapPath
ezh1551894635141.ditamap
dita:ditavalPath
wsp1565965728073.ditaval
dita:id
B035-3805
lifecycle
previous
Product Category
Teradata Vantageā„¢
  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.
    Your database administrator should create an Analytical user login for use with the connection to support all sessions with access to the databases and tables used by the system.
    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.