Configuring the components for using a reference validation rule

Procedure

Double-click the tMysqlInput component to display its Basic settings.
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.
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.
Click the three-dot button next to the Table field to select the table to check.
Click Guess Query to automatically retrieve the query corresponding to the table schema.
Double-click the tMysqlOutput component to display its Basic settings.
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.
Click the three-dot button next to the Table field to select the table in which you will load the data.
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.
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.

If you find any issues with this page or its content – a typo, a missing step, or a technical error – let us know how we can improve!