Skip to main content Skip to complementary content

Defining the composite View

Procedure

  1. In the Viewable Business Elements area, click the button to add a new XPath line to the table.
  2. In the new XPath line, click the three-dot button to open a dialog box.
    From the Data Models list, select the data model holding the entities on which you want to create the composite View.
    All entities constituting the model are listed in the dialog box.
    Information noteNote: You can filter the entities you want to display in the dialog box if you type in the Filter field the text according to which you want to filter business entities. This is a search-as-you-type filter where entities are instantly filtered as you type your search string.
  3. Select the entities/element to be retrieved by the View being defined.
  4. Consider as an example that your data model has the two entities: Agency and Agent. You want to create a composite View that joins elements in both entities to show multiple data records for the same agent if he/she is attached to multiple agencies.
    In the Searchable Business Elements area, click the button to add a new XPath line to the table.
    Information noteNote: When defining a search filter view, the first line in the Searchable Business Elements area must be the xPath to an attribute of the main entity.
  5. In the new XPath line, click the three-dot button to open a dialog box where you can select the entities or elements to be located.
    Information noteNote: You can filter the entities you want to display in the dialog box if you type in the Filter field the text according to which you want to filter business entities. This is a search-as-you-type filter where entities are instantly filtered as you type your search string.
  6. In the Where Conditions area, click the button to add a new XPath line to the table.
    In the new XPath line, click the three-dot button to open a dialog box where you can select the entities/elements on which you want to define a join condition.
    Information noteNote: You can filter the entities you want to display in the dialog box if you type in the Filter field the text according to which you want to filter business entities. This is a search-as-you-type filter where entities are instantly filtered as you type your search string.
    Information noteWarning: You must use the "Join With" operator when creating a composite View in order to specify the join in the WHERE clause. Usually, you join on elements keys. If there are more than one keys to join on, you must repeat a "Joins With" clause for each part of the key. For instance, suppose the AgencyFK is a compound key that comprises Id and Date, you must define two conditions in the "Where Condition" table: "Agent/AgencyFK --> Joins With --> Agency/Id" and "Agent/AgencyFK --> Joins With --> Agency/Date".
    The WHERE clause used in this example will generate multiple data records for the same agent linked with different agencies.
  7. Click the save icon on the toolbar or press Ctrl + S on your keyboard to save your changes.

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 records in the two specified entities according to the defined join clause.

Information noteNote: You can attach a Process to the View in order to transform/enrich data, on the fly, by looking up fields in the source system.

For further information, see Running the view result through a Process (registry style lookup).

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 – please let us know!

Leave your feedback here