Add an Analytics Database (SQL Engine) | Teradata Viewpoint - Adding an Analytics Database - Teradata Viewpoint - Teradata Workload Management

Teradata® Viewpoint User Guide - 24.04

Teradata Viewpoint
Teradata Workload Management
Release Number
April 2024
English (United States)
Last Update
Product Category
Analytical Ecosystem
Add an Analytics Database to the Monitored System portlet to begin collecting data. Your system may be set up for you. Follow these steps if your Analytics Database is not set up.
  1. Next to Systems, select "", then select Add Teradata System.
  2. Under General System Details, enter a system nickname, up to 30 characters.
  3. [Optional] Select the Enable system check box.
    After it is enabled, the system starts collecting data.
  4. Enter the TDPID of the Analytics Database if not shown.
  5. [Optional] Enter the site ID assigned by Teradata Customer Services.
    After enabling a system, the Site ID becomes read-only if Viewpoint detects a value for the system.
    A site ID is required when using Elastic Performance on Demand.
  6. Enter a login name and password.
    Specify an account string and authentication, add more logons, test the logon settings, and grant access to an Analytics Database. Add any logins used for Viewpoint data collection to the system-level bypass. To define system-level bypass settings, use the Workload Designer portlet.
  7. [Optional] Click Test to verify that the login settings are correct.
    If the operation is successful, "" appears. If the operation fails, "" appears. If you receive an error, verify that the login credentials are valid and the host can be reached.
  8. [Optional] Under Authentication Options, specify which authentication mechanisms are available in the portlets.
  9. [Optional] Under Character Set, select default character sets and enter a JDBC Flag value:
    • Select a character set from the Session list.
    • Select a character set from the Monitor list.
    • Enter a JDBC Flag value.
  10. Under Time Zone, select the time zone the system uses to log DBQL and ResUsage data.
  11. [Optional] Under Collectors, select Enable Data Collectors (Configure in Data Collectors) to begin collecting data.
    The data collectors can be enabled and configured individually in Data Collectors.
    Portlet Data Collectors
    Elastic Performance Elastic Limit and Elastic Usage
    TVS Monitor Virtual Storage
    Stats Manager Stats Manager
    Query Log Query Log data collectors for historical DBQL data
  12. [Optional] Under Enhanced TASM Functions, select Enable this option if your Teradata has license entitlement to TASM.
    The workload management features are available with your TASM license on SLES11 or higher.
  13. Select Apply.
    If the operation is successful, "" appears. If the operation fails, "" appears. If you receive an error, verify that the settings are correct and try again.