Working with data connections
You can connect to external data sources, such as databases, in Spotfire. Using data connections, you can access and analyze data stored in external data sources.
To set up connections, data connectors are used. The connectors can be seen as adapters which can translate data queries between Spotfire and an external system. By accessing your data through a data connector, you can take advantage of the processing power of the external system while still being able to visualize the result in Spotfire.
When you work with data connections, you will often author the connections and analyses using an installed client, which has a wider range of capabilities. Then, you can open the analysis and keep working with data from the data source in the web client.
- Supported data sources in Spotfire Business Author On-Premise
In the on-premise version of Spotfire Business Author, which runs on your company's own servers, all Spotfire data source connectors are available. When working with connectors in the web client, you have different capabilities for different data sources. - Opening a connection from the library
You can connect to external data sources using data connections that have been authored in an installed client and saved in the library. Just like with any other data source, data from a shared connection can be used as the basis for creating a new analysis or it can be added to an existing analysis.