Regarding PEGA OOTB Purge and Archive process. Can we save Data into RDBMS instead of File Server?
Using OOTB Purge and Archive process, we can save data only in to a given repository as CSV files in an order. (Indexed order)
But if we need to save these set of data in to an another RDBMS - work tables and indexed tables, is there any OOTB functions/ wizard available?
If we implement this kind of function in our application, what would be the drawbacks?
Accepted Solution
Updated: 9 Jan 2025 11:08 EST
Pegasystems Inc.
US
@Dhanusha , your ask is not about case archival, but simple backup. There's no such functionality.
Why do you want to backup into another database/table? It won't lower your costs; and moving your older data into another database means you'd have performance problems accessing on the other database.
Case archival allows you to search, retrieve, and review inactive/older cases and all of their hierarchies and associated data. It does by lowering costs. Please go through documentation that @MarijeSchillern has shared.
Updated: 17 Oct 2024 9:51 EDT
Pegasystems Inc.
GB
@Dhanusha the main documentation is here:
The Case archiving and data expunging processes
Configuring the Case archiving process
We have a good support document here:
@Chetan.Chaudhari is there anything you can add here?
Accepted Solution
Updated: 9 Jan 2025 11:08 EST
Pegasystems Inc.
US
@Dhanusha , your ask is not about case archival, but simple backup. There's no such functionality.
Why do you want to backup into another database/table? It won't lower your costs; and moving your older data into another database means you'd have performance problems accessing on the other database.
Case archival allows you to search, retrieve, and review inactive/older cases and all of their hierarchies and associated data. It does by lowering costs. Please go through documentation that @MarijeSchillern has shared.