Posted: 14 Mar 2019 22:41 EDT Last activity: 22 May 2020 15:38 EDT
Multiple data schemas support
We would like to understand how to configure multiple data schemas for same rules schema/PRPC installation. How do we segregate so we each application can have its own assign tables in its own data schema?
Kindly dont mark this post as duplicate, below are some of the references to previous posts which are not that directive. Thanks so much in advance !
Old pega v6 to v7 article which states having multiple data schemas is not possible, however wanted to understand if newer versions of pega allow it. Also let me know if such would not be supported in future, since multiple tenants infra is configured in OOTB tables in the data schema?
Still looking for answers on this. Our understanding is Pega can have one Data Schema (where the prother, prassign tables are mapped), however pc_work table can be independently mapped for various case types to various database instances.
Looking for direction/help to completely isolate data schemas.
We have two nodes (2 JVMs) configured on a single server. On cluster level we have defined Pega rules and customer schema and on the JVM level we have defined the data schema. So our one JVM (node) is pointing to A data schema and second JVM (node) is pointing to other B data schema. It is working fine without any issues.
Just make sure to do schema specific changes/development from particular node.