Question
WellCare
US
Last activity: 26 Apr 2019 10:01 EDT
Adding an Archive Schema
Hi Team,
We are working on a POC and we wanted to know what are the necessary steps to add one more schema to the default admin,data,rules schemas. We want to add an archive schema, and use the OOTB Archive/Purge functionality to archive from the data schema into the archive schema and maintain the same rules schemas.
***Edited by Moderator Marissa to update platform capability tags****
Unitedhealth Group
US
Hi Fabian,
Hope you are doing good. You just have to create a new database instance to map it to to the new schema and also the account id used to access the rules and data schema should also have necessary privileges to that archive schema. Let me know if you have any further questions.
WellCare
US
Hi Srinivas,
Yes, one more question. We are using Oracle, so what you are suggesting is to have something like this:
DB1
-----------
PEGA_DATA
PEGA_RULES
PEGA_ADMIN
DB2
-----------
PEGA_ARCHIVE
PEGA_ADMIN
Or do we have to add the other pega_rules.
We are trying to use the OOTB functionality for the Purge/Archive, and wondering if this approach will work.