Creating a simple View that displays the foreign key information - 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

The simple views you create on business entities in Talend Studio enables business users using Talend MDM Web UI to visualize specific records/attributes in this entity according to the defined criteria.

Prerequisite(s): You have already connected to the MDM server from Talend Studio. You have the appropriate user authorization to create a View.

Consider as an example that your data model holds the Agency and Agent entities. You have added a foreign key attribute, AgencyFK, in the Agent entity that points to the Agency entity. This attribute will link every agent to an agency.

For further information, see Adding a foreign key: linking entities together.

To create a simple View that displays the foreign key information, do the following:

Procedure

  1. Follow the steps outlined in Creating and defining a simple View to create a simple view on the Agent entity.
  2. In the Viewable Business Elements table, click the button to add a new XPath line.
  3. In the new XPath line, click the three-dot button to open a dialog box.
  4. Select the foreign key element to be retrieved by the View, AgencyFK in this example.
  5. Click the save icon on the toolbar or press Ctrl + S on your keyboard to save your View.

Results

The newly created View is listed under the View node in the MDM Repository tree view.

Using Talend MDM Web UI, an authorized business user can now visualize the agent records with all the elements you defined in the View including the agency to which each agent is attached.