Checking customer table against a given DQ rule to select customer records - Cloud - 8.0

MySQL validation

Version
Cloud
8.0
Language
English
Product
Talend Big Data Platform
Talend Data Fabric
Talend Data Management Platform
Talend Data Services Platform
Talend MDM Platform
Talend Real-Time Big Data Platform
Module
Talend Studio
Content
Data Governance > Third-party systems > Data Quality components > Validation components (Integration) > MySQL validation components
Data Quality and Preparation > Third-party systems > Data Quality components > Validation components (Integration) > MySQL validation components
Design and Development > Third-party systems > Data Quality components > Validation components (Integration) > MySQL validation components
Last publication date
2024-02-20

This scenario applies only to Talend Data Management Platform, Talend Big Data Platform, Talend Real-Time Big Data Platform, Talend MDM Platform, Talend Data Services Platform, Talend MDM Platform and Talend Data Fabric.

For more technologies supported by Talend, see Talend components.

This example is a three-component Job that checks a MySQL customer table against a given data quality rule so as to query specific customer records.

The components used in the Job are:

  • tMysqlConnection: this component creates the connection to the MySQL database so that the other components can reuse it.

  • tMySQLInvalidRows: this component reuses the connection created by tMysqlConnection and query the customer records against the given data quality rule.

  • tLogRow: this component presents the result of running this Job.
    Remember: The connection components, including tMysqlConnection and tMySQLInvalidRows, have been regrouped into the tDBConnection component. They are automatically converted into this component when you place them on the workspace.