Skip to main content Skip to complementary content
Announcements

Creating a simple View that displays the foreign key information

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.

Did this page help you?

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!

Leave your feedback here