Accessing Data from External Data Sources

In Spotfire, you can connect to and access data from your external data sources, such as databases, data lakes and warehouses.

Accessing data with self-service data connectors

Spotfire has native support for a wide range of data source types. To connect to the supported data sources, you use self-service data connectors. Each connector is designed and optimized for its corresponding data sources.

If there is a data connector for your data source, this is the preferred way to access that data in Spotfire. It is easy to set up a connection and access your data with a connector directly in Spotfire, and the connectors are well suited to handle big data. Big data can be kept external, for in-database analysis, so that queries are pushed to the data source from Spotfire as you work on the analysis. Of course, with connector you can also import data into Spotfire.

All self-service data connectors are available in the Files and data flyout, under Connect to. There, you can easily create new connections or open connections that have been saved in your Spotfire library.

Connecting to other data sources

Even if Spotfire does not yet have native support for the type of external data source where you store your data, meaning there is no specifically designed and optimized data connector for that source, you can probably still load your data into Spotfire.

To connect to a data source for which there is no self-service data connector, you can use one of Spotfire's generic methods for connecting to external data sources.

Information Designer - Server-side JDBC connectivity

With Information Designer (Information Services), you can connect to and load data from virtually any JDBC-compliant data source. Data can be imported for in-memory analysis in Spotfire.

Information Services is a server-side method for loading data, which means that JDBC drivers and JDBC data source templates that are required to connect to your data source must be installed and configured on your Spotfire Server.

Once these preparations are set up on the Spotfire Server, you use the Information Designer tool in your Spotfire Analyst client to create information links for loading data from your JDBC compliant external data source.

Note: Because Information Services runs on Spotfire Server, this method for loading data is not available if you are running TIBCO™ Cloud® Spotfire or TIBCO Spotfire® Desktop.

Load data with ODBC, OLE DB, or ADO.NET data provider

Important: The Load data with ODBC, OLE DB, or ADO.NET data provider feature provides only limited performance and functionality for loading data. Therefore, only use it if you are not able to use a connector or Information Services to connect to your data source.

If there is no native data connector that you can use to connect to your external data source, and you cannot use Information Services to connect with generic JDBC connectivity, you can use Spotfire's generic support for loading data with a data source driver that you have installed on your computer.

With this method, you can use a driver of the types ODBC, OLE DB data provider, and ADO.NET data provider to connect and load data from an external data source.

See also:

Data Overview

Loading Data Overview

Getting Started with Connectors