Working with Connectors in Spotfire Web Clients


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.

What data sources you can connect to depends on whether you are running Spotfire on cloud servers administered by TIBCO, or an on-premise solution using your own servers.

On-premise web clients

If you are running Spotfire on premise, all Spotfire data source connectors are available in the web client.

The connectors must be turned 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-premise web client, see the Spotfire Business Author User's Guide.

You can open saved connections from the library, as long as the corresponding data source connector is turned on in the web client instance.

Cloud web clients

If you are running Spotfire Cloud, the following data connectors are available in the web client:

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 Spotfire Cloud web client.  

No installation or configuration is required on the Spotfire server to use connectors in Spotfire Cloud 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 embed the data in the analysis file. See Embedded or Linked Data? for more information on how to embed data in an analysis file.

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 cloud web client, see the Spotfire Cloud User's Guide.

You cannot open saved connections from the library in the cloud web client.

Data loading limits in the Spotfire Cloud 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 2 000 000. If an imported data table contains more rows, only the first 2 000 000 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 panel, 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.

See also:

Preparing Analyses for TIBCO Spotfire Web Clients