Job database requirements

By default, Spotfire Statistics Services relies on H2 database implementation to maintain the job queue.

  • The standalone installation configures H2 in the in-process mode. This installation option requires no additional configuration, and simply works out of the box.
  • The cluster installation configures H2 in the server mode. This installation option requires minor post-installation configuration.

When H2 is running in a Spotfire Statistics Services cluster (that is, in server mode), one of the managed servers is configured to run a true JDBC-compliant database, which is used by all other nodes in the cluster.

Note: H2 provides no failover capability for a Spotfire Statistics Services cluster.

Optionally, you can use an enterprise-class database server. Spotfire Statistics Services works with the following supported enterprise-class database servers:

  • Oracle (10g or later).
  • Microsoft SQL Server (2005 or later).
  • MySQL (5.0.89 or later).
Related concepts
Related tasks