Defining Parameters

Use the Parameters tab to specify the list of parameters (filter) for the universal data adapter. The parameter definition includes a non-translated parameter name and a translated prompt. The prompt is used for display on the data rule page.

To add a parameter:

1. On the Setup tab, under Register, select Source Adapter.
2. Select the universal data adapter.
3. In the details section, select the Parameters tab.
4. From the Parameters task bar, select Add.

   Entry fields are displayed for the Parameter Name, Parameter Data Type, Condition, Column Name, Default Value, and Parameter Prompt.

5. In Parameter Name, enter the parameter name.

   For example, enter: p_actual_flag. This is the name of the parameter in the ODI project.

6. In Parameter Data Type, select the data type of the parameter

   Available data types:

   • Char

   • Number

   • Date

7. In Condition, specify the type of the parameter:

   • Explicit—You re prompted to provide an explicit value in the Data Rule, which is matched exactly in the source table to pull data.

   • Between—You are prompted to provide a between values in the Data Rule, and these range of values are matched in the source table to pull data.

     In—When this type is selected, you prompted to provide multiple values in Data Rule, and these values are matched in the source table to pull data.

   • Like—You are prompted to provide a string in the Data Rule. Values starting with the string are matched in the source table to pull data.

8. In Column Name, enter the column name to use as a filter.
9. In Default Value, enter the value to default on the Data Load Rule screen.

   When entering an "Explicit" value, use the 'X','XX,'XXX' format.

   When entering a "Between" value, use the ‘X’ and ‘XX’ format.

10. In Parameter Prompt, enter the label to display for the parameter on the Data Rule screen.

    When a new parameter is added and you are in a multi-language environment, then set the browser locale to the appropriate language and edit the prompts as needed in that language.

11. Click Save.
12. Click Generate Template Package.

This example shows a typical Structure of Fixed Asset Data Table:

In the data structure of the fixed asset table, you could add the yellow marked columns as parameters to use as a filter in data rules.

On the Source Adapter screen using the table above, you might create parameters as follows: