Posted: 4 Mar 2019 16:31 EST Last activity: 6 Jun 2019 9:08 EDT
Multiple schemas affect Pega performance on Oracle DB
We are looking for direction on how to best integrate an existing external SQL database into the Pega environment. We are planning on migrating off the SQL server over to the existing Pega Oracle DB server. We are currently thinking of building a lightweight Pega app to access this data. We are concerned of possible performance degradation (this will be a production environment).
Would it be best to migrate this DB to a separate schema or integrate with existing Pega schema on the Oracle DB platform? Are there other options?
I would like your feedback on the pros/cons of doing each.
***Edited by Moderator Marissa to update platform capability tags; update SR Details****