Spotfire® Web Client User Guide

Connecting to Data from TIBCO Data Virtualization (TDV)

With the TIBCO Data Virtualization integration in Spotfire, you can search and view data from TDV directly in the Files and Data flyout.

About this task

[The information on this page is only applicable if you use an on-premises version of Spotfire®. If you are using Spotfire® on TIBCO Cloud™, you cannot access data from TIBCO Data Virtualization with the method described below. You must use the Spotfire Connector for TDV instead.]

After you have configured the integration, you have access to the data on the configured TDV server. To access the data from other TDV servers, you can use the Spotfire Connector for TIBCO Data Virtualization.

See the official TIBCO® Data Virtualization documentation to learn how to work with TDV and how to tailor your data.

Before you begin

Adding data from TDV to a Spotfire analysis

In Spotfire, you can browse and select from all the databases, schemas, catalogs, and tables you have access to in TIBCO Data Virtualization. Your data is available directly in the Files and data flyout.

Note: Should you have any issues or questions, take a look at the Troubleshooting section in the Spotfire Analyst User Guide.

Procedure

  1. Click to open the Files and data flyout.
  2. Select Data catalog.
    Note: Your system administrator can set a custom display name in the Administration Manager preferences.
  3. Double-click a database from the list to open it. Similarly, navigate through the schemas and catalogs until you reach the table you want to add. Double-click the table to add it to the analysis.
    Note: There is no Views in Connection dialog to select rows or columns when using the TDV integration to add data; you always add the whole table to the analysis.
  4. The final step is a summary view of the data you are about to add to your analysis. Here, you can choose how the data will be added. You can Import the data, keep it External (in-db analysis), or load it On-demand. To finish and add the data table, click OK.