Skip to content

MySQL 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 figure 1 below, whenever a new incident is created on ServiceNow, a new record is created in the MySQL database. The database has a table named incident which stores the Opened by and Short Description of the incident in respective columns. Here, the columns are mapped to Data Mapping from ServiceNow.

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

The column incident_state is an enum data type column in the MySQL database. You can either type in the value of the incident_state or you can map the value of this field using the evaluate functionality to the Incident State attribute from ServiceNow as shown in the figure.

MySQL Data mapping and transformation

Figure 1. MySQL Data Mapping & Transformation