Editing Application Options

You can specify additional application to return only records that meet selected conditions when using on-premises database sources. You can specify a single filter condition or multiple conditions, and specify the exact values to return.

To apply additional application options for an on-premises data source:

1. From the Data Integration home page, and then from the Actions menu, then from the Setup actions drop-down, select Applications.

2. On the Application page, click next to on-premise data source application.

3. Select the on-premises data source and click Edit Options.

4. On the Edit Options page, click Add.

   Blank entry fields display.

5. In Name, enter the name of the filter.

   For example, enter Location or Period.

   The name you enter is a bind variable or a placeholder for actual values in the SQL statement. In the SQL query, bind variables must be enclosed in ~~ characters. For example, to use "Period" as a bind variable, specify: ~PERIOD~. The name must exactly match the name specified in the SQL query.

6. In Display Prompt, specify the name of the display prompt for the filter on the Edit Integration page in Data Integration.

7. In Display Order, specify the display order of the filter on the Edit Integration page.

   If this field is blank, the custom filter cannot be displayed, and the default value is used as the filter value.

   For example, enter 99 to show the filter in the 99th position sequence or position in a list of filters. Display orders are listed from lowest to highest.

8. In Property Level, select the type of process at which the filter is displayed.

   Available options:

   • Application
   • Application and Integration
   • Integration

9. In Validation Type, to provide a drop-down of values listed using the lookup type, in Validation Type, select one of the following:

   • None
   • Number
   • Lookup Validate
   • Lookup No Validate
   • Yes/No
   • Date
   • Query
   • Choice list— You can enter a list of values in the Validation Object field. Each value is entered on a new line. The list of values (LOV) on the Option page shows the values as a list.

10. In Validation Object, enter a list of lookup objects to be validated by type.

    To enter a list of values if you chose the Choice list validation type above, click , then enter the list of values on the Validation Object page, and then click OK.

11. Click OK.

    The following graphic shows how you might set up Period and Location application filters Data Integration:

    

    The following page shows how Period and Location filters are rendered on the Edit Integration page in Data Integration.