Accessing data from other external data sources

You can access data from many external data sources, when you use Spotfire in a web browser. For data sources other than Salesforce and Google analytics, you use items that enable you to access a prepared selection of data from the external data source.

These items are called data connections and information links. You create them in a Spotfire installed client, and share them in the library. Then you can open them in the Spotfire web client, to access data from external data sources.

Prerequisites

The Spotfire web player instance must be configured with the correct data source drivers installed.

Data source credentials might be required to log in to the data source.

Procedure

  1. On the authoring bar, click Files and data .
  2. In the Files and data flyout, click Browse the library, or use the search bar to locate the data connection or information link that you want to open.
    Tip: You can use the search bar to display a list of all data connections and information links that are shared in the library. Type the following phrase in the search bar: type:query or type:dataconnection
  3. Click to open the data connection or information link of interest.
    • If required, enter your credentials to log in to the external data source.
  4. In the Add data to analysis flyout, you can view and change the settings for how the data will be added. Click OK to confirm and add the data to your analysis.

What is a data connection, and what is an information link?

When you add data to your analysis from a data connection or an information link, it works much the same way. Both enable you to access a prepared selection of data from an external data source. But there are some differences.

Data connections

In the library, you can recognize a data connection from this icon .

Data connections are the most convenient way to access data from external data sources in Spotfire. Spotfire has native support for creating connections to many types of data sources. For information on all supported data sources that you can access data from with connections, see Supported data sources

When you access data with a data connection, you can choose the load method. This means that you can keep the data external, for in-database analysis, or you can import it, for in-memory analysis. For more information, see Load methods.

Information links

In the library, you can recognize an information link from this icon .

When you add data from an information link, you can only import the data, for in-memory analysis.

When it is possible, it is recommended to use data connections rather than information links to access data.