Integrate

Register a Collect Download After Post Rule Manually

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 manually create a Collect Download After Post Rule 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 a 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. Enter the rule to run on target data after the table downloads in the Collect Target Where Clause field.

    NOTE: The Where clause selects records to delete from the target before the download.

    NOTE: The data returned from this Where clause is used as an input parameter to the next template in the process.

    NOTE: The Where clause must be syntactically correct.

  10. Enter the rule to run on source data after the table downloads in the Collect Source Where Clause field.

    NOTE: The Where clause must be syntactically correct.

    NOTE: The Where clause selects records to download from the source to the target.

    NOTE: The data returned from this Where clause is used as an input parameter to the next template in the process.

  11. Click Save.