Split Schema across multiple databases
We are in processes of implementation multiple applications in Pega.
We are exploring various options on how DEV environment should be setup, both form rules management perspective and performance.
One of the options was to have the RULES schema shared between applications and each application having their own DATA schmea.
One variation to this is to have RULES schema in its own database shared between applications and DATA schema within it's own database and each application having a separate database.
This model can be seen in the diagram below:
I wanted to know if Pega can be setup with separate with two separate JDBC data sources for each of the schema and if there are any do's and don'ts' with respect to this setup.