Closed
Detect a DB Table Update or Change and use as Trigger
I would like to trigger an activity when an external database table is updated. Any ideas on how to accomplish this?
As of now, my solution is to have an agent scheduled to run once per day but it would be really powerful to trigger based on detection of a table change rather than a schedule.
Posted: 6 years ago
PEGA
Pegasystems Inc.
US
A Declare trigger rule does exactly this (call an activity on database update), however the update must be originated by Pega for this to trigger. You need to provide more details for your use case to obtain a suitable solution.
Posted: 6 years ago
ING
ING
NL
I think you can implement DB trigger on external DB side. That trigger should populate queue. You can implement your own queue or try to use some common used queue like JMS. Inside pega you will have advanced agent that check this queue and set queue item to handle for another Standard agent. Think such approach will be most safe.
To see attachments, please log in.