You can use connectors in Spotfire web clients, but you have limited capabilities compared to the installed clients. For most connectors, you only have access capabilities in the web clients, which means you cannot create new connections but you can open connections that are saved in Spotfire analysis files.
Which data sources you can connect to depends on whether you are running Spotfire on cloud servers administered by TIBCO, or an on-premises solution using your own servers.
On-premises web clients
If you are running Spotfire on premises, most Spotfire data connectors are available in the web client.
The connectors must be switched on in the configuration on the server, and the correct data source drivers must be installed on the computer running the web client service. Contact your Spotfire administrator if you need to change the available connectors in your instance of the web client. You do not have to install any drivers on the computer that you will access the web client from.
For many connectors, you only have access capabilities and cannot author or edit connections. For more information about the specific capabilities of all connectors in the on-premises web client, see:
You can open saved connections from the library, as long as the corresponding data connector is switched on in the web client instance.
Cloud web clients
If you are using TIBCO Cloud™ Spotfire®, you can access data in a selection of external data sources with the use of data connectors. For many of these data sources, you only have access capabilities, and you cannot create or edit connections in the web client.
For more information about the supported data sources and specific capabilities for connectors in the TIBCO Cloud Spotfire web client, see:
Note: If you have configured an Attivio or Microsoft SQL Server connection with SSL or Encrypt, the server certificate will not be validated when you open the connection in a TIBCO Cloud™ Spotfire® web client.
No installation or configuration is required on the Spotfire server to use connectors in TIBCO Cloud™ Spotfire® web clients.
If you want to open analyses that use connections to data sources that are not supported in the cloud web client, you can store or embed the data in the analysis file. See Embedded or Linked Data? for more information on how to store data in an analysis file.
You cannot open saved connections from the library in the cloud web client.
Data loading limits in the TIBCO Cloud™ Spotfire® web client
To ensure stable performance, there are certain limitations on loading data from external data sources in the cloud web client. Consider these limits when you create an analysis that will be used in the web client.
Limit |
Description |
Data import limit |
When data tables in a connection are configured to be imported in-memory, the maximum number of rows that can be loaded in the cloud web client is 20 million. If an imported data table contains more rows, only the first 20 million rows will be included. If your connection contains larger data tables, you can configure the data tables to be loaded in-database. When data is kept in the external system, there is no limit on the number of rows allowed in the underlying data tables. If you want to use in-memory loading, however, you can try limiting the data to be imported, by defining prompts for the connection, which will let the end user select what data to load. |
External data row limit |
The maximum number of rows that can be retrieved and visualized is 500,000, when working with in-database data in the cloud web client. This does not limit the number of rows allowed in the underlying data table in the data source, but only the amount of data that can be fetched in a query to the data source. The limit affects, for example, visualizations, the expanded data in analysis flyout, and certain filter types. If an analysis contains visualizations or filters configured to show more items, these elements will not be rendered in the analysis when opening it in the cloud web client. |
External data table visualization row limit |
The table visualization can display a maximum of 10,000 rows of data, when working with in-database data. If the data table contains more rows, only the first 10,000 will be visualized. |