For more technologies supported by Talend, see Talend components.
This scenario is a three-component Job that checks a MySQL customer table against a given data quality rule so as to query specific customer records.
These components used in the Job are:
-
tMysqlConnection: this component creates the connection to the MySQL database of interest so that the other components can reuse it.
-
tMySQLInvalidRows: this component reuses the connection created by tMysqlConnection and query the customer records of interest against the given data quality rule.
-
tLogRow: this component presents the result of running this Job.
To replicate this scenario, proceed as illustrated in the following sections: