Hi Nadar,

Can you tell us why do you want to read the blob column (pzPvStream) outside Pega? Can you elaborate on your requirement.

You can use BIX extract process if you are looking to extract particular properties from the blob column outside Pega.

I think we can also create a service layer which invokes pega activities using pzInsKey as param to get the blob data in XML format outside to Pega.

A couple of things to bear in mind:

• Pega reserve the right to modify the format of the blob without notification as it is considered a "Pega internal capability"
• the blob is held in a proprietary binary hash format which may also be encrypted
• you may fall foul of issues with backward-chaining declare expressions

I agree with @andrew and @harish on this. That said, if did want to look into getting some specific property value out of the BLOB, you can reference the UDFs, in your custom SQL outside of the platform, that are shipped with the product. Note that UDFs are used by report definitions to retrieve un-optimized property value from the BLOB.

I agree with the others and also recommend not using any technology outside of Pega to obtain data from the database;  (ie. you could create a custom activity or Report Definition combined with REST service to get the same data  and therefore using OOTB Pega functionality to get the data to meet your requirements). 

However, to get access to the BLOB in any language, you need to connect to the database and execute an SQL command.  If you look at a Pega Report Definition for an unoptimized property, you see will see that Pega generates the SQL to do that.  That SQL will give you the "trick" for crafting the SQL; 

Again, I don't condone it but I have to admit your requirement may require this solution;  of which, I would be interested to see what that requirement is.

Nothing is notified to me whenever a activity happens on my post, mesh.pega.com was good where i am notified about the activity on my post.

We are working on a client query, that whether we can read data from blob or not from the database without using pega