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.

End users' access to data from multiple sources can be configured and controlled through settings in Information Services. Below is a list of common settings with short descriptions. For instruction on changing the settings, see Manually editing the Spotfire Server configuration file.

Setting Description
information‐services.jdbc.oracle.use‐faster‐schema‐listing List all Oracle users as schema list.
information‐services.dat.no‐sbdf Use Spotfire text data format or Spotfire binary data format when transferring data from Spotfire Server to a Spotfire client.
information‐services.runtime‐query‐validation Validate information link prior to execution.
information‐services.dat.data‐block‐queue‐size Maximum number of queued (not yet consumed by client) data blocks per job.
information‐services.dat.idle‐limit Maximum idle time in seconds before a job is garbage collected.
information‐services.dat.max‐field‐size Maximum size (in Megabytes) for a data cell.
information‐services.dat.max‐jobs Maximum number of concurrent jobs.
information‐services.dat.max‐timeout Maximum value of timeout parameters; must be at least 60 seconds less than the idle limit.
information‐services.dat.pivot.thread‐pool‐size Maximum number of pivot worker threads.
information‐services.dat.reshape.max‐memory‐usage Maximum memory available to a reshape operation.
information‐services.dat.retrieve‐timeout Maximum time allowed for retrieve requests, in seconds.
information‐services.dat.thread‐pool‐size Maximum number of job worker threads.
information‐services.ds.credentials‐cache‐timeout The default expiration time in seconds for cached data source authentication credentials.
information‐services.ds.credentials‐provider The class used to provide credentials for data sources that require authentication.
information‐services.jdbc.connection‐login‐timeout Login timeout for JDBC database connections.
information‐services.jdbc.oracle.temp‐table‐grantee Selecting privileges on temporary tables used during query execution will be granted to this user or role. The temporary tables are only valid during the query transaction.
information‐services.jdbc.use‐inner‐select‐in‐clause

This setting affects the behavior when the number of filter values sent to a jdbc data source exceeds the condition-list-threshold.

If set to false (default): all data rows matching any duplicate filter values will be duplicated,

If set to true: data rows matching any duplicates will not be duplicated (the same behavior as when the number of filter values is below the condition-list-threshold limit), but there is a large performance penalty.