Reading email addresses from a DB table and retrieving specific data

MySQL validation

author
Talend Documentation Team
EnrichVersion
6.5
EnrichProdName
Talend MDM Platform
Talend Data Fabric
Talend Data Management Platform
Talend Real-Time Big Data Platform
Talend Big Data Platform
Talend Data Services Platform
task
Data Quality and Preparation > Third-party systems > Data Quality components > Validation components > MySQL validation components
Data Governance > Third-party systems > Data Quality components > Validation components > MySQL validation components
Design and Development > Third-party systems > Data Quality components > Validation components > MySQL validation components
EnrichPlatform
Talend Studio

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

For more technologies supported by Talend, see Talend components.

This scenario is a two-component Job created in Talend Studio . In this Job, tMySQLInvalidRows reads the email addresses for people from a specific country from a MySQL database table, filters data using a WHERE clause to narrow down the validation process, checks the email values against the given Talend Studio email pattern and finally extracts filtered data including the invalid rows and displays them on the console.

Below is the database table used in this example, some customers are from the USA and others are from Canada. The Email column contains some invalid addresses. The tMySQLInvalidRows component filters data in the Email column to read only the emails for the customers from the USA, and then validates these email addresses against the EmailAddress pattern.

In this scenario, we have already stored the schemas of the input table in the Repository. For more information about storing schema metadata in the Repository tree view, see Talend Studio User Guide.