Close popover
shiva naralasetti (shivan08) Inc Inc
shivan08 Member since 2018 5 posts Inc
Posted: January 8, 2019
Last activity: January 15, 2019

Looking for a event based architecture which is monitoring a Database table


My application has lot of business logic into database procedures. This is due to the integration with upstream systems. We get a file feed from upstream systems and we insert it into staging table and call a procedure and it in turn loads the data from staging table to main tables. This data includes few customer attributes which should trigger a sequence of updates. We currently doing this in the procedure itself.

I also have similar requirements which require event framework which monitors a table. So to raise the event, i will insert a record into the "EVENTS" table with necessary data of the event. I should have " EVENT HANDLERS" monitoring that table and should dispatch the event to 'EVENT PROCESSORS" which are actually processes the event.

Pega Standard agents follow the similar framework however we can not create the queue records from database. If we can achieve this then i can use Standard agent framework for my scenario.

Did anyone try custom event architecture in Pega using database external tables?

Appreciate your help on this.

Pega Version: 7.1.8

DB: Postgresql 9.6

***Edited by Moderator Marissa to update platform capability tags****

Low-Code App Development Data Integration
Moderation Team has archived post,
Close popover This thread is closed to future replies. Content and links will no longer be updated. If you have the same/similar Question, please write a new Question.