If you plan to set up Kerberos authentication between your database and
Spotfire Server, you must run the database SQL preparation scripts manually.
Procedure
Read through the
create_databases script to understand how the scripts work.
Run the following scripts:
create_server_db.sql
populate_server_db.sql
create_server_env.sql
Important: For Oracle, the
create_databases script passes the following variables to these scripts. When you run the database Oracle scripts manually, make sure to pass these variables along to the scripts:
ROOTFOLDER
CONNECTIDENTIFIER
SERVER_DATA_TABLESPACE
SERVER_TEMP_TABLESPACE
Important: For SQL, the
create_databases script passes the following variables to these scripts. When you run the database SQL scripts manually, make sure to pass these variables along to the scripts:
SERVERDB_NAME
DEMODB_NAME
If you want to install the demo database tables that are shipped with
Spotfire Server, do the following:
Run these scripts:
create_demotables.sql
create_demodata_env.sql
Using the appropriate load command for your database, load all of the SQL loader files that are in the
demodata folder.