Configuring the components for using a reference validation rule - 7.3

Data Integration Job Examples
Version
7.3
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 Open Studio for Big Data
Talend Open Studio for Data Integration
Talend Open Studio for ESB
Talend Real-Time Big Data Platform
Module
Talend Studio
Content
Design and Development > Designing Jobs
Last publication date
2023-11-13

Procedure

  1. Double-click the tMysqlInput component to display its Basic settings.
  2. Select Repository as Property type and click the three-dot button next to the field to retrieve the connection properties that corresponds to the metadata you want to check.
  3. Select Repository from the Schema drop down list and click the three-dot button next to the field to retrieve the schema that corresponds to your database table.
  4. Click the three-dot button next to the Table field to select the table to check.
  5. Click Guess Query to automatically retrieve the query corresponding to the table schema.
  6. Double-click the tMysqlOutput component to display its Basic settings.
  7. Select Repository as Property type and click the three-dot button next to the field to retrieve the connection properties that corresponds to the database table in which you want to load the new data.
  8. Click the three-dot button next to the Table field to select the table in which you will load the data.
  9. In the Action on table list, select Default and in the Action on data list, select the action corresponding to the one(s) defined in the validation rule you apply on the Job. Here, as we selected On insert and On update in the referential check validation rule we use, so select Update or insert to trigger the rule.
  10. If the schema of the input and output components did not synchronize automatically, click Sync columns and the schema of the input flow will automatically be retrieved.