Configuring advanced settings of tMDMOutput to write staging data into MDM - 6.5

MDM data processing

author
Talend Documentation Team
EnrichVersion
6.5
EnrichProdName
Talend Data Fabric
Talend MDM Platform
Talend Open Studio for MDM
task
Data Governance > Third-party systems > MDM components > MDM data processing components
Data Quality and Preparation > Third-party systems > MDM components > MDM data processing components
Design and Development > Third-party systems > MDM components > MDM data processing components
EnrichPlatform
Talend MDM Server
Talend Studio

Procedure

  1. In the Component view, click the Advanced settings tab.
  2. Click the [...] next to Configure XML Tree to open the tMDMOutput editor.
    Alternatively, double-click tMDMOutput to open the editor.
  3. In the Link target area to the right, click in the XML Tree field and then replace rootTag with the name of the business entity into which you want to insert the data record, Customer in this example.
  4. Add a namespace to write data into the metadata element source in this example.
    1. Right-click the Customer node, and select Add Name Space from the contextual menu.
    2. In the [Namespace dialog] dialog box, enter metadata in the Prefix field and http://www.talend.com/mdm/metadata in the Namespace Value field.
    3. Click OK to close the dialog box.
  5. In the Linker source area, select the five schema columns and drop them on the Customer node respectively.
    The [Selection] dialog box is displayed.
  6. Select the Create as sub-element of target node option, and click OK.
  7. In the XML Tree column, change the element names to the corresponding elements you have defined in the Customer entity or metata elements.

    Unlike elements defined in entities, metadata elements are built-in elements. To write metadata elements for records into staging database, you need to follow the format of metadata:staging_<source|status|error|blockkey> when defining the path expression to select the XML node.

  8. Right-click the element in the Link Target area you want to set as a loop element and select Set As Loop Element from the contextual menu.
    In this example, Id is the iterating object.
  9. Click OK to validate your changes and close the dialog box.