Question
2
Replies
49
Views
Intellativ
Posted: June 17, 2020
Last activity: June 18, 2020
BIX extraction from tables with no pzpvstream
How to extract data using BIX from tables without pzpvstream(blob) column?
The old pdn link which has information about this is not working anymore
https://pdn.pega.com/community/pega-product-support/question/bix-extraction-table-no-pzpvstream
Hi Krishna,
The main purpose of BIX Extraction is to extract the data from the BLOB so that down stream systems can use the data for reporting purposes. If the table itself is not having any BLOB column then a report definition with required fields for the extraction can be created on the class which is mapped to the DB table and the data can be extracted in Excel format. This method can be followed if we want to send the data to external users who don't have Pega Access. If they have Pega Access then Report scheduling option can be used.
If you have a plan of pushing this data to external DB then this can be achieved by following the below procedure.
Some of the vital properties that BIX Extract looks in to while extracting the data from source table are pxCommitDateTime ,pzInsKey and pxObjClass as these properties are used in the Query that is formulated for data extraction. So if the table is having these columns then the data can be extracted easily by doing configuration in the below manner.
Steps to follow :
1. Create a class and a DB Table instance and map the class with the created DB Table instance. DB Table name should be same as the table name in the DB.
2. Now create the properties corresponding to the DB Table columns and map the properties to the relevant columns.
3.Now create an extract with the Applies to class as the above created class and configure the required properties.
4. For testing purpose you can configure the extract as CSV and save the extract.
5. Execute the Extract manually or by passing Extract Name and Extract Applies to Class to pxExtractWithArgs activity and run the activity.
File will be generated.
Regards,
Chaitanya.