Can we store instances of a single casetype on to two database server
we have a requirement to store the instances of a single case type on to two different databases based on a condition. for example , users in location A need to store instances of case type X in database1 and users in location B need to store instances of case type x to database2. can this be achieved in pega?
***Edited by Moderator Marije to add Capability tags***
Pegasystems Inc.
GB
@SwethaG7 I don't believe that is possible. Note also the limitations on reporting as listed here.
"The sources for a report cannot span multiple databases. If a report definition presents data from multiple tables, all required tables must be in one database. This database can be either the PegaRULES database or a single reports database".
Could you please take a look at the answers in the following posts?
How to store instance of a Class in a specific Database Table
TATA Consultancy Services Ltd
IN
@SwethaG7 You can try the option of the declare trigger and writing logic in the trigger activity to save the data in the other database.