Integrate

Register a Collect Download After Post Rule that is Built Automatically

When posting data to a target system, a Template Administrator can register an After Post Rule to a process template. The rule runs after the process template executes successfully and before the next process template begins processing (if posting with a multi-template process).

Before performing this task, a Template Administrator must create a category, create a template, and create a process. The target, source and tables must be registered in Collect.

A Collect Download rule downloads a Collect source - target - table registration.  When registering a Collect Download as an After Post Rule, the source, target, and table to download must be selected. Once selected, the source and target Where clauses can be manually entered or automatically built at run time.  

Refer to Register After Post Rules to a Process Template Overview for general information.

To automatically create a Collect Download After Post Rule at run time in Integrate:

  1. Select Categories in the Navigation pane.
  2. Click the Processes icon for a category.
  3. Click the Templates icon for a process.

  4. Click the After Post Rules icon for template ID.

    NOTE: If no After Post Rules have been added to the process template, Vertical View displays. If rules do exist, click Add on the Process Templates: After Post Rules page’s Horizontal View.

    View the field descriptions for the Process Templates: After Post Rules page

  5. Enter a number in the Priority field to set the order this After Post Rule runs if multiple After Post Rules exist.

    NOTE: Rules execute in ascending priority order.

  6. Select the source name to use for the Collect Download in the Collect Source list box.
  7. Select the target name to use for the Collect Download in the Collect Target list box.
  8. Select the name of the target or source table to download in the Collect Table Name list box.
  9. Click Save.
  10. Click the Collect Where Clause icon.

  11. Enter the column name that is evaluated by the Where clause in the Column Name field.

    NOTE: The column is stored in the table in the Collect Table Name field.

  12. Select the operator for the Where clause in the Operator list box.
  13. Enter the value to use in the Where clause in the Value field.
  14. Click Save.

At run time, the system automatically builds the Where clause.