The Spotfire database scripts

The Spotfire Server installation file that you have downloaded from the Spotfire Download site (SPOT_sfire_server_version_win.zip (Windows) or SPOT_sfire_server_version_linux.tar (Linux)) contains a number of scripts that can be used for setting up a Spotfire database.

About this task

To use the scripts, you select the files corresponding to your operating system and database type and copy the scripts/<database_type>_install directory to a location where you can open and review (and if needed, edit) the contents.

bat- and sh-scripts

About this task

For each database type, there are two or more create_databases scripts available, and you choose the one that suits your needs.

Windows: create_databases.bat
Windows (SQL Server with integrated authentication): create_databases_ia.bat
Windows (Oracle Database or SQL Server running on Amazon RDS): create_databases_rds.bat
Linux: create_databases.sh
Linux (Oracle Database or SQL Server running on Amazon RDS): create_databases_rds.sh

In the section under Uncomment to set variables , you can edit the script by providing the appropriate database server details for the variables.

SQL scripts

In the folder, there are also a number of SQL scripts (create_server or populate_server), which are consumed by the create_databases script.

About this task

If you are using Kerberos authentication between your database and Spotfire Server you must run the database SQL scripts manually, see Running database preparation scripts for Kerberos configuration. In other cases, these scripts are normally not touched.

create_server_db.sql
create_server_user.sql
create_server_user_ia.sql (SQL Server with integrated authentication)
create_server_user_rds.sql (Oracle Database or SQL Server running on Amazon RDS)
create_server_env.sql (Oracle Database or PostgreSQL)
create_server_env_rds.sql (Oracle Database running on Amazon RDS)
populate_server_db.sql

Action log scripts

There are also a number of scripts related to the creation of an action log. They are located under scripts/<database_type>_install/actionlog in the installation kit.

About this task

See Action logs and system monitoring for more information.

Windows: create_actionlog_db.bat
Windows (Oracle Database or SQL Server running on Amazon RDS): create_actionlog_db_rds.bat
Linux: create_actionlog_db.sh
Linux (Oracle Database or SQL Server running on Amazon RDS): create_actionlog_db_rds.sh

The action log scripts also have the corresponding SQL scripts.