Tibco Spotfire 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 it 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¶
To better illustrate Data Mapping & Transformation, we will use the use-case of where a business wants to capture the analytics of when a service outage has occurred based on the incidents that were created in ServiceNow (Privileged) and put this data in Tibco Spotfire to generate a report. We will use the Data Mapping & Transformation to map the incident's impact, description, and who it was opened by to a data-point in Spotfire's data-set.
In figure 1 below, whenever a new incident is created in ServiceNow (Privileged) Triggers, a new record is created in Tibco Spotfire's Oracle dataset database. When a new incident has been created, data is added to the dataset in the data-set or table named INCIDENT which maps the ServiceNow's ShortDescription, Opened By, and Incident State with the dataset's INCIDENT_DESCRIPTION, OPENEDBY, and INCIDENT_STATE.
When working with Tibco Spotfire's data-set databases, the table structure may vary. This is a simple example, you may need some assistance to correctly identify the right table to put data into. With this simple example, the following are attributes that you can map data from ServiceNow trigger data to.
- INCIDENT_DESCRIPTION - Description of the incident that occurred
- OPENEDBY - The name of the employee or customer who opened the ticket
- INCIDENT_STATE - The current state of the ticket
