Setting up the Spotfire database (Oracle)

If you plan to use an Oracle database server for storing the Spotfire database, configure the Spotfire database before running the Spotfire Server installer.

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 Oracle database server computer:
- User name and password authentication.
  Note: You can set up Spotfire Server to authenticate with an Oracle Database instance using Kerberos. For instructions, see Using Kerberos to log in to the Spotfire database. In this case, you must run the database preparation scripts manually. See Running database preparation scripts manually.
- National Language Support (NLS) to match the language of the data you will bring into Spotfire.
  Note: If the database server NLS cannot be set to match the language of your data, Oracle provides other methods of setting NLS to a specific database or user. For more information, consult your database administrator or see the Oracle database documentation.
You must have access to the Oracle Database. You might need assistance from your database administrator to copy the install directory to the database, and to provide the database details for the script.
Download and add to the system path the command-line database tools (for example, sqlplus).

Procedure

Copy the <installation files dir>/scripts/oracle_install directory to a location where you can open and review (and if needed, edit) the contents.

This directory contains script files that correspond to supported platforms.

Linux: create_databases.sh
Windows: create_databases.bat
Linux (Oracle Database running on Amazon RDS): create_databases_rds.sh
Windows (Oracle Database running on Amazon RDS): create_databases_rds.bat

What to do next

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