You are viewing the documentation for Blueriq 14. Documentation for other versions is available in our documentation directory.

In many cases, the two modules that are mapped by means of a datamapping, have a lot of attributes and/or relations in common.

This article describes how to generate a datamapping, that automatically maps common attributes and relations.

In this how to:

Example

The example used concerns two modules, from which the ERD's are shown below.

Module Career

Module Reporting

In the module Career the entity Job has an attribute Company and in the module Reporting there is an attribute Job.Employer.
Furthermore, The module Career has entity Course, the module Reporting does not contain this entity.

Generate datamapping

Datamappings are part of a configuration module. See Data mapping on how to create a datamapping.

To make sure that

  • the datamappings for all attributes from Person,
  • the datamappings for all common attributes from Job and
  • the datamappings for the relation Person.HasJobs

are automatically generated, simply press the button Generate as shown below.

After pressing the button, the screen will alter slightly:

Below the generated mapping is shown:

Career > Reporting

Reporting > Career

For the entity Person, all attributes are mapped in the datamapping from Career to Reporting.

Also the relation Person.HasJobs is mapped automatically.

In entity Person, all attributes except the attribute Employer are mapped.

Re-generate the datamapping

The generate button can also be used after the initial datamapping. To illustrate this, we use the following scenario:

The datamapping for the attribute Job.StartDate has been changed to Job.StartDate + 7 DAYS.
The attribute Job.Company in module Career has been renamed to Job.Employer.

Before pressing the Generate button again, the datamapping is as follows.

After pressing the Generate button once more, the datamapping is as shown below.

In conclusion:

A datamapping can be generated over and over again:

  • All attributes and relations that are exactly the same are mapped.
  • All mappings that already exist, will remain the same.