Variable form

All variables used in transformations and job fields require entries in the UDM:Variable regular form. The variables allow sets of common variable values to be substituted and used when executing transformations and jobs. Variables are permission-based and substituted at runtime, during the execution.

UDM:Variable form

This form contains these fields:

• Variable ID—The ID assigned to the variable when it is created.
• Created By—The name of the user who created the variable.
• Name—The name of the variable name.
• Variable Set Name—Name for a variable set. A variable set can contain multiple variables that are designed to work together. You need to provide this variable set name when creating an execution instance using the UDM:Execution form. The ARDBC plug-in takes all the variable names and values for the provided variable set name from this form and passes it to a transformation or job execution instance on the Atrium Integrator engine server. See "Variable sets" below.
• Value—The value of the variable.
• Encrypted Value—An optional encrypted value for the variable. See "Encrypted variables" below.
• Assignee Group Permissions—The assigned permission or role required to use the variable.

Variable sets

A variable set is a group of variables with a unique variable set name associated with a specific job or transformation. Each variable must be associated with a variable set. Variables defined by the current user take precedence if more than one variable with the same name is part of the same variable set.

Encrypted variables

Variable values may be encrypted. If a value has been assigned in both plain text and encrypted fields, the encrypted value takes precedence over the plain text value. All variable values, such as a database password, should be encrypted.