Reading email addresses from a DB table and retrieving specific data
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.
- 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.
- 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 email address pattern.
In this example, you 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 Using centralized metadata in a Job.