Question
Mindtree
IN
Last activity: 31 Jan 2017 7:24 EST
How to fetch BLOB data
i want to fetch BLOB data using SQL, can any one let me know..?
***Updated by moderator: Lochan to add Categories***
Accepted Solution
Pegasystems Inc.
US
Hello,
Why dont you use the OOTB Pega BIX functionality or Report Definitions(which uses UDFs internally to fetch the data from blob through PR_READ_FROMSTREAM) inorder to fetch the data from blob, any specific reason to use sql queries?
Note: Pega-BIX is very powerful functionality which allows us to read the blob data into three different forms i.e XML/CSV/Database table.
Regards,
Mahesh
IN
I beleive UDF would be a good option to acheive your requirement.
You may find some more details about UDF in below articles.
https://community.pega.com/sites/default/files/help_v722/procomhelpmain.htm mgmt/sm-command-line-arguments-ref.htm?Highlight=UDF
https://community.pega.com/support/support-articles/how-install-user-defined-functions-udfs
Pegasystems Inc.
IN
Hi Mare,
BIX will allow you to do this. Apart from that (or using PegaRULES itself), there is really no way to read directly from the BLOB.
When we read BLOB data It would be unobfuscated XML. The purpose of BIX is to make BLOB data more accessible outside of the PegaRULES engine.
Please note that there is a third possibility: PRPC has the ability to encrypt the BLOB by class. This is different from obfuscation. This would only be true, however, if:
1) The user had previously created a site-specific encryption cipher of their choice
2) Checked off "Encrypt BLOB" in the chosen class.
Regards,
Sudhish OP
Mindtree
IN
Thanks Mahesh, it was helpful.
As we are replicating the same data in an other db for that we are using the BLOB data.