The table below shows the elements that can be used for modeling connections for data exchange with Excel or ServiceNow.
Each element is visualized in an example, using the default color of the object. Other elements and relations in the example are faded in order to place them in the background.
Name + description
Excel connection for specifying the mapping between model elements in Enterprise Studio and model elements in an Excel worksheet, one or more ServiceNow tables, or one or more tables in an SQL database.
Table can be used to add additional tables to a mapping of a ServiceNow or SQL connection. A mapping can contain multiple tables.
A metaobject is used to model object types. It represents a type of model object, such as ArchiMate® application component or an ERD entity.
A metarelation is used to model relation types. It represents a type of model relation, such as an ArchiMate assignment relation or an ERD association relation.
Name + description
Relation (Excel connection only)
The (collapsed) relation is used to model a relation between two metaobjects in an Excel connection. It can be used instead of a metarelation with link relations to connect metaobjects. It can save space in a diagram.
A collapsed relation can be expanded at any time.
Composition (Excel connection only)
A composition relation is used to model a parent-child relation between object types in an Excel connection. If used, not only the child element is exported, but also the parent element belonging to the child element. On import of the child element, the parent element is used to find and match the child element.
A link relation is used to connect a start point or endpoint of a metarelation with a metaobject in a connection.
A reference relation is used to model object references. It is used if an attribute contains object references or a collection of object references. The type of object that is referred to must be modeled as well and linked to the attribute with a reference.
A mapping relation is used to define the mapping between an Enterprise Studio model element and the related element in the external application, represented in the mapping table.
ArchiMate® is a registered trademark of The Open Group.