Creating cases from SQL integration
Hello
I have a requirement for our Pega Case Management tool to create cases based on new items in a SQL table.
We have a SQL table that records all the new requests from users, which ultimately need to be created in Pega as new cases. We are looking to establish an upstream integration with that SQL table, and have functionality to create new cases in Pega based on new records in that table.
Any advice would be greatly appreciated.
Thanks
Yes, the data is in an external database that gets updated via a nightly ETL process. We would then need to take the net new records in the DB and create cases for them in PEGA.
Hi Chris,
The best way I could think is to have an agent to query the table on periodic basis and then create case based on the values.
Regards,
Ujjwal
Could you please tell me where are you maintaining the table like is it a external DB table.?