Can you try below:

https://collaborate.pega.com/question/read-data-blob-column-external-db

Hello Vimal,

In Pega all the properties are stored in a blob (pzpvstream) . 

If you want to extract the contents of the properties from standalone application  you need to use BIX.

Bix is shipped by default in PRPC installation media (Additional Products-->BIX) where you have the user guide to start with .

Thanks,

 Arun

There is a UDF(pr_read_from_stream) for reading specific properties from pzPVStream, however if you intend on retrieving multiple properties this can become very costly.

In that instance, consider alternatives such as BIX.

Thanks mahesh86, as your answer helped me to decompress the the pzPVStream column. From the link you shared, it is evident that the pega uses the DeflaterOutputStream class of JDK to compress the data. So, I decompressed the data using the corresponding Inflater class of JDK.

Some additional details to consider if anyone wants to decompress the pzPVStream data using Java. The Inflater object should be created with nowrap argument set to true. The compressed bytes seem to start from the 11th byte of the pzPVStream blob. So, the Inflater object should be given input from the 11th byte of the blob bytes.

Also, BIX package also seem to be a viable solustion. Thanks for everyone who brought it up. But with my current requirements, I have to prefer a solution which does not use BIX package.

Regards,

Vimal