Overview - Advanced SQL Engine - Teradata Database

Application Programming Reference

Product
Advanced SQL Engine
Teradata Database
Release Number
17.05
17.00
Published
June 2020
Language
English (United States)
Last Update
2021-01-22
dita:mapPath
cpn1571792172880.ditamap
dita:ditavalPath
lze1555437562152.ditaval
dita:id
B035-1090
lifecycle
previous
Product Category
Teradata Vantage™

Teradata Vantage™ is our flagship analytic platform offering, which evolved from our industry-leading Teradata® Database. Until references in content are updated to reflect this change, the term Teradata Database is synonymous with Teradata Vantage.

This is a reference document for the Teradata Vantage application programming interfaces (APIs). It describes the following types of APIs and how they can be used to interface with your own custom applications when other tools (such as, resource usage reports) or client applications do not provide the information you need:
  • Workload Management API

    Workload management APIs can be used for creating third-party applications and custom applications requiring the acquisition and use of Teradata workload management and performance data.

    Note that the workload management PM/APIs described in this document use monitor software versions 11 and earlier (see MONITOR VERSION for details). These PM/APIs allow you to create new applications and enhance existing custom applications.

  • Automated Statistics Management API

    The Automated Statistics Management open APIs can be issued from the Teradata Viewpoint Stats Manager portlet or directly from within customer applications. They can be used to accurately identify unused or out of date statistics, cardinality estimation errors, and override SQL COLLECT STATISTICS statement settings in certain well-defined scenarios.