MicroStrategy ONE

Encrypting a script

By default, Command Manager scripts are saved in plain text format. This can be a security risk if your script requires a username and password, such as any script that connects to an Intelligence Server. You can avoid this security risk by saving these scripts in an encrypted format.

If you create a batch file to execute a Command Manager script from the command line, the password for the project source or Narrowcast server login must be stored in plain text in the batch file. This creates a security risk, since anyone who can view the batch file has access to a MicroStrategy administrator login and password.

You can protect the security of this information by having the script connect to a project source or Narrowcast Server when it is executed, using the CONNECT SERVER statement. You can then execute the script from a connection-less session, which does not require a user name or password. The user name and password are provided in the Command Manager script, as part of the CONNECT SERVER statement.

When you encrypt a script, you specify a password for the script. This password is required to open the script, either in the Command Manager graphical interface, or using the LOADFILE command in the Command Manager command line interface. Since a script must be opened before it can be executed in the Command Manager graphical interface, the password is required to execute the script from the graphical interface as well. However, the password is not required to execute the script from the command line or through the text-based interface.

The password for an encrypted script cannot be blank. In addition, it cannot contain any spaces, and is case-sensitive.

To encrypt a script

  1. Select the script's tab in its Script window.

  2. From the File menu, choose Save As Encrypted File. The Save dialog box opens.

  3. Navigate to the directory in which you wish to save the script, enter a name for it, and click Save.  A password dialog box opens.

  4. Type the password for the file in the Password and Confirm Passwordfields and click OK. The script is encrypted and saved.

Related Topics

Saving one or more scripts

Executing a script from the command line