Question3Replies8442Views×Close popoverSahan Jayakody (SahanJay) virtusa virtusa LK View ProfileSend Message SahanJay Member since 2017 2 posts virtusa Posted: July 20, 2017Last activity: July 21, 2017Posted: 20 Jul 2017 0:54 EDTLast activity: 21 Jul 2017 8:39 EDT Closed Why Pega use BLOB?Hi all,Why Pega use BLOB data type?What are the advantages & disadvantages of it?and how can access the BLOB data externally?***Updated by moderator: Lochan to update Categories*** Data Integration ×Close popoverFacebookTwitterLinkedinEmail Copy Link Copied! Moderation Team has archived post This thread is closed to future replies. Content and links will no longer be updated. If you have the same/similar Question, please write a new Question. Posted: 3 years agoPosted: 20 Jul 2017 1:23 EDT×Close popoverChinmai Sravanthi Udayagiri (Chinmai_Sravanthi) PEGA Associate Technical Solutions Engineer Pegasystems Inc. IN View ProfileSend MessageChinmai_Sravanthi PEGA replied to SahanJayHi Sahan, For understanding of BLOB please check the below link: https://pdn.pega.com/understanding-pzpvstream-blob-database-column Please check the below link for understanding how to access the BLOB data externally: https://pdn.pega.com/community/product-support/question/read-data-blob-column-external-db Hope this helps. - Chinmai Sravanthi. Posted: 3 years agoPosted: 20 Jul 2017 1:29 EDT×Close popoverSahan Jayakody (SahanJay) virtusa virtusa LK View ProfileSend MessageSahanJay virtusa replied to Chinmai_SravanthiHi Chinmai, Can i know more about why pega use BLOB instead of other data types? except these 2 points. 1.They are compressed by PRPC for low storage overhead. 2.They can hold any amount of information since there are no physical limit constraints, such as maximum column lengths or page sizes. Posted: 3 years agoPosted: 20 Jul 2017 1:37 EDT×Close popoverSyl Schinco (SylSchinco_GCS) PEGA Technical Solutions Engineer Pegasystems Inc. US View ProfileSend MessageSylSchinco_GCS PEGA replied to SahanJayThere are a few ways to access the BLOB column of an object other than putting that object onto the clipboard: - The BIX tool can be used to extract data from a Pega database, and put it either in a prepared target table, or into a flat file. - The UDFs that are part of the installation (pr_read_from_stream) can be leveraged in a report definition. However, this creates performance overhead at the database level.