Abhinay Chilukoorie (AbhinayC)
Centene Corporation
Senior Software Engineer
Centene Corporation
AbhinayC Member since 2018 12 posts
Centene Corporation
Posted: August 29, 2019
Last activity: January 22, 2020
Posted: 29 Aug 2019 13:30 EDT
Last activity: 22 Jan 2020 1:57 EST

Using multiple external databases

Hello all,

We have a scenario where we have to store the data in different databases based on certain logic.

Example: If Country = USA, then all the data goes to one particular DB. If Country = India, then all the data goes to another database.

When a work object gets created, by default all the data (data on pyWorkPage and other embedded pages) will be stored in pega database.

My approach towards this is: Have multiple data classes (XYZ-Data-Usa, XYZ-Data-India) and set a value to property, (If country = USA, Set CountryClass = 'XYZ-Data-USA) and do a RDB-Save on the external database (INSERT INTO {Class:{.CountryClass}}.

So this way, all the metadata goes to pega DB but customer specific data can be segregated into separate DB's.

Would anyone please suggest if you see any downsides of this approach? Our key req was the customer data should be in separate DB's. (Country USA data can not co mingle with Country India data)

Thanks in advance

***Edited by Moderator Marissa to update platform capability tags****

Pega Platform Low-Code App Development Data Integration Cloud Services System Administration
Moderation Team has archived post, This thread is closed to future replies. Content and links will no longer be updated. If you have the same/similar Question, please write a new Question.