Using the dt command line tool

Contents[Hide]

1. Overview

The dt.exe tool lets you perform various admin/configuration tasks from the command-line:

  • reset the admin password
  • run a health check on the application
  • change configuration settings
  • encrypt/decrypt the connection information

2. View the help page for dt

On the server where Dundas BI is installed, open a Command Prompt window and navigate to the tools folder. By default, this folder location is:

C:\Program Files\Dundas Data Visualization Inc\Dundas BI\Instances\{InstanceName}\tools

In the command prompt window, type dt help to get the help page for this tool.

C:\Program Files\Dundas Data Visualization Inc\Dundas BI\Instances\Instance1\tools>dt help
Dundas BI Tools version 2.6.0.1000
Copyright (c) 2016 Dundas Data Visualization Inc. All rights reserved.

Type dt help  for command description.

Commands:
dt help               Type dt help  for command description.

dt createAppDb        Creates a new application database or initializes a previously-created empty application database.

dt createWarehouseDb  Creates a new data warehouse database or initializes an empty one created before.

dt scriptAppDb        Generates the application database creation script.

dt upgradeDatabases   Upgrades the application and warehouse databases.

dt resetAdminPassword Resets the password for the built-in administrator account.

dt setConfigValue     Sets the global value of a configuration setting.

dt healthCheck        Performs an application health check.

dt reviveApDb         Revives as application database containing only data.

dt connectionConfig   Encrypts or decrypts the connection information for the App DB stored in DundasBIConnection.config.


Each command has further help which you can view by typing: dt help <command>

For example, enter dt help setConfigValue to see the syntax for setting a configuration value.

C:\Program Files\Dundas Data Visualization Inc\Dundas BI\Instances\Instance1\tools>dt help setConfigValue
Dundas BI Tools version 2.6.0.1000
Copyright (c) 2016 Dundas Data Visualization Inc. All rights reserved.

Sets the global value of a configuration setting.

Syntax:
dt setConfigValue /appcs:<application connection string> /settingId:<setting ID> /value:<new value>

  <application connection string> - The application database connection string. The argument is mandatory.
  <setting ID> - The ID of the configuration setting to modify. The argument is mandatory.
  <new value> - The new value of the setting. The argument is mandatory.

Example:
dt setConfigValue /appcs:"Data Source=localhost; Initial Catalog=DundasApp; Integrated Security=True" /settingId:c6e739e5-a58a-49af-be1b-92b1f0fa62a2 /value:"abc"

3. Commands

3.1. resetAdminPassword

This command lets you reset the administrator password for Dundas BI.

For more details, see the article, How to reset the admin password.

3.2. setConfigValue

Use this command to set a configuration value.

For more details, see the article, Set a configuration value from the command line.

3.3. healthCheck

Perform a health check on the Dundas BI application and its databases with option to fix errors.

For more details, see the article, Perform a health check on the application.

3.4. connectionConfig

Encrypts or decrypts the connection information for the App DB stored in DundasBIConnection.config.

Examples:

  • To encrypt the application database connection string:

    dt connectionConfig encrypt

  • To decrypt the application database connection string:

    dt connectionConfig decrypt

4. See also

 

 

Dundas Data Visualization, Inc.
500-250 Ferrand Drive
Toronto, ON, Canada
M3C 3G8

North America: 1.800.463.1492
International: 1.416.467.5100

Dundas Support Hours: 7am-6pm, ET, Mon-Fri