Running database preparation scripts manually

If you plan to set up Kerberos authentication between your database and Spotfire Server, you must run the database SQL preparation scripts manually.

Procedure

  1. Read through the create_databases script to understand how the scripts work.
  2. 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
  3. If you want to install the demo database tables that are shipped with Spotfire Server, do the following:
    1. Run these scripts:
      • create_demotables.sql
      • create_demodata_env.sql
    2. Using the appropriate load command for your database, load all of the SQL loader files that are in the demodata folder.