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 Cloud Business Author
Data source connectors for some external data sources are available in Spotfire Cloud Business Author. When working with connectors, you have different capabilities for different data sources. - In-database and in-memory data loading in Spotfire Cloud Business Author
When you analyze data from external data sources, you can either import data and analyze it within the Spotfire data engine (in-memory) or you can keep the data in the external system (in-database). - Configuring access to cloud data sources
If you want to use data from cloud data sources, such as Azure SQL or Amazon Redshift, in Spotfire Cloud Business Author, certain configurations might be required in the data source. Setting up the proper access rules is often a task for the data source administrator.