Skip to content

Microsoft SQL Data Mapping

Data Mapping and Transformation is one of the powerful features of Connect iPaaS. When you create a workflow, certain data points of your Trigger application are available in the Action application for data mapping.

These Data Mapping can be mapped to the specific attributes of the Action application. This powerful capability not only allows field mapping but also the complex transformation using excel style functions with hundreds of formulas and operations.

Example Scenario with ServiceNow Trigger

In the figure 1 below, whenever a new incident is updated on ServiceNow, a record is updated or added (if not present) in Microsoft SQL database.

The database has a table named Incident which stores data like incident_name, incident_description, Opened by, ClosedBy and incident_state coming from ServiceNow in respective columns. Here, the columns are mapped to attributes from ServiceNow.

In the time_of_incident column, the current date and time can be added using the excel function Now().

Microsoft SQL Data mapping and transformation

Figure 1. Microsoft SQL Data Mapping & Transformation