Tableau 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 the Action application for data mapping while making API calls.
These attributes can be mapped to the specific attributes of the Action application. This powerful capability not only allows field mapping but also allows complex transformation using excel style functions to apply hundreds of formulas and operations. The choice of excel style function makes data mapping on Connect iPaaS easy for business users who are already well versed with Microsoft Excel formulas.
Example Scenario with ServiceNow Trigger¶
In figure 1 below, whenever a new incident is created in ServiceNow (Privileged), a new record is created in MySQL database connected via Tableau. 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 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 connected via Tableau. 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 the figure.