Spotfire Server and Environment - Quick Start

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 Spotfire Download 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

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

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

What to do next

You can create the Spotfire database using one of the following strategies. Select the strategy that best suits your needs.

Note: Databases with self-signed certificates

It is recommended that you set up your database server for encrypted connections, with a valid, not self-signed, server certificate. For more information see Fixing Microsoft SQL Server JDBC driver-related issues.

Copyright © Cloud Software Group, Inc. All rights reserved.