Double-click tMDMInput to open the Basic settings view.
- In the Property Type list, select Built-In.
In the Schema list, select Built-In and click the ... button next to
Edit schema to open a dialog box and define the structure
of the master data you want to read from the MDM server.
In this example, three columns are defined to fetch three elements from the Product entity: Name, Price, and Colors.
- After you have defined the schema, click OK to close this dialog box, and then click Yes in the Propagate dialog box to propagate the schema changes to tLogRow.
- Enter the user name and password for accessing the MDM server.
- In the Entity field, enter Product between quotes.
- In the Data Container field, enter Product between quotes.
- Select Master from the Type list.
Define the query conditions in the Operations area.
In this example, we want to query the product data records whose names include Shirt.
- Click the [+] button to add a row.
Enter Product/Name between quotes in the Xpath field.
Apart from elements defined in entities, you can query metadata elements which are also known as built-in elements. To query metadata elements from records in master database, you need to follow the format of
metadata:<timestamp|task_id>when defining the path expression to select the XML node to run the query on.
- Select Contains from the Function list.
- Enter Shirt between quotes in the Value field.