Parameter Files
A parameter file is a list of user-defined parameters and their associated values.
You can use user-defined parameters in data filters, expressions, and lookup expressions in the following tasks:
- •Data Synchronization tasks
- •Data Masking tasks
- •Mapping Configuration tasks
Use a parameter file to define values that you want to update without having to edit the task. For example, you might use a parameter for a sales quota that changes quarterly.
Save a parameter file local to the Secure Agent to run the task. The parameter values are applied when the task runs.
Parameter values are treated as String values. When you use a parameter in an expression, use the appropriate function to convert the value to the necessary datatype. For example, you might use the following expression to define a quarterly bonus for employees:
IIF((EMP_SALES < TO_INTEGER($$SalesQuota), 200, 0)
When you use a parameter in a data filter, start the data filter with the parameter. For example, use $$Sales < 100000 instead of 100000 > $$Sales.
To use a parameter file, perform the following steps:
- 1. Use the parameter in the task. You can use parameters in expressions and filters.
- - Use two dollar signs to name the parameter, as follows: $$<parameter>.
- - When you use the parameter in a filter, start the filter with the parameter.
- - When you use the parameter in an expression, convert the String parameter value to the appropriate datatype as necessary.
- 2. In the parameter file, define parameters as follows:
For example:
$$SalesQuota=1000
$$Region=NW
Note: The parameter value includes any characters after the equals sign (=), including leading or trailing spaces. Parameter names are case-sensitive.
- 3. Save the parameter file to a directory local to the Secure Agent to run the task.
Use the following directory:
<Secure Agent installation directory>/apps/Data_Integration_Server/data/userparameters
- 4. Enter the parameter file name on the Schedule and Advanced Options page of the task wizard.