Looking for a event based architecture which is monitoring a Database table
Hi,
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****