Tibco Spotfire Actions

Actions are the operations (or API operations) that you can perform on database applications you select while creating the connection by a simple drag and drop and data mapping of elements and values from the input trigger, derived values using formulas or desired constants that you may wish to map.

To show you how Tibco Spotfire actions work in Connect iPaaS, we will use the use-case of a business wanting to put service outage incident data from ServiceNow (Privileged) in Spotfire to help build an analysis of outage history.

As shown below in Figure 1, you can Create, Update, Delete, and Upsert data in your dataset database based on the response to a trigger event.

Figure 1. Actions for Tibco Spotfire Application on Connect iPaaS

Create Record

Create data in response to an event trigger into the selected table.

Select the table from the database in which you have to create a record. After the table selection, all the Not Null columns of your tables will be shown as required fields.

You can add optional fields of the table using + button. You can map field data using trigger data or you can use excel functions. You can also use the evaluate functionality to map values directly from the trigger attributes.

For example in Figure 2 below, some attributes from ServiceNow are mapped to values of multiple fields of a new data point in the dataset.

Figure 2. Tibco Spotfire Create Dataset Data

Delete Record

Delete one or multiple database records in response to an event trigger. You can selectively delete data from the dataset based on a configurable condition.

Select the table in your database from which you want to delete the data. You can use the Choose where condition to add the conditions for selecting the data-points to be deleted. You can use simple AND-OR conditions to select the data-points to delete.

For example, in Figure 3 below, for the data-set Incident, all the data which have the INCIDENT_STATE as "Open" and INCIDENT_DESCRIPTION as the "Short Description" from the ServiceNow (Privileged) event trigger will be deleted in the dataset.

Figure 3. Tibco Spotfire Delete Data from a Dataset

Update Record

Updates one or multiple data-points in response to an event trigger. You can selectively update data-points in the dataset based on a configurable condition.

Select the data-set in your database where you want to update the data. Now you can add the conditions to select the records that will be updated. You can use simple AND-OR conditions to have more control over what data-points to update.

You can configure how you want to update the data-points on the selected dataset. You can use data Mapping and Transformation and excel functions on these values to add further processing.

In the figure below, whenever an Incident has been updated on ServiceNow (Privileged), a data-point is updated in the Tibco Spotfire's data-set. In the Incident data-set, the CLOSED_BY is updated by the event triggers' "Closed-By" and the TIME_OF_INCIDENT is updated to the current date and time can be added using the excel function Now() only if the INCIDENT_STATE is "Open".

Figure 4. Tibco Spotfire Update Record Action

Upsert Record

Upsert operation is the combination of Update and Create operations. Connect iPaaS will check to see if the data-point exists within the data-set and update it if it exists. If it doesn't then it will create a new data-point.

In the figure below, whenever an Incident is updated in ServiceNow (Privileged), a data-point will be updated or added in the Tibco Spotfire's data-set. The data-set or table INCIDENT has a new data point that is updated or created by using the mapped data from the ServiceNow's incident's "Short Description" and "Closed By".

Figure 5. Tibco Spotfire Upsert Record Action