Example script: Oracle database on AWS using create-db command
The following example shows planning for and creating a Spotfire database schema for a Oracle database on AWS.
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 AWS:
config create-db
--driver-class="oracle.jdbc.OracleDriver"
--database-url="jdbc:oracle:thin:@{{database-host}}:{{database-port}}:ORCL"
--admin-username="{{admin-user}}"
--admin-password="{{admin-password}}"
--oracle-tablespace-prefix="{{oracle-tablespace-prefix}}"
--spotfiredb-username="{{spotfiredb-user}}"
--spotfiredb-password="{{spotfiredb-password}}"
--variant="rds"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:@myservername:5432:ORCL"
|
--admin-username
|
"oracle-admin"
|
--admin-password
|
"oracle-admin"
|
--spotfiredb-dbname
|
SPOTFIRE
|
--spotfiredb-username
|
"sfdbuser"
|
--spotfiredb-password
|
"sfdbuser"
|
--variant
|
"rds"
|
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:ORCL"
--admin-username="oracle-admin"
--admin-password="oracle-admin"
--oracle-tablespace-prefix="SPOTFIRE"
--spotfiredb-username="sfdbuser"
--spotfiredb-password="sfdbuser"
--variant="rds"