This scenario describes a two-component Job that reads master data on an MDM server. The master data is fetched and displayed in the log console.
From the Palette, drop tMDMInput and tLogRow onto the design workspace.
Connect the two components together using a Row Main link.
Double-click tMDMInput to open the Basic settings view and define the component properties.
In the Property Type list, select Built-In to complete the fields manually. If you have stored the MDM connection information in the repository metadata, select Repository from the list and the fields will be completed automatically.
In the Schema list, select Built-In and click the three-dot button next to Edit schema to open a dialog box. Here you can define the structure of the master data you want to read on the MDM server.
The master data is collected in a three column schema of the type String: ISO2Code, Name and Currency. Click OK to close the dialog box and proceed to the next step.
In the URL field, enter between inverted commas the URL of the MDM server.
In the Username and Password fields, enter your login and password to connect to the MDM server.
In the Entity field, enter between inverted commas the name of the business entity that holds the master data you want to read.
In the Data Container field, enter between inverted commas the name of the data container that holds the master data you want to read.
In the Component view, click Advanced settings to set the advanced parameters.
In the Loop XPath query field, enter between inverted commas the structure and the name of the XML node on which the loop is to be carried out.
In the Mapping table and in the XPath query column, enter between inverted commas the name of the XML tag in which you want to collect the master data, next to the corresponding output column name.
In the design workspace, click on the tLogRow component to display the Basic settings in the Component view and set the properties.
Click on Edit Schema and ensure that the schema has been collected from the previous component. If not, click Sync Columns to fetch the schema from the previous component.
Save the Job and press F6 to run it.
The list of different countries along with their codes and currencies is displayed on the console of the Run view.