Integrate

Register a Stored Procedure as an After Post Rule

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).

A stored procedure can be run as an After Post rule that may take a variable of @PostingID GUID. If this property exists, then the PostingID of the posting passes to the procedure. When a business rule After Post rule is encountered, Integrate runs the rule and waits for it to complete before running the next rule.

Before performing this task, a Template Administrator must create a category, create a template, and create a process. A stored procedure must be written and stored in a data source accessible to the Stewardship Tier.

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

To register a stored procedure 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 data source that stores the rule from the After Post Rule Data Source ID list box.

7. Select the rule from the After Post Rule list box.

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

8. Click Save.