Retrieve entity values for an MDM connection - 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...

Big Data

Big Data Platform

Data Fabric

Data Integration

Data Management Platform

Data Services Platform

ESB

MDM Platform

Real-Time Big Data Platform

About this task

To set the values to be fetched from one or more entities linked to a specific MDM connection, complete the following:

Procedure

  1. In the Repository tree view, expand Metadata and right-click the MDM connection for which you want to retrieve the entity values, and select Retrieve Entity from the contextual menu.

    Example

  2. In the MDM Model dialog box, select the Input MDM option in order to download an input XML schema and then click Next to proceed to the following step.

    Example

  3. From the Entities field, select the business entity (XML schema) from which you want to retrieve values.
    The name is displayed automatically in the Name field.

    Example

    Example

    Note: You are free to enter any text in this field, although you would likely put the name of the entity from which you are retrieving the schema.
  4. Click Next to proceed to the next step.
    The schema of the entity you selected is automatically displayed in the Source Schema panel. Here, you can set the parameters to be taken into account for the XML schema definition.

    Example

    The schema dialog box is divided into four different panels as follows:
    • Source Schema shows the tree view of the uploaded entity.
    • Target schema shows the extraction and iteration information.
    • Preview shows the target schema preview.
    • File viewer shows the raw data.
  5. In the Xpath loop expression area, enter the absolute XPath expression leading to the XML structure node on which to apply the iteration.
    Or, drop the node from the source schema to the target schema Xpath field.
    This link is orange in color.
    Note: The Xpath loop expression field is compulsory.
  6. If required, define a Loop limit to restrict the iteration to a number of nodes.

    Example

    Example

    In the capture above, we use Features as the element to loop on because it is repeated within the Product entity as follows:
    <Product>
        <Id>1</Id>
        <Name>Cup</Name>
        <Description/>
        <Features>
             <Feature>Color red</Feature>
             <Feature>Size maxi</Feature
        <Features>
        ...
    </Product>
    <Product>
        <Id>2</Id>
        <Name>Cup</Name>
        <Description/>
        <Features>
             <Feature>Color blue</Feature>
             <Feature>Thermos</Feature>
        <Features>
        ...
    </Product>
    By doing so, the tMDMInput component that uses this MDM connection will create a new row for every item with different feature.
  7. To define the fields to extract, drop the relevant node from the source schema to the Relative or absolute XPath expression field.

    Example

    Tip: Use the [+] button to add rows to the table and select as many fields to extract as necessary. Press the Ctrl or the Shift keys for multiple selection of grouped or separate nodes and drop them to the table.
  8. If required, enter a name to each of the retrieved columns in the Column name field.
    Tip: You can prioritize the order of the fields to extract by selecting the field and using the up and down arrows. The link of the selected field is blue, and all other links are grey.
  9. Click Finish to validate your modifications and close the dialog box.

Results

The newly created schema is listed under the corresponding MDM connection in the Repository tree view.