Accessing Data from TIBCO Cloud™ Live Apps

You can connect to TIBCO Cloud™ Live Apps to analyze your case data in Spotfire.

Before you begin

Before you start, read the System Requirements for Spotfire Connectors. Make sure your version of Spotfire includes the connector for Live Apps.
You must have a TIBCO Cloud™ account, on which you have access to a Live Apps subscription.

Gather the following information:

The credentials of your TIBCO Cloud account
The organization on TIBCO Cloud that owns the Live Apps subscription
The region on TIBCO Cloud that the subscription is in

About this task

If you do not already have a shared connection that you can use to access your data, create a new data connection to Live Apps.

Procedure

Click Files and data .
In the Files and data flyout, click Connect to.
In the list of connectors, click TIBCO Cloud™ Live Apps.
In the TIBCO Cloud™ Live Apps Connection dialog, enter the Email address and Password for your TIBCO Cloud account.
Select the Region on TIBCO Cloud™ of your Live Apps subscription. Then click Connect.
Select the Organization that owns the Live Apps subscription you want to access. Then click OK.
In the Views in Connection dialog, select the data you want to analyze in Spotfire. When you are happy with your data selection, click OK.

Tip: See Selecting data from Live Apps for useful information about how to select the data to analyze in Spotfire.
The final step is a summary view of the data tables you are about to add to your analysis. To confirm and load the data, click OK.

Selecting data from Live Apps

About this task

When you create or edit a connection to Live Apps, you use the controls in the Views in Connection dialog to select what data you want to analyze. In the list of Available tables in database, you can browse the data from your published Live Apps applications.

Note: You can only access data from Live Apps applications that have the status 'published'. Other applications are not visible in Spotfire.

Lists

If the data from a Live Apps application is hierarchical and includes lists, the lists are displayed as separate database tables. If there are further levels to the hierarchy, meaning that it contains sub-lists, those are also listed as database tables.

You can relate and join lists with their parent data to create a single data table in Spotfire. To do this, you use the Add related tables functionality. Note that you can only join related tables by selecting a list and then adding the parent data as related tables.

In the list of Available tables in database, double-click to add the list that you want to add and join with its parent data.
In the list, right-click the list that you added, and select Add related tables.

Result: All data from the Live Apps application that is located 'above' the list in the hierarchy is added and joined as related tables.

Tip: When you select data from Live Apps, there is no functional difference between Add related tables and Add all related tables.

When you add and join data with lists from Live Apps this way, Spotfire flattens the final data table. The result is a data table with repeated values in columns. This is illustrated in this image:

Troubleshooting

About this task

It is important that the Region on TIBCO Cloud™ and Organization that you select matches your Live Apps subscription. If your TIBCO Cloud organization changes name, you must update your connections to Live Apps for that organization, to be able to log in.