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:
- SPOTFIREDB_ROOTFOLDER
- DBSERVER_CONNECTIDENTIFIER
- SPOTFIREDB_DATA_TABLESPACE
- SPOTFIREDB_TEMP_TABLESPACE
Important: For SQL, the
create_databases script passes the following variable to these scripts. When you run the database SQL scripts manually, make sure to pass this variable along to the scripts: