Google Cloud SQL Data Mapping¶
Data Mapping and Transformation is one of the powerful features of Connect iPaaS. When you create a workflow certain attributes of your trigger application are available to Google Cloud SQL for data mapping while querying the databases. These attributes can be mapped to the specific column of the target table.
This capability not only allows field mapping but it also allows complex transformation using Excel-style functions to apply hundreds of formulas and operations. The feature of Excel-style functions makes data mapping on Connect iPaaS a breeze for business users who are already well versed with Microsoft Excel formulas.
Example Scenario with ServiceNow Trigger¶
In the Figure 1 below, whenever a new incident is created in ServiceNow (Privileged), a new record is created in the Google Cloud SQL selected database. In this example we have selected MySQL as the chosen database engine. The database has a table named Incident which stores the Category, Opened by and Short Description of the incident 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().
The column incident_state is an enum data type column in MySQL database. You can either type in the value of the 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 Figure 1.
