Defining output MDM schema - 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

This section describes how to define and download an output MDM XML schema. To define and download an input MDM XML schema, see Setting up the connection.

To set the values to be written in 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 write the entity values, and select Retrieve Entity from the contextual menu.
  2. In the MDM Model dialog box, select the Output MDM option in order to define an output XML schema and then click Next to proceed to the following step.

    Example

  3. From the Entities field, select the business entity (XML schema) in which you want to write values.

    Example

    The name is displayed automatically in the Name field.
    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.
    Identical schema of the entity you selected is automatically created in the Linker Target panel, and columns are automatically mapped from the source to the target panels. The wizard automatically defines the item Id as the looping element. You can always select to loop on another element. Here, you can set the parameters to be taken into account for the XML schema definition.

    Example

  5. Click Schema Management to display a dialog box.
  6. Do necessary modifications to define the XML schema you want to write in the selected entity.
    Warning: Your Linker Source schema must corresponds to the Linker Target schema, that is to say define the elements in which you want to write values.
  7. Click OK to close the dialog box.
    The defined schema is displayed under Schema list.

    Example

  8. In the Linker Target panel, right-click the element you want to define as a loop element and select Set as loop element. This will restrict the iteration to one or more nodes.
    By doing so, the tMDMOutput component that uses this MDM connection will create a new row for every item with different feature.

    Example

    Tip: You can prioritize the order of the fields to write by selecting the field and using the up and down arrows.
  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. You can modify the created schema according to your needs and drop the connection as a tMDMOutput in any of your Jobs.

For more information on how to modify the schema, see Modifying the created schema.