2019.2

Table Of Contents
as the DataMapper immediately discards non-required fields that are not referenced
by any Extract step.
Editing the Data Model
The Data Model is generally constructed by extracting data; see "Extracting data" on page254.
Editing fields
You can modify the fields in the Data Model via the contextual menu that opens when you right-
click on something in the Data Model pane. For an explanation of the options in this menu, see
"Data Model contextual menu" on page328.
As long as a field or data table, added via the Data Model pane, remains empty, it can be
edited (renamed, deleted etc.) via the contextual menu.
Fields in a Data Model that are actually used in the extraction workflow cannot be edited via the
contextual menu of the Data Model pane. They are related to a step in the extraction workflow
and are edited via the Step properties pane instead (see "Editing fields" on page293).
Ordering and grouping fields in the Data Model
To make the Data Model clearer and more manageable, you can change the order of the fields
in it and create groups of fields. All grouping and ordering information is saved in the data
mapping configuration, so that when you reopen it, the Data Model will look the same.
Note that these changes have no impact on the order in which data are extracted, or on the final
records in the OL Connect database. They only help you organize the Data Model visually.
This also means group names are not used in scripts; fields and detail tables are accessed
directly through the record object (see the "Designer Script API" on page1286 and
"DataMapper Scripts API" on page396).
To change the order in which data are extracted, see "Renaming and reordering fields in an
extraction step" on page294.
Moving fields
To move a field, a group of fields or a detail table, you can simply drag and drop it to some
other place in the Data Model.
Page 288