Hello Manash,

Your query has been passed to our support team and someone will contact you presently. Just out of interest have you considered using an external CMIS (Content Management Information System) to store your case attachments outside of the PegaRULES database? CMIS connectors are supported with PRPC.

Regards,

Andrew Fontenelle

PDN Support

Hi,

Thanks for responding. I am using a very old version of PEGA (4.2) and I believe any new integration solution has not taken into consideration as we are currently working on the case data archival solution. This application is going to be decommissioned and the data is planned to be moved to the client's strategic archival data store which can only read XMLs. Coverting the case data is not an issue but the attachment data which incolves files will pose a problem and I am trying to chalk out a proposal on the feasibility of the approch.

Hi,

Thanks for providing more information. Your query has been passed to our Support Team and someone will be in touch with you.

Regards,

Andrew Fontenelle

PDN Support

Hi -

For 4.2, your best bet is to use an activity to open the cases and file attachments onto the clipboard, and then you can do what you wish with them: for attachments you could take the property containing the base64 encoded attachment and write it out to the target system using JDBC/SOAP/file system as required by your use case.

In other words, I would recommend using Pega platform rules to open up the records you wish to convert/move, and then process them accordingly, since they natively undestand the blob column format.

- Tim

Hi All,

I have similiar requirement. I am decoding the attachment stream from Data-Work-Attach, using Base64decode. Then sending to documentum as byte array. (Using Java code, since they dont support any other integration.).This works fine with pdf and txt. But word and excel documents throws error while I open it from the destincation location.

Any idea why this happens?

Thanks

Hi Manash

I am having a similar requirement, is there any solution handy?

Thanks !!