Example script: Oracle database on premises using create-db command
The following example shows planning for and creating a Spotfire database schema for a Oracle database in an on-premises Spotfire Server deployment.
Use the
following code template to plan and create a database schema with the command
create-db
.
See
Creating a Spotfire database using the command create-db
for instructions.
Oracle database on premises:
config create-db
--driver-class="oracle.jdbc.OracleDriver"
--database-url="jdbc:oracle:thin:@//{{database-host}}:{{database-port}}/{{service}}"
--admin-username="{{admin-user}}"
--admin-password="{{admin-password}}"
--spotfiredb-username="{{spotfiredb-user}}"
--spotfiredb-password="{{spotfiredb-password}}"
--oracle-rootfolder="{{oracle-rootfolder}}"
--oracle-tablespace-prefix="{{tablespace-prefix}}"
For each option shown in the above example,
replace the placeholder variable with your own value. The following example
shows example values to pass to the command
create-db
.
Option | Example value |
---|---|
--driver-class
|
"oracle.jdbc.OracleDriver"
|
--database-url
|
"jdbc:oracle:thin:@ORCLDB:5432/spotfire"
|
--admin-username
|
"system"
|
--admin-password
|
"system"
|
--spotfiredb-dbname
|
"spotfire"
|
--spotfiredb-username
|
"admin"
|
--oracle-rootfolder
|
"C:\orcl\datafiles"
|
--oracle-tablespace-prefix
|
SPOTFIRE
|
In the following code, we have
replaced the template variables with the example values. The command is ready
to run to create the database schema. Your values will differ.
Note: This example has line breaks to make it easier to read the assigned
values. To use this example, you must copy it to a text editor, provide your
own values, and remove the line breaks first.
config create-db
--driver-class="oracle.jdbc.OracleDriver"
--database-url="jdbc:oracle:thin:@myservername:5432:spotfire"
--admin-username="system"
--admin-password="system"
--spotfiredb-username="spotfire"
--spotfiredb-password="admin"
--oracle-rootfolder="C:\orcl\datafiles"
--oracle-tablespace-prefix="SPOTFIRE"
Parent topic: Examples for on-premises database deployments