Use the Connect tools to link columns in the source spreadsheet to fields in the target element. This creates the mapping.
You do not have to map everything, and Business Architect will only let you create valid connections. For example, it won’t let you draw a connection between a string and a number. The only thing that must be mapped is the sources unique identifier (the primary or compound keys) as indicated by the Key icon.
The table below contains a description of each of the connection types. For more detailed information see Importing Data from Microsoft Excel.
The basic mapping of one data field in the spreadsheet to one data field in the target.
Connects two relationship fields and creates the relationship in the target element.
Connects a data field on the table in the source area to a relationship field in a target table.
This is for repository to repository synchronizers.
Creates a relationship between two existing data fields and adds it to the table.
Automatic Field Copy
Automatically creates Field Copy links between the fields on the source and target tables.
How to Add a Connection
When the mouse is over something that can be connected using the selected connection type, it changes to a pencil cursor.
- Open the Connect tab in the Design Panel.
- Select one of the connection types.
- This often defaults to Field Copy.
- Click and draw the connection by holding down the mouse button and dragging the line.
- The connection can be drawn from either the source or target field.
- Invalid targets are greyed out whilst the connection is being drawn.
- Release the mouse button over a field to create the connection.
- Repeat the process until everything you want to map has been connected.
The short video clip below demonstrates how to add a connection:
How to Delete a Connection
- Open the Mapping.
- Right click on the connection you want to delete.
- Click ‘Remove’.
The short video clip below demonstrates how to delete a connection: