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.

For some connectors, you have full authoring and access capabilities in Spotfire Cloud Business Author. This means you can set up connections to the corresponding data sources directly in the web client, to add data to a new analysis or one that you are working on.

For some other connectors, you only have access capabilities in Spotfire Cloud Business Author. This means that connections to the corresponding data sources must be authored in an installed client. You can then continue to work on analyses that contain connections to these data sources in the web client.

In the Spotfire installed clients, you can use many data source connectors that are not yet available in Spotfire Cloud Business Author. If an analysis that you want to open in the web client contains data from an unsupported data source, those data tables can be embedded and saved in the analysis. Then, the data can be used without connecting to the data source and you can analyze it in the web client.

Note: Data connections stored in the library cannot be opened in Spotfire Cloud Business Author and will not be displayed in the library view.

Supported data sources

No installation is required to use data connectors in Spotfire Cloud Business Author.
Data source Connector name Web client authoring
Amazon Redshift Amazon Redshift NO
Google Analytics Google Analytics YES
Microsoft Azure SQL Microsoft SQL Server NO
Microsoft Azure SQL Data Warehouse Microsoft SQL Server NO
Microsoft SQL Server Microsoft SQL Server NO
OData OData NO
Salesforce.com Salesforce.com YES
Note: If you want to author data connections in a Spotfire installed client, some connectors require that you install data source drivers on your computer. Some data source drivers are available for download directly from Spotfire. See Downloading TIBCO Spotfire Cloud Analyst and Downloading data source drivers to learn how to download the installed client and start using data connectors for authoring connections. For a full list of connector requirements, see TIBCO Spotfire Database Drivers.