Creating a Spotfire database using the command create-db

The command create-db contains all of the options to create a Spotfire database schema for on-site deployments on Linux or Windows, or cloud deployments on Azure, AWS, or Google Cloud. You can specify the database type as Oracle, PosgreSQL, or MSSQL.

Before you begin

Prepare the database.
- For Oracle, see Setting up the Spotfire database (Oracle).
- For PostgreSQL, see Setting up the Spotfire database (PostgreSQL).
- For SQL Server, see Setting up the Spotfire database (SQL Server).
Install Spotfire Server.
Review the documentation for create-db and gather the information needed to provide the appropriate values for the command's options.

About this task

Perform this task on the computer where Spotfire Server is installed.

Procedure

Open a command prompt as administrator.
Go to <install-dir>/tomcat/spotfire-bin.
Run the command config create-db, passing in the values for the variables needed.
The following example of can create a database template on AWS for a PostgreSQL database.
Note: The following example is for information purposes only, and only for a cloud-based PostgreSQL database. This example has line breaks to make it easier to read the assigned values. To adapt this example for your own deployment, first copy it to a text editor and remove the line breaks.
```
config create-db 
--driver-class="org.postgresql.Driver" 
--database-url="jdbc:postgresql://myservername:5432/postgres"
--admin-username="postgres" 
--admin-password="postgres" 
--spotfiredb-dbname="myspotfiredb" 
--do-not-create-user
```
Note: See the following sections for examples of calling create-db for each of the supported database options.

Results

The database schema is created, and the log is written to the file tools.log.