Skip to end of metadata
Go to start of metadata

If you have a regular Excel table with objects and no relations between them, it is possible to automatically create these relations in Enterprise Studio when importing the objects. To accomplish this, an additional empty relation column needs to be added to the Excel worksheet, and an Excel connection needs to be created that has a regular mapping table with an additional relation column. 

When importing the Excel table from the example figure below, a relation will be created between the application components and data objects in the same row. Take note that only one type of relation can be created per worksheet. If you want to import more than one, you need a worksheet for each type of relation.


Regular table with objects and an additional relation column

Before you start creating the mapping, make sure that the ArchiMate® model you are importing data in has one instance of each type of element you are going to import. You can use these elements during creation of the mapping to add the meta-elements to your mapping.

To create a mapping with additional relation column:

  1. Create a connection with a mapping with a regular table. The mapping must have the same name as the worksheet in the Excel file.

    Make sure to set your ArchiMate model as model context for the connection in the connection settings.



  2. Open the mapping, and add additional columns to the table to make it match the number of columns in the Excel worksheet.

    Also add the meta-elements to the mapping. Easiest way to do this is by dragging the objects and relation from the model browser onto the view. That way the meta-elements automatically represent the right objects and relation.



  3. Connect the meta-elements with the mapping table columns by adding mapping relations between them, and add relations between the metaobjects and the metarelation to define the relation. Make sure to connect both objects to the correct entry point (from - to) of the relation.

    When connecting the meta-elements with the mapping table columns, easiest way is to make the order of the columns match the order of the columns in the Excel sheet. If you choose not to, then you additionally need to change a few mapping table properties and possibly change the relation column name (last step in the procedure).

    Set the relation column as the population column .



  4. As for the import properties in the mapping, best practice is to deactivate the Mandatory and Use for identification options in the mapping relation properties of the relation, because the relation in the Excel sheet is undefined.



  5. Only ifthe mapping table column order differs from the order in your Excel worksheet, do the following:

    • In the mapping table properties, activate Column heading names must match, and deactivate Column numbers must match.



    • If the names of the columns in the mapping table differ from the column heading names in your Excel worksheet, rename the table columns in the mapping to make them match.



The connection is ready for import. Validate your connection first before you start import.


ArchiMate® is a registered trademark of The Open Group.