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-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
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> |
Artifact Dependency Commands
Artifact Lock Commands
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 |
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 |
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 |
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 |
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 |
flag |
No |
false |
Print out the list of users |
|
--filename |
string |
No |
<none> |
File to print to (CSV) |
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
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 |
|
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 |
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 |
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 |
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 |
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 |
flag |
No |
false |
Whether to print the results of the dataset execution |
|
--concurrent |
flag |
No |
false |
Whether to execute the dataset in concurrent mode |
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> |
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 |
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
Tenant Commands
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.
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 |