Creating a mapping with multiple sources

Model integration logic using mappings with multiple sources

Now that we have created basic mappings and extended them with expressions it is time to see how we can add multiple sources to a mapping.

To demonstrate this, we'll extend the ExampleDWH model with a new Product entity that is sourced from JuiceERP.

Create a new entity

Open the ExampleDWH model and create a new entity Product. Add the following attributes: ProductID (Intger), Description (Text) and Dimensions (Text).

Create a multi-sourced mapping

Create a new mapping by right clicking on the Product in the explorer and select "Derive mapping...". Provide a suitable name and hit OK. In the mapping canvas, Add the Product and PhysicalProduct entities from JuiceERP as Source objects.

Set the attribute mappings: ProductID and Description from the Juice ERP Product table. Map the WidhtInCm, HeightInCm and LengthInCm attributes from PhysicalProduct to the Dimensions attribute. Add an expression on the Dimension field that concatenates WidthInCm, LengthInCm and HeightInCm with a suitable separator.

Set the source object dependencies

Now leave the property panel open and click the ProductSourceObject. Verify that this source object references the Product entity from JuiceERP and type is set to From.

In a mapping that uses more than one source, we need to define how the sources should be related to each other in the context of the mapping. We can define this using the properties panel on the Source Objects. Click the PhysicalProduct source object, open the properties panel. Set the join type to Left join. Add a dependency to the ProductSourceObject. Add a condition to relate both tables on the ProductID column.

We have created a complete, multi-sourced mapping.