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

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

fix-descriptions

Fix artifact descriptions

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>]
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>

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

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>]
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

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]
Option Type Required Default Description

--connection-file

file

No

<none>

--prompt-for-password

flag

No

false

Prompt for the connection password

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.

set-checksum-function

Set checksum function

set-checksum-function [--checksum-function <string>]
Option Type Required Default Description

--checksum-function

string

No

<none>

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]
Option Type Required Default Description

--file

file

Yes

--version

string

No

<none>

--skip-checksum-recompute

flag

No

false

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]
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

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 contents of an artifact file

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

--file

file

Yes

--output

string

No

<none>

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

Repository Commands

create-tenant

Create a new tenant

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

--tenant

string

Yes

--import-starter-kit

flag

No

false

--delete-existing

flag

No

false

--file

file

No

<none>

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]
Option Type Required Default Description

--artifacts-only

flag

No

false

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

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

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.

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.

Vault Commands

vault-create

Create a vault

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

--id

string

Yes

--name

string

No

<none>

Display name for the vault artifact

--type

ExternalCredentialProviderType

Yes

--properties

string

No

<none>

Properties for the vault in var1=val1,var2=val2 format

vault-properties

List properties for a vault provider type

vault-properties --type <ExternalCredentialProviderType>
Option Type Required Default Description

--type

ExternalCredentialProviderType

Yes

vault-test

Test a vault by resolving credentials

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

--id

string

Yes

--secret-path

string

Yes

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