Posted: 21 Dec 2020 1:10 EST Last activity: 27 Dec 2020 11:18 EST
Pega BIX -How to get incremental data in BIX Extract without pr_extract_time table in Source DB
Hi all I have a requirement to extract only delta data from a production backup database. So initial extract works fine however, after every nightly backup, the table pr_extract_time which has the pxLastUpdateTime column is overwritten.
Is there a way to get Delta updates without having this table in source Database?
***Edited by Moderator: Pooja Gadige to add product details tag, add platform capability tags***
When Pega runs the BIX extract rules for the first time it extracts all records for the cases types you have selected. On the second run it will check for the last run date time, and only extract records which were modified after the last extraction date time. After extraction rule is run it will set the new date time as last extraction date time for next run. This is how BIX works
Pega uses pr_extract_time for it's own understanding to track when the last time the extract rule was run and logs all the extraction related details here
In the extract rule itself you can go to the Filter criteria tab and Select the Use Last Updated Time as Start check box to extract all data that was created or updated since the last time the Extract rule was run. This field is not relevant until the Extract rule has run at least once.