Interaction between Teradata Alerts and Teradata Database - Teradata Viewpoint

Teradata Viewpoint Installation, Configuration, and Upgrade Guide for Customers

Product
Teradata Viewpoint
Release Number
16.10
Published
June 2017
Language
English (United States)
Last Update
2018-03-29
dita:mapPath
iwr1478709689896.ditamap
dita:ditavalPath
2207_ICUCustomer_vp_1610.ditaval.ditaval
dita:id
B035-2207
lifecycle
previous
Product Category
Analytical Ecosystem
Teradata Alerts has limited interaction with Teradata Database. The three components that interact with the Teradata Database are:
  • BTEQ alert actions
  • SQL alert actions
  • Alerts processed by the Teradata Viewpoint alert request data collector

Teradata Notification Service for Windows and Teradata Notification Service for Linux can execute BTEQ scripts. The version of BTEQ that is installed on the Windows Server or Linux Server must be compatible with the version of the Teradata Database that the BTEQ scripts are executing against.

Teradata Alerts running on the Viewpoint Server executes SQL alert actions using the Teradata JDBC driver. The queries entered by the administrator must be compatible with the Teradata Database where the queries will be executed.

Teradata Viewpoint alert request data collector monitors the dbcmngr.alertrequest and dbcmngr.monitorrequest tables for alert requests. Teradata Alerts supports the same versions of the Teradata Database that Viewpoint monitoring supports.