Reading email addresses from a DB table and retrieving specific data - Cloud - 8.0


Talend Big Data
Talend Big Data Platform
Talend Data Fabric
Talend Data Integration
Talend Data Management Platform
Talend Data Services Platform
Talend ESB
Talend MDM Platform
Talend Open Studio for Big Data
Talend Open Studio for Data Integration
Talend Open Studio for ESB
Talend Real-Time Big Data Platform
Talend Studio
Data Governance > Third-party systems > Database components (Integration) > MySQL components
Data Quality and Preparation > Third-party systems > Database components (Integration) > MySQL components
Design and Development > Third-party systems > Database components (Integration) > MySQL components
Last publication date

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 example is a two-component Job created in Talend Studio. In this example, tMySQLInvalidRows:
  1. Reads the email addresses for people from a specific country from a MySQL database table.
  2. Filters data using a WHERE clause to narrow down the validation process.
  3. Checks the email values against the given Talend Studio email pattern.
  4. 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.