Preparing the Oracle database for Spotfire

You can use either scripts or command-line commands that are provided with Spotfire Server to configure your Oracle database server to store your Spotfire database. First, prepare your Oracle database, and then select the best method for your system to create the Spotfire database.

About this task

If you plan to use one of the provided scripts to configure an Oracle database server for storing the Spotfire database, then configure the Spotfire database before running the Spotfire Server installer.
If you plan to create a Spotfire database using the CLI command create-db, first install the Spotfire Server. For more information about this option, see Creating a Spotfire database using the command create-db.

Before you begin

You have downloaded and unzipped the Spotfire Server installation kit from the TIBCO eDelivery web site. For instructions, see Downloading installation software.

Procedure

Configure the following settings on the Oracle database server computer.
- User name and password authentication.
- 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.
Make sure 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 any required command-line database tools.

What to do next

You can create the Spotfire database using the provided script or the command-line command create-db.