Guidelines for Integrating Database Event Management

A business process can be designed to poll the source database looking for insert entries. New inserts can be queried to check a processed/sent flag in tables that indicate that the record is new, ensuring that only new inserts are returned. Each record must be processed individually and sent to the target database.

To poll the database, use Unwired Orchestrator, and observe the following guidelines when integrating the handling of database events in a business process service:

Start the polling by putting a dummy message on the queue
Repeat the polling periodically.
Use nested loops to process multiple sets of data inside a polling loop.
Design the business process service to manage errors that occur and handle multiple rows of data.
Add an activity to the business process to stop the polling and the business process. If you stop the runtime instance, the business process stops. It resumes where it left off when the runtime instance is started again.
Set up Unwired Orchestrator to reformat source data and send it to a target database.