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.
About this task
For example, if you are an experienced script author and experienced
with setting up multiple database servers, then you can modify just
DBSERVER_CONNECTIDENTIFIER
for every new database
server and specify the environment variable values for all other settings.
Before you begin
Complete the requirements and steps described in Preparing the Oracle database for Spotfire.
Procedure
Results
The log file log.txt file is created in the working directory. If the execution fails, then the log file contains information about the failure. If the execution succeeds, then information about changes to the database (such as Tablespace created, User created, and so on) are reflected in the log file.
What to do next
- Variables in create_databases (Oracle)
Use these variables in the script for setting up a Spotfire database for Oracle.
- Edit the Oracle create_databases script directly
- Run the script for Oracle interactively
- Edit the PostgreSQL create_databases script directly
- Run the script for PostgreSQL interactively
- Use environment variables to set up the Spotfire database for PostgreSQL
- Edit the SQL Server create_databases script directly
- Run the script for SQL Server interactively
- Use environment variables to set up the Spotfire database for SQL Server
- Setting up the Spotfire database (SQL Server with Integrated Windows authentication)
- Running database preparation scripts manually