Information Services
Information Services is a server-side method for accessing data from JDBC-compliant data sources. When you use Information Services to access data in an analysis, the Spotfire Server connects to the external data source on behalf of the Spotfire client.
Information Services runs as a java subprocess on the same computer that runs Spotfire Server. You can manage and monitor the Information Services process in the web administration pages, similar to how you manage Automation Services and Web Player services.
Setting up Information Services
The prerequisites for using Information Services to access data is that you install and configure the corresponding JDBC drivers and data source templates for your data source on your Spotfire Server. You must also make sure that the Information Services process is started.
Once these preparations are set up on the Spotfire Server, you use the Information Designer tool in the installed Spotfire client to create information links for accessing data from your JDBC-compliant data source.
For more information about how to create information links in Information Designer, see the Spotfire User Guide.
- Starting and stopping Information Services
You can start and stop Information Services on a Spotfire Server instance in the web administration pages. - Installing database drivers for Information Designer
To be able to access data from a JDBC-compliant data source with Information Services, you must install the appropriate JDBC driver on the computer that is running Spotfire Server. - Adding a data source template with the configuration tool
To be able to use Information Services to access data from a JDBC-compliant data source, you must have the corresponding data source template. You can add a data source template to the Spotfire Server configuration with the Spotfire Server Configuration Tool. - Data source templates
When you use Information Services to access data from a JDBC data source, you must have a data source template for that data source. When you have installed the appropriate driver and data source template on the Spotfire Server, you can use Information Designer tool in the installed Spotfire client to create information links for accessing data from that data source. - Information Services settings
Information Services provides end users with the ability to access and pivot data from multiple databases simultaneously, without having to know anything about installing database drivers, underlying data schemas or SQL. - Information Services commands
To perform an Information Services task, use the related command. - Passing username and password to custom properties in Information Services
For some use cases, you might want to pass the username and password information from an Information Services data source to a specific connection property in the JDBC driver (instead of the standard user and password properties). This can be useful for making use of certain authentication methods when you access data from a database. - Identity provider (OAuth2/OpenID Connect) authentication for Information Services
You can use an OAuth2/OpenID Connect identity provider (IdP) as the authentication method in Information Services data sources. Depending on your use case, you can set up data sources with a traditional login flow where each user logs in, or your can set up data sources with automatic authentication using a service account. - Default join database
When running an information link a join database is used for creating temporary tables and joining the final result. When you specify a default join database, this is one possible join database. Spotfire can also search the information link query for a writable data source that can be used as a join database, or use any writable information services data source in the library. - Monitoring and troubleshooting Information Services
Spotfire provides ways to get insight into the status of Information Services processes in your Spotfire Environment. The following are methods for monitoring Information Services, as well as some troubleshooting steps for common issues.