Accessing data in databases
You can access and analyze data that is stored in external data sources, such as databases or data warehouses, when you use Spotfire in a web browser.
Spotfire supports accessing data from a wide range of external data sources. When you work with Spotfire in a web browser, the way that you access data is different depending on the type of data source.
Salesforce and Google Analytics With some types of external data sources, you can work entirely in the Spotfire web client. Then you do not have to make any preparations in an installed client. This is currently possible for Salesforce and Google Analytics. |
![]() |
More external data sources
When you want to access data from other external data sources, you prepare content in a Spotfire installed client. You create analysis files with prepared connections to external data sources. Then you can open the analysis in the Spotfire web client, and analyze the data from the data source. |
- Supported data sources in the TIBCO Cloud™ Spotfire® web client
In the TIBCO Cloud™ Spotfire® web client, you can connect to and analyze data from many different external data sources. When you work with data connections in the web client, you have different capabilities for different data sources. - Logging in to a data connection
When you open an analysis that contains data from a database, you typically have to log in to the external database. After logging in, you have access to up-to-date data directly from the external database in your analysis. - Accessing data from Salesforce
If you have Salesforce account, you can access and analyze data from Salesforce in Spotfire. - Accessing data from Google Analytics
If you have a Google Analytics account, you can access and analyze data from Google Analytics in Spotfire. - In-database and in-memory data loading in the TIBCO Cloud™ Spotfire® web client
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 for the TIBCO Cloud™ Spotfire® web client in cloud data sources
If you want to use data from cloud data sources, such as Azure SQL or Amazon Redshift, in the TIBCO Cloud™ Spotfire® web client, certain configurations might be required in the data source. Setting up the proper access rules is often a task for the data source administrator.