Setting up the Spotfire database (SQL Server)
If you plan to use Microsoft SQL Server for storing the Spotfire database, follow these steps before running the Spotfire Server installer.
About this task
Note: If
you plan to configure Integrated Windows authentication (IWA) between
Spotfire Server
and the
Spotfire
database in SQL, see
Setting
up the Spotfire database (SQL Server with Integrated Windows
authentication).
Before you begin
- Download and unzip the Spotfire Server installation kit from the TIBCO eDelivery web site. For instructions, see Downloading installation software.
- 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. See step 2 below. - The command-line database tools (for example, sqlcmd) must be downloaded and in the system path.
Procedure
What to do next
You can create the Spotfire database using one of the following strategies. Select the strategy that best suits your needs.
- 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. - Run the script for SQL Server interactively
If you are a new administrator and are creating only one Spotfire database, then this option of running the database configuration interactively, providing the values at the prompts, might best suit your scenario. - Edit the SQL Server create_databases script directly
If you do not want to provide the values at the prompt or create new environment variables for creating the database, then you can edit the create_databases script. Run the edited script to create the Spotfire database for Microsoft SQL Server. - Variables in create_databases (SQL Server)
Use these variables in the script for setting up a Spotfire database for SQL Server.
- 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. - Run the script for SQL Server interactively
If you are a new administrator and are creating only one Spotfire database, then this option of running the database configuration interactively, providing the values at the prompts, might best suit your scenario. - Edit the SQL Server create_databases script directly
If you do not want to provide the values at the prompt or create new environment variables for creating the database, then you can edit the create_databases script. Run the edited script to create the Spotfire database for Microsoft SQL Server. - Variables in create_databases (SQL Server)
Use these variables in the script for setting up a Spotfire database for SQL Server.
Parent topic: Spotfire database setup