Database configuration

Select the type of database you intend to use and configure it for Spotfire Statistics Services.

After you have configured your Spotfire Statistics Services installation, indicate whether you are using the default or the non-default database, and then install and configure the JDBC driver for the database. Check to make sure you have set all appropriate properties for the database in the properties file.

  • Job database requirements
    By default, Spotfire Statistics Services relies on H2 database implementation to maintain the job queue.
  • Configure the H2 database server
    Configure an H2 database to use as the Spotfire Statistics Services job queue database.
  • Configuring a non-default database
    If you are using a database other than H2, you must provide additional configuration.
  • Configure the package for a Teradata Aster database
    Spotfire provides a connector to a Teradata™ database. Spotfire Statistics Services also includes an out-of-the-box data function example for using the Teradata Aster database for analytic processing with data stores. For developers who want to create and use data functions for the Teradata Aster Database, Spotfire Statistics Services includes the TERR package AsterDB.
  • Configuring the JDBC driver
    You must make sure that the JDBC driver for your database server is available in your environment.
  • Database properties
    The database configuration properties for Spotfire Statistics Services are contained in the file database.properties. We use the standard Java properties file conventions to define each database property.