You can generate ready-to-use Jobs on the reports listed in the Profiling perspective of the studio.These Jobs use the tThresholdViolationAlert component to alert to any threshold violations of the thresholds defined on the indicators used in column analyses.
The tThresholdViolationAlert component communicates with the report database that stores the analysis results. It scans the report database looking for the thresholds that are violated in the column analyses listed in the selected report. tThresholdViolationAlert sends the information to the tSendMail component to alert the email recipient(s) to the threshold violations.
You can generate Jobs with the tThresholdViolationAlert component only on reports which database is Mysql or Oracle.
Later, you can execute this Job directly from the Integration perspective to send an email to defined people to alert them to threshold violation. The generated Job will be listed under the Job Designs node in the Repository tree view.
Prerequisite(s): A report has already been generated on a column analysis in the Profiling perspective of the studio. The report database is either Mysql or Oracle.
To generate a threshold violation Job, do the following:
In the DQ Repository tree view, expand Data Profiling > Reports.
Select the report(s) on which you want to generate a Job.
Right-click your selection and place your pointer on Generate jobs in the contextual menu then select Alert threshold violation.
The Integration perspective opens on the generated Job.
The basic settings of the tMysqlInput and tThresholdViolationAlert components are configured according to the connection used in the selected report.
It is recommended to leave the settings of the tMysqlInput and tThresholdViolationAlert components unchanged. Be careful if you need to edit these settings, otherwise you may have a compile error when you try to execute the Job.
In the schema of the database component and the tThresholdViolationAlert component, the DB Type column is empty by default. You do not need to define the type in this column.
Accept propagating the changes when prompted by the system.
Double-click tSendMail to display its Basic settings view and define its properties as needed.
For more information on this components, see Talend Components Reference Guide.
Press F6 to execute the generated Job and send the threshold violation alert email to the defined people.
This email holds detail information about the threshold violations in the selected report. It lists the values of the indicators which do not respect the thresholds. It also lists the report name, the analysis name and the analyzed element description (column name, table name and schema name).
The generated Job is listed as well under the Job Designs node in the tree view of the Integration perspective.
When needed, press F6 to execute this Job and alert to any threshold violation directly from the Integration perspective.