Use the Mapping editor to map elements from the conceptual model into a database model or vice versa.
The following requirements must be met in order to be able to run the Mapping editor:
Use the Mapping editor to carry out a specific, configured mapping of elements from the conceptual model into a database model or vice versa.
Calling a mapping process in the Extras>Map Model>Mapping submenu opens the Mapping editor with the same name as the selected mapping process.
You can select individual entities, whole packages or the entire model for mapping. To do this, drag the appropriate elements from e.g. the model structure and drop them in the list of selection elements.
You can check which elements will actually be mapped. If e.g. the list only contains one package, all elements in the package which correspond to the mapping are mapped. The list of selection elements may also contain elements which do not affect the mapping. Click on the Determine source elements button to show the elements which will actually be mapped.
You can see what the mapping would actually change.
The model elements are highlighted in the target model's structure.
| Font Color | Meaning |
|---|---|
| Blue | Modified Model Elements |
| Green | Newly-Created Model Elements |
| Red | Model elements that can be deleted. Model elements are not automatically deleted. |
| Orange | Linked Model Elements |
| Black | Unmodified Model Elements |
You can carry out the mapping.
The Mapping editor has the associated Mapping tab with the Map Model group and includes two areas arranged next to each other in the editor for the Selection elements and the Target model of the mapping.
The Presets command opens a dialog where you can load, store and delete presets for the source and target element of the mapping process.
The current time is suggested as the identifier when adding a preset. There is no security prompt when deleting a preset.
Determine source elements: The elements that will actually be mapped to the target model are calculated using the selection elements. These are shown in a dialog.
The engineering action needed to do this has the tag Extend.
Preview: The preview calculates which elements would be modified or newly created in the target model.
The respective elements are highlighted in the target model tree.
If you hover the mouse over the icon of the elements shown in blue, a tool tip appears which tells you what exactly would be changed.
To cancel the preview, click on Preview again. The button is shown as "normal" again and no elements are highlighted in the target model.
The engineering action needed to do this has the tag Simulate.
Execute: The mapping is carried out. As with the preview, the modified and newly-created elements are highlighted.
The engineering action needed to do this has the tag Update.
Execute: The mapping is carried out. No model elements are modified or newly created. Only associated elements are linked with a mapping dependency and shown in color.
The engineering action needed to do this has the tag Interconnect.
Show all: The button is only available if a preview is displayed or the mapping has been carried out. You can set whether the elements which aren't affected by the mapping should also be shown in the target element tree or not.
The Selection elements list is on the left.
This is not shown until a mapping is selected. If the list is empty, a text is shown that tells you that you should drag the select elements there.
This text disappears once you have dragged the first element there and the respective element is shown instead.
You can drag further elements into the list. Use the context menu to remove the selected elements from the list.
You can drag all possible elements into the list. The element is not checked to see whether it is a good idea to use for the selected mapping to save time. Use the Determine source elements button to carry out a similar check yourself.
It is irrelevant which selection elements are selected in the list for the Determine source elements, Preview and Execute commands. All of the elements in the list are always taken into consideration.
The Target model area is on the right.
This is not shown until a mapping is selected. The target model needs to be set first. The drop-down list contains all submodels. The corresponding part of the model structure is shown once you select the submodel you want.
To restrict the list of models using the stereotype name, set the filter on the engineering action with the tag Update with the tag "Filter=<Name of stereotype>".
The context menu for the list of selection elements and for the target model tree contains extra menu items as well as the usual items. These menu items only appear if the selected element has already been affected by the mapping. A menu item exists for each element linked via a mapping.
An entity is selected in the list of selection elements. The entity has already been mapped once. The context menu has an extra menu item at the bottom of the list. This has the name of the table the entity was mapped to. The table's stereotype icon is also shown. If you click on this menu item, the target model's tree is expanded so that the respective table is visible. The table is selected and moved to the forefront.
You can now jump between the list of selection elements and target model's tree.
A message appears if the corresponding element does not exist in the target tree. This would be an indication that you have selected the wrong target element or that the element has already been mapped to the wrong target model.
The relevant element is added if it is not in the list of selected elements.
© 1986-2014 MID GmbH Nuremberg Germany. DIN EN 9001 certified. All rights reserved.