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***
@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?