Guidelines for Integrating Database Event Management

New inserts can be queried to check a processed/sent flag in tables that indicate 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 Service Container, and use the following guidelines to integrate 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 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 starts again.

• Set up Service Container to reformat source data and send it to a target database.