Excel Sources sheet

This sheet aims at defining the correspondence between the columns in the Master Data Upload file and the Opinum Data Hub sources.

Have a look at the general structure for a description of the sources sheet.

Source mapping row

The mapping row defines the mapping between Master Data Upload file columns and a sources properties. One and only one mapping cell must contain the string ''_opKey'' to indicate that the corresponding column in Master Data Upload file contains the business key of the source, which will then be used to uniquely retrieve the source among all others. The business key definition gives detailed information about this topic.

Is it possible to map one column to multiple source properties and also multiple columns to a single source property

Here are the source system properties that you can specify in a mapping cell.

This definition tells the MDE to map the content of the column ''MTR_NAME'' in the Master Data Upload file to the property ''Name'' of the source

It is also possible to map a column to one or more Form(s) by specifying ''_opSourceForm.'' followed by a form definition

This definition tells the MDE to map the content of the column ''MTR_TYP_NAME'' in the Master Data Upload file to the source's form ''Master Data.Technical Identifiers.Name''

Site foreign key

A source is always attached to a site. The Master Data allows to define this relationship by the use of a specific expression ''_opSite.Key''

Important

This expression is only valid in a sources sheet

This indicates to the MDE that, when a new source is created, it will find the business key of the site to attach the source to in the column ''LOC_ID'' of Sites sheet