create-actionlogdb
Creates the Spotfire action log database schema.
create-actionlogdb
<-c value | --driver-class=value>
<--database-url=value>
[--admin-username=value]
[--admin-password=value]
[--actiondb-dbname=value]
[--actiondb-username=value]
[--actiondb-password=value]
[-v value | --variant=value]
[-r value | --oracle-rootfolder=value]
[-t value | --oracle-tablespace-prefix=value]
[-a | --do-not-create-user]
[-n | --no-prompt]
[--timeout-seconds=value]
Overview
Use this command to create a Spotfire Action log database schema.
Options
Option | Optional or Required | Default Value | Description |
---|---|---|---|
|
Required | none | Specifies the name of the JDBC driver class. |
|
Required | none | Specifies the JDBC URL to the database. Because this argument usually contains special characters, be sure to escape those characters, or to enclose the values between quotes. |
|
Optional | none | Specifies the user name of the database administrator. |
|
Optional | none | Specifies the password of the database
administrator. If no admin password is given, then the tool prompts for the
password. If the
--no-prompt flag is given, no prompt for the
password is displayed.
|
|
Optional only for the Oracle database driver | none | Specifies the name of the Spotfire database. |
|
Optional | none | Specifies the user name for the Spotfire action log database. |
|
Optional | none | Specifies the password for the Spotfire
action log database. If no Spotfire database password is given, then the tool
prompts for the password. If the
--no-prompt flag is given, no prompt for the
password is displayed.
|
|
Optional | none | Specifies the variant for database user
creation.
|
|
Optional except for the Oracle database driver | none | Specifies the Oracle root folder to create the table space. |
|
Optional except for the Oracle database driver | SPOTFIRE
|
Specifies the prefix of the table space
name for Oracle. It appends
'_DATA' and
'_TEMP' during tablespaces creation. Make sure
that it is unique in the database.
|
|
Optional | none | Specifies that the tool does not create a new Spotfire user. |
|
Optional | none | Specifies that the tool does not prompt for missing password arguments. |
|
Optional | 0
|
Specifies the timeout, in seconds, for the operation. |
Examples
- Create Action Log database schema with the PostgreSQL JDBC driver
-
create-actionlogdb --driver-class="org.postgresql.Driver" --database-url="jdbc:postgresql://{{database-host}}:{{database-port}}/" --admin-username="{{admin-user}}" --admin-password="{{admin-password}}" --actiondb-dbname="{{actionlog-database}}" --actiondb-username="{{actiondb-user}}" --actiondb-password="{{actiondb-password}}"
- Create Action Log database schema with the Microsoft JDBC driver
-
create-actionlogdb --driver-class="com.microsoft.sqlserver.jdbc.SQLServerDriver" --database-url="jdbc:sqlserver://{{database-host}}:{{database-port}}" --admin-username="{{admin-user}}" --admin-password="{{admin-password}}" --actiondb-dbname="{{actionlog-database}}" --actiondb-username="{{actiondb-user}}" --actiondb-password="{{actiondb-password}}"
- Create Action Log database schema with the Oracle thin JDBC driver
-
create-actionlogdb --driver-class="oracle.jdbc.OracleDriver" --database-url="jdbc:oracle:thin:@//{{database-host}}:{{database-port}}/{{service}}" --admin-username="{{admin-user}}" --admin-password="{{admin-password}}" --actiondb-username="{{actiondb-user}}" --actiondb-password="{{actiondb-password}}" --oracle-rootfolder="{{oracle-rootfolder}}" --oracle-tablespace-prefix="{{tablespace-prefix}}"
- Create Spotfire database schema with Azure
- PostgreSQL:
create-actionlogdb --driver-class="org.postgresql.Driver" --database-url="jdbc:postgresql://{{database-host}}:{{database-port}}/{{database-name}}" --admin-username="{{admin-user}}" --admin-password="{{admin-password}}" --actiondb-dbname="{{actionlog-database}}" --do-not-create-user
- Create Spotfire database schema with Azure:
- PostgreSQL:
create-actionlogdb --driver-class="org.postgresql.Driver" --database-url="jdbc:postgresql://{{database-host}}:{{database-port}}/{{database-name}}" --admin-username="{{admin-user}}" --admin-password="{{admin-password}}" --actiondb-dbname="{{actionlog-database}}" --do-not-create-user
- Create Action Log database schema with AWS
- PostgresSQL:
create-actionlogdb --driver-class="org.postgresql.Driver" --database-url="jdbc:postgresql://{{database-host}}:{{database-port}}/" --admin-username="{{admin-user}}" --admin-password="{{admin-password}}" --actiondb-dbname="{{actionlog-database}}" --do-not-create-user
- Create Action Log database schema with Google Cloud
- PostgresSQL:
create-actionlogdb --driver-class="org.postgresql.Driver" --database-url="jdbc:postgresql://{{database-host}}:{{database-port}}/" --admin-username="{{admin-user}}" --admin-password="{{admin-password}}" --actiondb-dbname="{{actionlog-database}}" --do-not-create-user
Parent topic: Command-line reference