Creating a validation rule - Cloud - 8.0

Talend Studio User Guide

Version
Cloud
8.0
Language
English
Product
Talend Big Data
Talend Big Data Platform
Talend Cloud
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
Design and Development
Last publication date
2024-02-29
Available in...

Data Fabric

MDM Platform

About this task

You can create validation rules to define constraints between elements in an entity so that the data records that pertain to the entity will be checked against the validation rules when you save these data records from Talend MDM Web UI.

The following example shows how to create a validation rule for the Agent entity to ensure that the year specified for the TermDate element is larger than that for the StartDate element.

Procedure

  1. In the Data Model Entities area, click the entity on which you want to define a validation rule.
  2. In the Properties view, click the Rules tab.
    The Validation Rule tab is displayed.
  3. Click the button on the left to open the Add a Validation Rule dialog box.
  4. Enter a name for the new validation rule, CheckDate in this example, and click OK.
  5. Click the button under the table to add a new line.
  6. Click in the Type column and select from the list assert or report according to what type of rule you want to set.
    The assert elements are instantiated if the XPath expression evaluates to false and are used to detect errors, while the report elements are instantiated if the expression evaluates to true and are used to report the existence of an instance.
    In this example, select assert.
  7. Click in the Context XPath column and set the Xpath to the element for which you want to create a validation rule, TermDate in this example.
  8. Click in the Expression column and then click the ... button to open the Build Validation Rule Expression dialog box, where you can set the criteria for the validation rule.
    In this example, use the expression editor to create an expression fn:yearFromDate(/Agent/TermDate) > fn:yearFromDate(/Agent/StartDate) so that whenever the year specified in TermDate is not larger than that in StartDate, an error will be reported.
  9. Click in the Message column, then click the ... button to open a dialog box, where you can define multilingual messages to be displayed when the criteria set for the validation rule fail to be met, and click OK.
    In this example, the English and French messages are added.

Results

Deploy the modified data model to the MDM server, and then go to Talend MDM Web UI to verify that the validation rule takes effect.