Command Reference

This page is generated from the Spring Shell command annotations in src/main/java. Edit command names, summaries, option names, defaults, and option help text in the command classes. Put narrative usage guidance and examples in the nearby Antora pages.

Artifact Commands

copy-artifact

Copy an artifact to a new ID

copy-artifact --artifact <string> [--category <string>] [--version <integer>] --new-id <string>
Option Type Required Default Description

--artifact

string

Yes

--category

string

No

<none>

--version

integer

No

1

--new-id

string

Yes

delete-all-artifacts

Delete all artifacts

delete-all-artifacts

This command has no options.

delete-artifact

Delete artifact

delete-artifact --artifact <string> [--category <string>] [--version <integer>]
Option Type Required Default Description

--artifact

string

Yes

--category

string

No

<none>

--version

integer

No

1

evaluate-artifact-property

Find literal text, a regex, or an XPath expression across one or more artifacts

evaluate-artifact-property --expression <string> [--xpath] [--regex] [--ignore-case] [--artifact-id <string>] [--category <string>] [--version <integer>] [--latest-only] [--include-system] [--all-artifacts] [--expect-artifact-count <integer>] [--expect-match-count <integer>] [--output <OutputFormat>]
Option Type Required Default Description

--expression

string

Yes

Literal text by default, an XPath expression with --xpath, or a Java regular expression with --regex

--xpath

flag

No

false

Interpret --expression as an XPath 1.0 expression selecting nodes

--regex

flag

No

false

Interpret --expression as a Java regular expression; mutually exclusive with --xpath

--ignore-case

flag

No

false

Case-insensitive literal/regex matching; invalid with --xpath

--artifact-id, --id

string

No

<none>

Exact, case-sensitive artifact ID

--category, --artifact-category

string

No

<none>

Exact category

--version

integer

No

<none>

Exact version; without it every version is eligible unless --latest-only is set

--latest-only

flag

No

false

Select the maximum version per category/ID

--include-system

flag

No

false

Include system/special artifacts

--all-artifacts

flag

No

false

Required when artifact ID, category, and version are all omitted

--expect-artifact-count

integer

No

<none>

Fail unless exactly this many eligible artifacts exist

--expect-match-count

integer

No

<none>

Fail unless the expression produces exactly this many matches/nodes

--output

OutputFormat

No

TABLE

Output format: TABLE or JSON

export-raw-artifact

Export a single artifact to file system

export-raw-artifact --artifact <string> [--category <string>] [--version <integer>] [--output-file <file>]
Option Type Required Default Description

--artifact

string

Yes

--category

string

No

<none>

--version

integer

No

1

--output-file

file

No

<none>

Path to write the exported artifact to

fix-descriptions

Deprecated: fix artifact descriptions with an older Dodeca Shell

fix-descriptions [--update]
Option Type Required Default Description

--update

flag

No

false

list-artifacts

List artifacts in the current tenant

list-artifacts [--category <string>] [--id <string>] [--latest-only] [--include-system] [--add-columns <string>] [--output <OutputFormat>]
Option Type Required Default Description

--category

string

No

<none>

--id

string

No

<none>

--latest-only

flag

No

false

--include-system

flag

No

false

Include system/special artifacts

--add-columns

string

No

<none>

--output

OutputFormat

No

TABLE

Output format: TABLE or JSON

Print artifact

print-artifact --artifact <string> [--category <string>] [--version <integer>] [--bytes] [--output-file <string>]
Option Type Required Default Description

--artifact

string

Yes

--category

string

No

<none>

--version

integer

No

1

--bytes

flag

No

false

--output-file

string

No

<none>

recovery-app

Deploy a recovery app to the current tenant

recovery-app [--recovery-app-id <string>]
Option Type Required Default Description

--recovery-app-id

string

No

RECOVERY

The artifact ID for the recovery application

update-artifact-property

Update literal text, a regex, or an XPath-selected value across one or more artifacts; preview-only unless --apply is given

update-artifact-property --expression <string> --new-value <string> [--old-value <string>] [--xpath] [--regex] [--ignore-case] [--artifact-id <string>] [--category <string>] [--version <integer>] [--latest-only] [--include-system] [--all-artifacts] [--expect-artifact-count <integer>] [--expect-match-count <integer>] [--apply] [--ignore-locks] [--output <OutputFormat>]
Option Type Required Default Description

--expression

string

Yes

Literal text by default, an XPath expression with --xpath, or a Java regular expression with --regex

--new-value

string

Yes

Literal replacement text, XPath node value, or Java regex replacement string

--old-value

string

No

<none>

XPath only: exact, case/whitespace-sensitive compare-and-set guard for selected nodes

--xpath

flag

No

false

Interpret --expression as an XPath 1.0 expression selecting nodes

--regex

flag

No

false

Interpret --expression as a Java regular expression; mutually exclusive with --xpath

--ignore-case

flag

No

false

Case-insensitive literal/regex matching; invalid with --xpath

--artifact-id, --id

string

No

<none>

Exact, case-sensitive artifact ID

--category, --artifact-category

string

No

<none>

Exact category

--version

integer

No

<none>

Exact version; without it every version is eligible unless --latest-only is set

--latest-only

flag

No

false

Select the maximum version per category/ID

--include-system

flag

No

false

Include system/special artifacts

--all-artifacts

flag

No

false

Required when artifact ID, category, and version are all omitted

--expect-artifact-count

integer

No

<none>

Fail unless exactly this many eligible artifacts exist

--expect-match-count

integer

No

<none>

Fail unless the expression produces exactly this many matches/nodes

--apply

flag

No

false

Persist the fully validated proposed changes; without this the command is preview-only

--ignore-locks

flag

No

false

Allow updates to locked artifacts

--output

OutputFormat

No

TABLE

Output format: TABLE or JSON

Artifact Dependency Commands

depends-on

View artifacts that depend on an artifact

depends-on --artifact <string> [--category <string>] [--version <integer>]
Option Type Required Default Description

--artifact

string

Yes

--category

string

No

<none>

--version

integer

No

1

view-dependencies

View artifact dependencies

view-dependencies --artifact <string> [--category <string>] [--version <integer>] [--scanner-config <file>]
Option Type Required Default Description

--artifact

string

Yes

--category

string

No

<none>

--version

integer

No

1

--scanner-config

file

No

<none>

Artifact Lock Commands

list-locks

List locks

list-locks

This command has no options.

lock

Lock artifact

lock --artifact <string> [--category <string>] [--version <integer>] [--user <string>]
Option Type Required Default Description

--artifact

string

Yes

--category

string

No

<none>

--version

integer

No

1

--user

string

No

<none>

unlock

Unlock artifact

unlock --artifact <string> [--category <string>] [--version <integer>]
Option Type Required Default Description

--artifact

string

Yes

--category

string

No

<none>

--version

integer

No

1

Audit Log Commands

delete-data-audit-log-records

Delete data audit log records

delete-data-audit-log-records [--all] [--days <integer>] [--members <string>]
Option Type Required Default Description

--all

flag

No

false

Delete all data audit log records

--days

integer

No

<none>

Delete all data audit log records older than the given number of days

--members

string

No

<none>

Delete only data audit log entries whose data points include all of the given members, such as a Scenario, Version, or Year member; may be combined with --days

delete-metadata-audit-log-records

Delete metadata audit log records

delete-metadata-audit-log-records [--all] [--days <integer>]
Option Type Required Default Description

--all

flag

No

false

Delete all metadata audit log records

--days

integer

No

<none>

Delete all metadata audit log records older than the given number of days

Comment Attachment Commands

delete-attachment

Delete comment attachment

delete-attachment --attachment-id <string>
Option Type Required Default Description

--attachment-id

string

Yes

import-attachment

Imports an attachment

import-attachment --file <file> --intersection <string> [--description <string>]
Option Type Required Default Description

--file

file

Yes

--intersection

string

Yes

--description

string

No

<none>

view-attachments

View comment attachments

view-attachments

This command has no options.

Comment Commands

copy-comments

Copy comments

copy-comments [--author <string>] [--include-key-spec <string>] [--exclude-key-spec <string>] [--remove-key-spec <string>] [--add-key-spec <string>] [--new-author <string>] [--tenant <string>]
Option Type Required Default Description

--author

string

No

<none>

--include-key-spec

string

No

<none>

--exclude-key-spec

string

No

<none>

--remove-key-spec

string

No

<none>

--add-key-spec

string

No

<none>

--new-author

string

No

<none>

Update the created by property

--tenant

string

No

<none>

Set different tenant for the comments

delete-comments

Delete comments

delete-comments [--include-key-spec <string>] [--partial-address] [--after <string>] [--before <string>] [--comment-id <string>] [--confirm]
Option Type Required Default Description

--include-key-spec

string

No

<none>

Key spec of comments, such as Period=Jan,Scenario=Actual

--partial-address

flag

No

false

Set if key spec address only needs to be partial match

--after

string

No

<none>

--before

string

No

<none>

--comment-id

string

No

<none>

ID of a comment to delete

--confirm

flag

No

false

find-comments

Find comments

find-comments [--include-key-spec <string>] [--partial-address] [--after <string>] [--before <string>]
Option Type Required Default Description

--include-key-spec

string

No

<none>

Key spec of comments, such as Period=Jan,Scenario=Actual

--partial-address

flag

No

false

Set if key spec address only needs to be partial match

--after

string

No

<none>

--before

string

No

<none>

update-comments

Update existing comments by adding, updating, and/or removing keys/values

update-comments [--include-key-spec <string>] [--update-key-spec <string>] [--partial-address] [--remove-key-spec <string>]
Option Type Required Default Description

--include-key-spec

string

No

<none>

Key spec of comments to update, such as Period=Jan,Scenario=Actual

--update-key-spec

string

No

<none>

Key spec to update/add, such as Year=FY20

--partial-address

flag

No

false

Set if key spec address only needs to be partial match

--remove-key-spec

string

No

<none>

Comma separated list of keys to remove from address

zap-gremlins

Zap gremlins in comments

zap-gremlins [--dry-run] [--fetch-size <integer>]
Option Type Required Default Description

--dry-run

flag

No

false

--fetch-size

integer

No

1000

Data Source Commands

connect

Connect to Dodeca repository using connection details file

connect [--connection-file <file>] [--prompt-for-password] [--password-secret-source <string>]
Option Type Required Default Description

--connection-file

file

No

<none>

--prompt-for-password

flag

No

false

Prompt for the connection password

--password-secret-source

string

No

<none>

Password source: env:NAME, file:PATH, or literal:VALUE

drivers

List available JDBC drivers

drivers

This command has no options.

encrypt

Encrypt text for use in connection properties file

encrypt --text <string>
Option Type Required Default Description

--text

string

Yes

inmem

Set the repository to an H2 data source

inmem [--tenant <string>] [--server]
Option Type Required Default Description

--tenant

string

No

<none>

Export the given tenant in the currently connected repository and import it to the new H2 repository

--server

flag

No

false

Run H2 as a TCP server and connect to jdbc:h2:tcp://localhost:9092/mem:dodeca

jdbc-test

Create and test JDBC connections

jdbc-test [--file <file>] [--no-masked-inputs]
Option Type Required Default Description

--file

file

No

<none>

Use properties from file

--no-masked-inputs

flag

No

false

Force terminal to not mask any inputs

list-connections

List available connection files

list-connections

This command has no options.

External Credential Provider Commands

credential-source-create

Create an external credential source

credential-source-create --id <string> [--name <string>] --type <ExternalCredentialProviderType> [--properties <string>] [--secret-properties <string>]
Option Type Required Default Description

--id

string

Yes

--name

string

No

<none>

Display name for the credential source artifact

--type

ExternalCredentialProviderType

Yes

--properties

string

No

<none>

Non-sensitive provider properties in name=value,name=value format

--secret-properties

string

No

<none>

Sensitive provider properties using env:NAME, file:PATH, literal:VALUE, or prompt:

credential-source-properties

List properties for an external credential provider type

credential-source-properties --type <ExternalCredentialProviderType>
Option Type Required Default Description

--type

ExternalCredentialProviderType

Yes

credential-source-test

Test an external credential source without displaying secret values

credential-source-test --id <string> --secret-path <string>
Option Type Required Default Description

--id

string

Yes

--secret-path

string

Yes

JDBC Driver Commands

jdbc-driver-delete

Delete a repository JDBC driver bundle

jdbc-driver-delete --id <string> [--force]
Option Type Required Default Description

--id

string

Yes

--force

flag

No

false

Delete even when stored SQL connections refer to this bundle

jdbc-driver-export

Export a repository JDBC driver bundle

jdbc-driver-export --id <string> [--output-file <file>]
Option Type Required Default Description

--id

string

Yes

--output-file

file

No

<none>

jdbc-driver-import

Import one or more JARs as a repository JDBC driver bundle

jdbc-driver-import --id <string> --jar <string> [--driver-class <string>]
Option Type Required Default Description

--id

string

Yes

--jar

string

Yes

--driver-class

string

No

<none>

Driver class to use when the JAR has no JDBC service declaration

jdbc-driver-inspect

Show details for a repository JDBC driver bundle

jdbc-driver-inspect --id <string>
Option Type Required Default Description

--id

string

Yes

jdbc-driver-list

List repository JDBC driver bundles

jdbc-driver-list [--output <OutputFormat>]
Option Type Required Default Description

--output

OutputFormat

No

TABLE

Output format: TABLE or JSON

jdbc-driver-test

Test the driver used by a stored SQL connection

jdbc-driver-test --connection-id <string>
Option Type Required Default Description

--connection-id

string

Yes

License Commands

import-license

Import a license file

import-license --file <file> [--validate-only]
Option Type Required Default Description

--file

file

Yes

--validate-only

flag

No

false

user-audit

User audit

user-audit [--days <integer>] [--dai] [--print] [--filename <string>]
Option Type Required Default Description

--days

integer

No

30

--dai

flag

No

false

Considers Excel add-in users instead of Dodeca

--print

flag

No

false

Print out the list of users

--filename

string

No

<none>

File to print to (CSV)

validate-current-license

Validate the current server license

validate-current-license [--encode]
Option Type Required Default Description

--encode

flag

No

false

Encode license for startup parameter

Migration Commands

available-versions

List available migration versions

available-versions

This command has no options.

export-tenant

Export tenant from this or another repository

export-tenant [--connection-file <file>] [--all-tenants] [--version <string>] [--tenant <string>] [--options <string>] [--output-directory <file>] [--export-file <string>] [--fetch-size <integer>] [--append-date]
Option Type Required Default Description

--connection-file

file

No

<none>

Connection file to use (default is current connection)

--all-tenants

flag

No

false

--version

string

No

<none>

The repository version, if none the default will be used, list versions with available-versions

--tenant

string

No

<none>

The tenant to export, if none, the current one will be used

--options

string

No

<none>

--output-directory

file

No

<none>

--export-file

string

No

<none>

Export filename, if not specified, the current tenant will be used

--fetch-size

integer

No

<none>

Set a JDBC fetch size

--append-date

flag

No

false

Append a datestamp to the file

import-comments

Import comments (alias for import-tenant command with only comments enabled)

import-comments --file <file> [--version <string>] [--skip-checksum-recompute] [--checksum-function <string>]
Option Type Required Default Description

--file

file

Yes

--version

string

No

<none>

--skip-checksum-recompute

flag

No

false

--checksum-function

string

No

SHA-256

Checksum function for this import; use SHA-1 only for a pre-Dodeca-8 target

import-starter-kit

Import the standard starter kit to the current tenant

import-starter-kit

This command has no options.

import-tenant

Import tenant

import-tenant --file <file> [--version <string>] [--skip-on-existing-checksum] [--imported-by <string>] [--skip-checksum-recompute] [--continue-on-error] [--batch-size <integer>] [--threads <integer>] [--import-user <string>] [--fast] [--all] [--update-metadata-audit-log] [--honor-locks] [--checksum-function <string>]
Option Type Required Default Description

--file

file

Yes

The file to import that was previously created with export-tenant or from Dodeca

--version

string

No

<none>

Force use of an explicit repository version, leave unspecified to automatically determine

--skip-on-existing-checksum

flag

No

false

Skip update if the object already exists

--imported-by

string

No

system

Set METADATA_AUDIT_LOG.USER_ID when updating the metadata audit log

--skip-checksum-recompute

flag

No

false

Skip explicit checksum recompute after import job runs

--continue-on-error

flag

No

false

Continue processing even if error is detected

--batch-size

integer

No

<none>

Set the JDBC batch size to use

--threads

integer

No

<none>

Enable multi-threading for the import job

--import-user

string

No

<none>

Set BINARY_ARTIFACTS.IMPORTED_BY for imported artifacts

--fast

flag

No

false

Shortcut flag that turns on existing checksum skipping, batching (500), and multi-threading (# of CPUs)

--all

flag

No

false

Import all object types

--update-metadata-audit-log

flag

No

false

Update METADATA_AUDIT_LOG when existing binary artifacts are updated

--honor-locks

flag

No

false

Use to honor locks and skip updates to locked artifact

--checksum-function

string

No

SHA-256

Checksum function for this import; use SHA-1 only for a pre-Dodeca-8 target

Misc Commands

clear-cache

Clear Hibernate cache

clear-cache

This command has no options.

decode

Decode encoded artifact contents

decode --encoded-contents <string>
Option Type Required Default Description

--encoded-contents

string

Yes

decode-file

Decode the contents of an artifact XML file.

decode-file --file <file> [--output <file>]
Option Type Required Default Description

--file, -f

file

Yes

Artifact XML file to decode.

--output, -o

file

No

<none>

File to write the decoded contents to. Writes to the console when omitted.

diagnostics

Generate diagnostics

diagnostics [--wait <integer>] [--print]
Option Type Required Default Description

--wait

integer

No

30

--print

flag

No

false

echo

Echo text to the console

echo --text <string>
Option Type Required Default Description

--text

string

Yes

Use quotes to surround text

load-permissions

Load permission to the repository

load-permissions

This command has no options.

logger

Set the logging level

logger --level <string> [--root] [--suppress]
Option Type Required Default Description

--level

string

Yes

--root

flag

No

false

Set to update the root logger, leave off for just the shell logger

--suppress

flag

No

false

Suppress logging in this command

schema-docs

Generate repository schema documentation

schema-docs [--output <file>] [--format <string>]
Option Type Required Default Description

--output

file

No

<none>

Write documentation to a file instead of printing to the console

--format

string

No

markdown

Output format: markdown or asciidoc

set

Set a variable

set [--env] [--name <string>] [--value <string>]
Option Type Required Default Description

--env

flag

No

false

Set variable from environment. Pass with no parameters to pull in all environment variables

--name

string

No

<none>

The name of a variable to set, or the name of an environment variable if using the --env option

--value

string

No

<none>

Value to set for a variable, or a default value to use if an environment variable doesn’t exist

set-locks

Artifact locks setting

set-locks [--enablement <string>]
Option Type Required Default Description

--enablement

string

No

<none>

ssl-poke

SSL poke

ssl-poke --host <string> --port <integer>
Option Type Required Default Description

--host

string

Yes

--port

integer

Yes

Principal Commands

principal-authority-add

Grant a server authority to a principal

principal-authority-add --id <string> --authority <string>
Option Type Required Default Description

--id

string

Yes

--authority

string

Yes

principal-authority-list

List server authorities granted to a principal

principal-authority-list --id <string>
Option Type Required Default Description

--id

string

Yes

principal-authority-remove

Remove a server authority from a principal

principal-authority-remove --id <string> --authority <string>
Option Type Required Default Description

--id

string

Yes

--authority

string

Yes

principal-create

Create a canonical principal

principal-create --name <string> [--type <Type>] [--status <Status>]
Option Type Required Default Description

--name

string

Yes

--type

Type

No

PERSON

--status

Status

No

ACTIVE

principal-identity-add

Attach an authentication identity to a principal

principal-identity-add --id <string> --provider <string> --subject <string>
Option Type Required Default Description

--id

string

Yes

--provider

string

Yes

--subject

string

Yes

principal-identity-list

List identities attached to a principal

principal-identity-list --id <string>
Option Type Required Default Description

--id

string

Yes

principal-identity-remove

Remove an authentication identity from a principal

principal-identity-remove --id <string> --provider <string> --subject <string>
Option Type Required Default Description

--id

string

Yes

--provider

string

Yes

--subject

string

Yes

principal-list

List canonical principals

principal-list

This command has no options.

principal-native-admin-create

Create an active principal, native login, and administrator grant in one step

principal-native-admin-create --username <string> [--name <string>] [--secret-source <string>]
Option Type Required Default Description

--username

string

Yes

--name

string

No

<none>

--secret-source

string

No

<none>

Password source: env:NAME, file:PATH, or literal:VALUE; omit for a masked prompt

principal-native-login-add

Add a native login; securely prompts for and confirms the password

principal-native-login-add --id <string> --username <string> [--secret-source <string>]
Option Type Required Default Description

--id

string

Yes

--username

string

Yes

--secret-source

string

No

<none>

Password source: env:NAME, file:PATH, or literal:VALUE; omit for a masked prompt

principal-native-login-list

List native logins for a principal

principal-native-login-list --id <string>
Option Type Required Default Description

--id

string

Yes

principal-native-login-lock

Lock a native login

principal-native-login-lock --id <string> --username <string>
Option Type Required Default Description

--id

string

Yes

--username

string

Yes

principal-native-login-remove

Remove a native identity and its password credential without removing the principal

principal-native-login-remove --id <string> --username <string>
Option Type Required Default Description

--id

string

Yes

--username

string

Yes

principal-native-login-require-password-change

Require a native user to change the password at next login

principal-native-login-require-password-change --id <string> --username <string>
Option Type Required Default Description

--id

string

Yes

--username

string

Yes

principal-native-login-set-password

Reset a native login password using a masked prompt

principal-native-login-set-password --id <string> --username <string> [--secret-source <string>]
Option Type Required Default Description

--id

string

Yes

--username

string

Yes

--secret-source

string

No

<none>

Password source: env:NAME, file:PATH, or literal:VALUE; omit for a masked prompt

principal-native-login-unlock

Unlock a native login

principal-native-login-unlock --id <string> --username <string>
Option Type Required Default Description

--id

string

Yes

--username

string

Yes

principal-preference-get

Get a principal preference

principal-preference-get --id <string> --namespace <string> --name <string>
Option Type Required Default Description

--id

string

Yes

--namespace

string

Yes

--name

string

Yes

principal-preference-list

List preferences owned by a principal

principal-preference-list --id <string> [--namespace <string>]
Option Type Required Default Description

--id

string

Yes

--namespace

string

No

<none>

principal-preference-remove

Remove a principal preference

principal-preference-remove --id <string> --namespace <string> --name <string>
Option Type Required Default Description

--id

string

Yes

--namespace

string

Yes

--name

string

Yes

principal-preference-set

Create or update a principal preference

principal-preference-set --id <string> --namespace <string> --name <string> --value <string>
Option Type Required Default Description

--id

string

Yes

--namespace

string

Yes

--name

string

Yes

--value

string

Yes

principal-set-name

Change a principal name

principal-set-name --id <string> --name <string>
Option Type Required Default Description

--id

string

Yes

--name

string

Yes

principal-set-status

Change a principal status

principal-set-status --id <string> --status <Status>
Option Type Required Default Description

--id

string

Yes

--status

Status

Yes

principal-set-type

Change a principal type

principal-set-type --id <string> --type <Type>
Option Type Required Default Description

--id

string

Yes

--type

Type

Yes

principal-show

Show a canonical principal

principal-show --id <string>
Option Type Required Default Description

--id

string

Yes

Repository Commands

list-tenants

List available tenants

list-tenants [--deep] [--include-reserved]
Option Type Required Default Description

--deep

flag

No

false

Check for tenant presence based on all tables, not just binary artifacts

--include-reserved

flag

No

false

Include reserved/system tenants

recompute-checksums

Recompute checksums for artifacts/comments

recompute-checksums [--artifacts-only] [--checksum-function <string>]
Option Type Required Default Description

--artifacts-only

flag

No

false

--checksum-function

string

No

SHA-256

Checksum function to write; use SHA-1 only for a pre-Dodeca-8 target

repo-version

Version of repository

repo-version

This command has no options.

tables

Show tables in Dodeca repository

tables

This command has no options.

unuse

Unset active tenant

unuse

This command has no options.

upgrade

Upgrade or deploy a Dodeca schema to current version

upgrade [--migration-bundle <file>] [--dry-run]
Option Type Required Default Description

--migration-bundle

file

No

<none>

Use a custom schema migration bundle

--dry-run

flag

No

false

Output SQL that would be executed to files instead of executing it

use

Set active tenant

use --tenant <string> [--force] [--skip-tenant-check]
Option Type Required Default Description

--tenant

string

Yes

--force

flag

No

false

Force use of the tenant, even if it doesn’t exist

--skip-tenant-check

flag

No

false

Skip tenant check, has no effect if force is used

SQL Commands

dataset

Execute a stored SQLPTDS for testing

dataset --id <string> [--params <string>] [--repeat <integer>] [--print] [--concurrent]
Option Type Required Default Description

--id

string

Yes

The ID of a SQLPTDS object

--params

string

No

<none>

Tokens for the SQLPTDS in var1=val1 var2=val2 format

--repeat

integer

No

1

The number of times to repeat dataset execution

--print

flag

No

false

Whether to print the results of the dataset execution

--concurrent

flag

No

false

Whether to execute the dataset in concurrent mode

sql

Run a SQL statement

sql --query <string> [-c <integer>]
Option Type Required Default Description

--query

string

Yes

-c

integer

No

24

test-connection

Test a SQL connection

test-connection --connection-id <string>
Option Type Required Default Description

--connection-id

string

Yes

Saved View Commands

delete-saved-view

Delete a saved view and all its sharing information

delete-saved-view --id <string> [--force]
Option Type Required Default Description

--id

string

Yes

--force

flag

No

false

list-saved-views

List saved views in the current tenant

list-saved-views [--user <string>]
Option Type Required Default Description

--user

string

No

<none>

list-shared-views

List views shared by or with specified users

list-shared-views [--user <string>] [--shared-by] [--shared-with]
Option Type Required Default Description

--user

string

No

<none>

--shared-by

flag

No

false

--shared-with

flag

No

false

remove-sharing

Remove sharing access for a specific user or role (from one view or all views)

remove-sharing [--view-id <string>] --user-or-role <string>
Option Type Required Default Description

--view-id

string

No

<none>

--user-or-role

string

Yes

Server Commands

create-server-admin

Creates a server level admin for web administration

create-server-admin --username <string> --password <string>
Option Type Required Default Description

--username

string

Yes

--password

string

Yes

delete-download

Removes a download

delete-download --id <string>
Option Type Required Default Description

--id

string

Yes

delete-downloads

delete-downloads

This command has no options.

import-download

Import a document that can be downloaded from Dodeca wen interface

import-download --file <file>
Option Type Required Default Description

--file

file

Yes

The file or folder to import

Smart Client Commands

delete-client

Deletes any client files stored in the repository

delete-client --version <string>
Option Type Required Default Description

--version

string

Yes

export-client

Export an installed client version as a distribution ZIP

export-client --version <string> [--output-file <file>]
Option Type Required Default Description

--version

string

Yes

Installed client version to export

--output-file

file

No

<none>

ZIP file to write; defaults to a versioned client filename

import-client

Import a client distribution into the repository

import-client --client-zip <file> [-u]
Option Type Required Default Description

--client-zip

file

Yes

-u

flag

No

false

Upgrade current client after import

list-versions

List available client versions

list-versions [--product <Product>]
Option Type Required Default Description

--product

Product

No

DSMS

upgrade-client

Set the current client version for a repository client type

upgrade-client [--version <string>] [--force]
Option Type Required Default Description

--version

string

No

<none>

Version of client to activate, leave blank to use latest

--force

flag

No

false

Use this option to force a client upgrade without validating

Starter Kit Commands

import-starter-kit

Import a new starter kit to the system

import-starter-kit --file <file> --name <string>
Option Type Required Default Description

--file

file

Yes

The starter kit file to import

--name

string

Yes

list-starter-kits

List available starter kits

list-starter-kits

This command has no options.

Tenant Commands

cert

View tenant certificate

cert

This command has no options.

create-tenant

Create a new tenant

create-tenant --tenant <string> [--standard-starter-kit] [--server-starter-kit <string>] [--file <file>] [--delete-existing]
Option Type Required Default Description

--tenant

string

Yes

The new tenant name

--standard-starter-kit, --import-starter-kit

flag

No

false

Initialize from the standard packaged starter kit

--server-starter-kit

string

No

<none>

Initialize from a starter kit stored in the Dodeca repository

--file

file

No

<none>

Initialize from a Dodeca export or migrator-compatible file

--delete-existing

flag

No

false

Delete all existing tenant data before creation

delete-tenant

Delete the current tenant

delete-tenant [--confirm]
Option Type Required Default Description

--confirm

flag

No

false

This flag must be set in order to confirm deletion

export-certificate

Export a certificate to be used in a Dodeca Essbase servlet

export-certificate --filename <string> --days <integer>
Option Type Required Default Description

--filename

string

Yes

File to export certificate to

--days

integer

Yes

Number of days that the exported certificate is valid for

generate-encryption-keys

Generate/regenerate tenant encryption keys

generate-encryption-keys [--regenerate] [--logical-id <string>] [--token-duration-seconds <integer>] [--certificate-duration-days <integer>]
Option Type Required Default Description

--regenerate

flag

No

false

Specify to regenerate the public/private keys if they already exist

--logical-id

string

No

<none>

The logical ID of the Dodeca server (typically the Dodeca server name, or load balancer)

--token-duration-seconds

integer

No

86400

Token duration seconds

--certificate-duration-days

integer

No

3650

Number of days crypto certificate will be valid for

list-tenant-option-names

List tenant configuration options

list-tenant-option-names

This command has no options.

set-tenant-option

Set a tenant configuration option

set-tenant-option --option-name <string> --option-value <string>
Option Type Required Default Description

--option-name

string

Yes

--option-value

string

Yes

stats

Print information about the current tenant

stats

This command has no options.

Tenant Token Commands

tenant-token-create

Create a tenant token

tenant-token-create --id <string> [--value-source <string>] [--credential-source <string>] [--secret-path <string>] [--property-name <string>]
Option Type Required Default Description

--id

string

Yes

--value-source

string

No

<none>

Secret source: env:NAME, file:PATH, literal:VALUE, or prompt:

--credential-source

string

No

<none>

--secret-path

string

No

<none>

--property-name

string

No

<none>

tenant-token-delete

Delete a tenant token

tenant-token-delete --id <string> [--force]
Option Type Required Default Description

--id

string

Yes

--force

flag

No

false

tenant-token-get

Show tenant token metadata

tenant-token-get --id <string>
Option Type Required Default Description

--id

string

Yes

tenant-token-list

List tenant tokens

tenant-token-list

This command has no options.

tenant-token-update

Update a tenant token

tenant-token-update --id <string> [--value-source <string>] [--credential-source <string>] [--secret-path <string>] [--property-name <string>]
Option Type Required Default Description

--id

string

Yes

--value-source

string

No

<none>

Secret source: env:NAME, file:PATH, literal:VALUE, or prompt:

--credential-source

string

No

<none>

--secret-path

string

No

<none>

--property-name

string

No

<none>

View Usage Commands

view-usages

List of view usages

view-usages [--view <string>] [--user <string>] --days <integer>
Option Type Required Default Description

--view

string

No

<none>

--user

string

No

<none>

--days

integer

Yes