2022.1

Note
Moving and grouping fields in the Data Model has 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.
To learn how to change the order in which data are extracted, see "Renaming and
reordering fields in an extraction step" on page299.
l Add Field: Click to add a new field at the current level (record or detail table). Enter the
field name in the dialog; if you want you can change the field's data type and set a default
value. Then click OK to add it to the Data Model.
l Add Table: Click to add a new detail table at the current level (record or existing detail
table). Enter the table name in the dialog and click OK to add it.
l Add Group: Click to create a new group at the current level (record or existing group).
Enter the group name in the dialog and click OK to add it. Any selected fields will be
added to the group. (See also: "Ordering and grouping fields in the Data Model" on
page293.)
Note
Rename, Delete and Set Type are only available for Data Model fields or detail tables
that are not filled via an extraction.
Fields and detail tables that are filled via an Extract step are to be changed (renamed,
deleted etc.) via the properties of that Extract step; see: "Editing fields" on page299 and
"Renaming a detail table" on page337.
l Rename: Click to rename the selected table, field or group. Enter the new name and click
OK to rename.
l Required: Click to indicate that the field should be retained, even if there is no Extract
step that references it. The DataMapper immediately discards non-required fields that are
not referenced by any Extract step.
l Delete: Click to delete the selected table or field.
l Set Type: Use the list to select the field type (see "Data types" on page310).
l Ungroup: Delete the selected group. The fields in the group will be moved up one level
in the Data Model.
Page 334