Creating an SQL connection works similar to creating a ServiceNow connection.The following needs to be done to create the connection. For the details about each step, please refer to the steps for creating a ServiceNow connection.
Like with a ServiceNow connection, there is no prescribed order in which the table and the meta-elements of a mapping should be configured to create the mapping. The preferred order may depend on what you want to use the connection for.
- Add an SQL connection as the basis for the mapping, and specify the connection properties.
- Define a mapping with two linked tables.
- Define the SQL tables and their columns by configuring the mapping tables. One table for the work packages with their start date, end date, costs, and manager, and one table for the business actors.
- Define the model data on the Enterprise Studio side by adding metaobjects and their properties.
- Map the model data from the tool side to the SQL table by creating relations between the model elements and the mapping tables, including a connection between the two mapping tables (object reference).
- Specify the mapping properties for import and/or export. For each mapping relation in your connection mapping(s), specify the mapping properties that are relevant to your use of the connection.