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
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
- 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.