TIBCO Data Virtualization as an external library
[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.]
With the TIBCO Data Virtualization integration in Spotfire,
you can search and view data from TDV as an external library, directly
in the Files and Data flyout.
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 start
You must configure
an external library for TDV by setting a preference in the Administration
Manager preferences.
For authentication, you must use an identity
provider (OAuth2) or Kerberos. For Kerberos, make sure you have Kerberos installed and configured correctly.
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.
Click 
to open the Files and data flyout.
Select Data
catalog.
Note: Your system administrator can set
a custom display name in the Administration Manager preferences.
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. However, you can edit
your connection later on and access the Views in Connection from
the Data canvas to add or remove data.
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.
Troubleshooting
I cannot see a Data catalog item in
the Files and data flyout
Before you can see the Data catalog item and browse and
search TIBCO Data Virtualization data directly from the Files and data
flyout, you or your system administrator must configure the integration
in the Administration Manager. See, Configuring
the TIBCO Data Virtualization integration for more information.
Another reason why you cannot see the Data
Catalog item could be that your system administrator has specified
a custom display name for the library. Ask your system administrator what
they called the TIBCO Data Virtualization integration.
I can see a library item, but it is
not called Data Catalog
If you can see a library item in the Files and data flyout,
but it is not called Data catalog your system
administrator might have configured a different name for it. Ask your
system administrator if they set a custom display name for the TIBCO Data
Virtualization.
I can browse and search data from
TDV, but the data I need is on a different server
You can always only add one server to one TDV integration.
If you want to connect to a different server than the one that is configured,
you have two options.
You or your system administrator must configure another
TDV integration instance connecting to the server that you need access
to.
Use the built-in Spotfire
connector for TDV. In the connection dialog you can specify which
server you want to connect to.