Question
HSBC
IN
Last activity: 11 Mar 2024 10:02 EDT
Closing pega application and database.
Hi team,
We have a Pega application (7.4 ) and oracle DB 11gR2. The service is now not in use and we have to demise both the application and DB servers.
Now the requirement is we have to purge few years data and take data archival. since we are planning to demise the application,
1. Can we decrypt the blob data while archiving.
2. Can we retrieve the archived data without pega application.
Can you please suggest the right approach or alternate approach to execute this requirement.
***Edited by Moderator Rupashree S. to add Capability tags***
Accepted Solution
Updated: 11 Mar 2024 10:02 EDT
Pegasystems Inc.
GB
@SivaK17078241 To archive and purge data from your Pega application and Oracle DB, you can use Pega's built-in tools. However, decrypting blob data during archiving and retrieving archived data without the Pega application are complex tasks that may require specialized knowledge. I recommend consulting with a Pega expert or a database administrator who is familiar with Pega and Oracle DB. They can provide a more detailed and tailored approach based on your specific needs and constraints.
⚠ This is a GenAI-powered tool. All generated answers require validation against the provided references.
How to purge huge amount of data from pega work table?
Database archiving, purging, and data retention
We are planning to Migrate our DB from Oracle 12c to PostgreSQL on Pega 7.4
How to retrieve the data after Purge and archival process