We are Archiving all the Resolved cases that are older than 6 months in to a Reports database(External db) on the daily basis and then purging all the cases from the PEGA database. we have a requirement to display these purged cases from the external db in UI and also have a requirement to open the case in review mode.
Here we are able to get the archived cases from external DB through RD by enableing "use alternative database" option. But not able to open the case from external DB (getting exception that not able to open the BLOB)
Is there any way to retrieve blob data from external DB, please guide us?
Thanks Khan for your quick response. I tried the JAVA step metioned above and it is working fine to read BLOB. But we need to prepare a clipboard page for respective BLOB, Is there any APIs to convert byte array into clipboard page. Do we need to decrypt it?