Configuring a non-default database

If you are using a database other than H2, you must provide additional configuration.

Note: If you are using the default H2 database with a stand-alone Spotfire Statistics Services, you can disregard this information. See Configure the H2 database server.

Procedure

  1. Create a dedicated database to use with Spotfire Statistics Services.
  2. In the new database, run the script we provide to create the tables and triggers for Spotfire Statistics Services.
    Scripts for the supported database servers are located in SPSERVER_HOME/db_scripts.
  3. You must grant all privileges to the user account that you will use to connect to the database from Spotfire Statistics Services.
Related concepts
Related tasks