Question3Replies7929Views SahanJay Member since 2017 2 posts virtusa Posted: 3 years agoLast activity: 3 years 2 months ago 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 agoChinmai_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-… Hope this helps. - Chinmai Sravanthi. Posted: 3 years agoSahanJay 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 agoSylSchinco_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.