Enabling foreign key integrity checking - 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

You can enable foreign key integrity checking to manage whether users are allowed to delete a record that is linked to another record through a foreign key. By default, this is not allowed.

About this task

To enable foreign key integrity checking:

Procedure

  1. In the MDM Repository tree view, expand the Data Model node and double-click the data model for which you want to enable foreign key integrity checking.
    The corresponding editor opens with the selected data model displayed.
  2. Select the entity containing the foreign key for which you want to enable integrity checking.
  3. In the Properties view, click the Relationship tab.
  4. Under the Foreign Key section:
    • Select the Enforce FK integrity check box to enable foreign key integrity checking, that is, to raise an error whenever a user tries to delete a record if the record is linked to any other records through this foreign key.
    • Select the Allow FK integrity override check box to allow users to force the delete of a record even if it is linked to another record through this foreign key.
    These two options can be combined in the following ways:
    • If both Allow FK integrity override and Enforce FK integrity are enabled, users can delete a linked record and are prompted for override.
    • If Allow FK integrity override is enabled and Enforce FK integrity is disabled, users can delete a linked record.
    • If Allow FK integrity override is disabled and Enforce FK integrity is enabled, users cannot delete a linked record.
    • If both Allow FK integrity override and Enforce FK integrity are disabled, users can delete a linked record.
    In the case of conflicts, the least tolerant rule is always applied.
    If a user is prevented from deleting a record, details are provided in <$INSTALLDIR>/logs/mdm.log.