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).
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 platform.
Refer to Register After Post Rules to a Process Template Overview for general information.
To register a stored procedure After Post rule in Integrate:
- Select Categories in the Navigation pane.
- Click the Processes icon for a category.
- Click the Templates icon for a process.
-
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
-
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.
- Select the data source that stores the rule from the After Post Rule Data Source ID list box.
-
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.
- Click Save.
Was this article helpful?
Sorry about that.
Why wasn't this helpful? (check all that apply)
Thanks for your feedback.
Want to tell us more?
Send an email to our authors to leave your feedback.
Great!
Thanks for your feedback.