To realize a useful connection for exchanging model information between your Enterprise Studio model and the external application, you need to create logical mappings.
An Excel connection can have one or more mappings. Each mapping represents information exchange between model data in Enterprise Studio and a single worksheet in an Excel file. The table within the mapping represents the Excel worksheet.
A ServiceNow connection can also have one or more mappings, representing information exchange between model data in Enterprise Studio and one or more ServiceNow tables. One table within a mapping represents a single ServiceNow table. Unlike an Excel mapping, a ServiceNow mapping can have multiple tables to map model data to multiple ServiceNow tables.
An SQL connection is similar to a ServiceNow connection; it can have one or more mappings. In an SQL connection a table within a mapping represents a single SQL database table. An SQL connection can also have multiple tables to map model data to multiple database tables.
The concepts for drawing the elements in a mapping that represent the model data from Enterprise Studio, are metaconcepts because of the level at which they represent data. They are a higher-level concepts; they do not represent a specific element, as concepts in regular modeling do, they represent an element type. This is clarified in the following figure.
Hierarchy of elements, concepts and metaconcepts
At the lowest level there are the elements that represent specific objects and relations, in the above example the business actors and flow relations. These are used in regular modeling.
At the mid level there are the elements that represent object types and relation types. In the example they are object type "Business actor" and relation type "Flow". Hierarchically seen they are on the same level as the concepts "Business actor" and "Flow" that are used to draw the objects and relations on the lowest level.
The concepts for drawing the object and relation types are positioned at the top level, hence the term metaconcepts. The elements drawn with these metaconcepts are referred to as metaobjects and metarelations.