Question
Last activity: 21 Feb 2017 6:36 EST
How to send BLOB data directly to the consumers in excel sheet without using BIX extract.
How to send BLOB data directly to the consumers in excel sheet without using BIX extract.


Pegasystems Inc.
IN
Hello,
Thank you!
Can we do anything from the DB side without using Pega?
Regards,
Krishna!


Pegasystems Inc.
IN
or would creating a report definition be of quick use/help?
Quick question for understanding: The BLOB is a compressed Pega specific format of representing the data (in clipboard). It is essentially a byte stream that only Pega platform can make sense of. Please clarify why you would need that stream in Excel?
I believe you can use a UDF to read the values of a specific property from within the BLOB. Maybe then you could export the results of the query to xls or csv?
Note that UDF queries are extremely slow and can only work with scalar references. So if your BLOB contains a nested structure, then it would not be possible to get all entries. Example - page list property where the list may have different number of entries in each row.
Is there any pega libraries available or any other means to extract the BLOB into a readable format (could be XML) without using pega application. External teams have access to database so need to know how can they access BLOB content?
This comment has been branched out as a new node and the new thread can be followed here


Pegasystems Inc.
IN
Hi Naveen,
You have replied to an older thread which lacks activity. To gather better visibility for your question, I have branched it to a new question. You may continue your conversation on this thread: https://pdn.pega.com/community/product-support/question/there-any-pega-libraries-available-or-any-other-means-extract
Hope the information is helpful.
Thanks!
Hi Krishna, Good morning!
Please share your thoughts/comments, Thank you!
psahukaru