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?

@Dhanusha the main documentation is here:

The Case archiving and data expunging processes

Configuring the Case archiving process

Enabling the archival process

We have a good support document here:

Implementing high performance and more resilient case archival method – InMemory Pipeline archival [SDR-B32]

@Chetan.Chaudhari is there anything you can add here?

@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.