PASSWORD tag

Creates a password input parameter for an analytic script. The parameter provides encrypted storage of a password for subsequent use in an ACLScript command.

The user is prompted to specify the required password value when they schedule or start the analytic script so that user intervention is not required as the analytic script is running.

Syntax

//PASSWORD identifier label
  <description>

Parameters

Name Description
identifier

The numerical identifier associated with the password. The value must be from 1 to 10.

label

In client applications, the interface label that users see when prompted to enter the password. For example, SAP Password:

description

optional

In client applications, descriptive text about the required password that users see. The description can help the user enter the correct password.

The description can be multiline, but it cannot skip lines. The description must be entered on the line below the associated PASSWORD tag.

Examples

Create a password input parameter for a Direct Link SAP query

The analytic header specifies a password input parameter that prompts the user to enter an SAP password. The stored password is used in the subsequent RETRIEVE command in the body of the script.

COMMENT
//ANALYTIC SAP Password Example
//PASSWORD 1 SAP Password:
//DATA RSADMIN
END
SET SAFETY OFF
RETRIEVE RSADMIN PASSWORD 1
OPEN RSADMIN
SET SAFETY ON

Note

The password input parameter and the password parameter in the RETRIEVE command are linked by using the same numerical identifier:

//PASSWORD 1 SAP Password:
.
.
.
RETRIEVE RSADMIN PASSWORD 1

Create a password input parameter for an export to Results

The analytic header specifies a password input parameter that prompts the user to enter a HighBond password. The stored password is used in the subsequent EXPORT command in the body of the script.

COMMENT
//ANALYTIC HighBond Password Example
//PASSWORD 3 HighBond Password:
END
SET SAFETY OFF
OPEN AR_Exceptions
EXPORT FIELDS No Due Date Ref Amount Type ACLGRC PASSWORD 3 TO "10926@us"
SET SAFETY ON

Remarks

Password storage and encryption

Password values are associated with individual users, and are encrypted at rest. Passwords remain secure throughout analytic script processing, and are encrypted in any temporary files created in the deployment environment.

Testing in Analytics

If you test an analytic script that has one or more PASSWORD tags in Analytics, Analytics automatically generates a PASSWORD command and prompts you to enter the appropriate password. This auto-generated command saves you the labor of inserting PASSWORD commands in the script portion of an analytic script for the purposes of testing, and then removing them again before delivering the analytic script to users.

The auto-generated PASSWORD command is saved in the log, without the password value.

Password values are not saved when you run an analytic script in Analytics, so you must specify the password or passwords each time you run the analytic script, including running or stepping through the analytic script from the cursor position.