Use environment variables to set up the Spotfire database for SQL Server

If you are installing a cluster and setting up multiple database servers, then this option of creating environment variables for the Spotfire database script might best suit your installation scenario.

About this task

For example, if you are an experienced script author and experienced with setting up multiple database servers, then you can modify just DBSERVER_CONNECTIDENTIFIER for every new database server and specify the environment variable values for all other settings.

Perform this task before installing Spotfire Server.

Before you begin

Complete the requirements and steps described in Preparing the SQL Server database for Spotfire.

Procedure

Copy the <installation files dir>/scripts/mssql_install directory to a location where you can edit it.
This directory contains script files that correspond to supported platforms. The file to edit depends on your platform.
- Linux: create_databases.sh
- Windows: create_databases.bat
- Linux (SQL Server running on Amazon RDS): create_databases_rds.sh
- Windows (SQL Server running on Amazon RDS): create_databases_rds.bat
Configure the following settings on the SQL server database computer.
- TCP/IP communication listening on a port (the default is 1433).
- Case-insensitive collation (at least for the Spotfire database).
  Note: If your installation of SQL Server uses a case-sensitive collation by default, or your data uses a different collation than Latin1_General_CI_AS, you must edit the create_server_db.sql script before running the create_databases.bat script.
Optional: If your installation of SQL Server uses a case-sensitive collation by default, or if you need to define a different collation, follow these steps:
1. On the SQL Server computer, open the mssql_install directory, and then open the create_server_db.sql script in a text editor.
2. Locate the line --create database $ (SPOTFIREDB_DBNAME) collate Latin1_General_CI_AS;
3. Remove the leading dashes (--).
4. If needed, replace Latin1_General_CI_AS with the name of the desired collation, but make sure it is case-insensitive (CI). See the SQL Server documentation for information about available collations.
5. Comment out the next line by inserting leading dashes (--), so that the line looks like this: --create database $(SPOTFIREDB_DBNAME)
6. Save the file and close the text editor.
Create environment variables and assign values for the script variables described in Variables in create_databases (SQL Server)
Open a command prompt and go to the directory where you copied the installation scripts.

At the prompt, run the script for your platform.

Note: Any variable for which you have specified no environment variable value results in a prompt to provide the value, and then a confirmation message is displayed.

If the parameters are correct, then a text similar to the following is displayed at the command line.

script_dir/mssql_install $./create_databases.sh
Press CTRL_C to stop at any time
Creating Spotfire Server database and user
Creating Spotfire Server tables
Populating Spotfire Server tables
----------------------------------------------------------------------------
Please review the log file (log.txt) for any errors or warnings!

Results

The required Spotfire user and database table schemas are created in your database.

The log file log.txt file is created in the working directory. If the execution fails, then the log file contains information about the failure. If the execution succeeds, then information about changes to the database (such as Tablespace created, User created, and so on) are reflected in the log file.

What to do next

Install Spotfire Server