Information Services
Information Services is a server-side method for accessing data from JDBC-compliant data sources. The connection to the external data source is done by the Spotfire Server on behalf of the Spotfire client.
The prerequisite 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.
Once these preparations are set up on the Spotfire Server, you use the Information Designer tool in your Spotfire Analyst client to create information links for accessing data from your JDBC-compliant data source.
- For more information about how to create information links with the Information Designer tool in Spotfire Analyst, see the Spotfire Analyst User's Guide.
- 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 TIBCO 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 Spotfire Analyst 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. - 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.
Parent topic: Installation and configuration