Creating the Spotfire database using provided scripts
This section provides procedures for setting up a Spotfire database using the scripts provided in the Spotfire Server installation directory.
If you prefer to set up your Spotfire database using the command-line
command
create-db
, see
Creating a Spotfire database using the command create-db.
- Edit the Oracle 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 Oracle. - Run the script for Oracle 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. - Use environment variables to set up the Spotfire database for Oracle
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. - Edit the PostgreSQL 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 PostgreSQL. - Run the script for PostgreSQL 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. - Use environment variables to set up the Spotfire database for PostgreSQL
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. - 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. - 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. - 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. - Setting up the Spotfire database (SQL Server with Integrated Windows authentication)
If you plan to use Microsoft SQL Server for storing the Spotfire database, on a Windows computer in a Windows domain and you also plan to use Integrated Windows authentication between Spotfire Server and the Spotfire database in SQL, follow these steps before running the Spotfire Server installer. - Running database preparation scripts manually
If you plan to set up Kerberos authentication between your database and Spotfire Server, you must run the database SQL preparation scripts manually.
- Edit the Oracle 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 Oracle. - Run the script for Oracle 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. - Use environment variables to set up the Spotfire database for Oracle
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. - Edit the PostgreSQL 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 PostgreSQL. - Run the script for PostgreSQL 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. - Use environment variables to set up the Spotfire database for PostgreSQL
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. - 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. - 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. - 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. - Setting up the Spotfire database (SQL Server with Integrated Windows authentication)
If you plan to use Microsoft SQL Server for storing the Spotfire database, on a Windows computer in a Windows domain and you also plan to use Integrated Windows authentication between Spotfire Server and the Spotfire database in SQL, follow these steps before running the Spotfire Server installer. - Running database preparation scripts manually
If you plan to set up Kerberos authentication between your database and Spotfire Server, you must run the database SQL preparation scripts manually.
Parent topic: Preparation