Configuring a non-default database

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

About this task

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

Create a dedicated database to use with Spotfire Statistics Services.
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.
You must grant all privileges to the user account that you use to connect to the database from Spotfire Statistics Services.