Data connections in the Spotfire web client
When you use a Spotfire web client, you can access and analyze data from virtually any external data source that you can connect to in the installed client. Depending on the data source and method for connecting to it, you have access to different amounts of functionality in the web client.
For some data connectors, you have full authoring and access capabilities in the web client. This means you can create and edit connections to the corresponding data sources directly in the web client, to add data to your analysis.
For some other connectors, you only have the capability to access your data in the Spotfire web client. 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. You can also open data connections that have been saved to the library, to add data to your analysis.
Limitations when you author data connections in the web client
In the web client, you can open and use any data connection. However, to use some functionality, you must create the connection in the installed client.
The following data connection authoring capabilities are not available when you create or edit data connections in the web client:
- Writing custom queries
- Adding and editing prompting
- Selecting data from stored procedures
- Saving a data connection or connection data source to the library
- Manually creating structural relations
Connectors with web client authoring support
| Connector with web client authoring | Learn more |
|---|---|
| Apache Spark SQL | Connector for Apache Spark SQL — Features and settings |
| Google Analytics | Accessing data from Google Analytics |
| Microsoft SQL Server | Accessing data from Microsoft SQL Server |
| Salesforce | Accessing data from Salesforce |
Prerequisites for using connectors in the Spotfire web client
In the on-premises version of the Spotfire web client, most connectors that are available in the installed client can be used.
The connectors you want to use must be switched on in the Web Player service configuration, and the drivers must be installed on the computer running the Web Player service. Contact your Spotfire administrator if you need access to more connectors in the web client. For more information about deploying connectors, see Setting up connectors in the Spotfire Server and Environment Installation and Administration help.
Information links
In a Spotfire installed client, you can use Information Designer to create information links that enable you to access data from JDBC-compliant data sources. When you use a Spotfire web client, you can open information links that you have saved to the library, and use analysis files that contain information links.