Setting up the schema - Cloud - 8.0

MySQL

Version
Cloud
8.0
Language
English
Product
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 Real-Time Big Data Platform
Module
Talend Studio
Content
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
2024-02-29

Procedure

  1. Double-click tDBInvalidRows to display its Basic settings view and define its properties.
    All database connection fields are automatically filled in. If you do not define your input files in the Repository, fill in the details manually after selecting Built-in in the Property Type field
  2. From the Validation type list, select Regex pattern validation.
    This will validate data in the selected rows against a regex pattern. For an example about validating data against DQ rule, see Checking customer table against a given DQ rule to select customer records.
  3. In the Table Name field, type in the name of the database table on which you want to run the Job, customer1 in this example.
  4. In the Where clause field, type in the WHERE clause that will restrict the number of the analyzed rows.
    In this example, you want to examine only the emails of the customers from the USA.
  5. In the Analyzed column list, select the column you want to analyze, Email in this example.
  6. In the Patterns list, select the Talend Studio database pattern against which you want to check addresses from the Email column, Email Address in this example.
    If you select the Custom pattern check box, you can customize the regular expression against which you want to check the data.
  7. Double-click tLogRow to open its Basic settings view and define its properties as needed.