Can BIX perform an Update on an existing row while doing an extract?
Hello,
I have a Pega 7.1.9 application which I would like to use Bix to extract data for reporting. Currently, we are seeing Bix extract data for new cases, and cases that have been updated during the day. The problem is, that each time a case is updated and the Bix runs, a new row is added, instead of having the initial row for that Pega case record updated.
Is there a way to just update an existing row when a case is updated instead of adding a new row to the bix extract table?
Thanks,
Eric
***Updated by moderator: Lochan to add Categories***
Accepted Solution
Wells Fargo & Company
US
Hello,
After speaking with Pega support on this, it looks like there were plans to have this functionality in an upcoming release of Pega Bix, but it was determined that this would no longer be feasible due to the poor application performance. To accomplish what I am looking for we basically have to create a custom activity which would delete rows with the same pzInsKey value after the extract runs.
Pegasystems Inc.
IN
Hi,
As per my knowledge, the BIX will generate insert rather than update. So only a new record will get inserted each time you run BIX extract rule.
As an alternative, to achieve your requirement, you can apply filter condition on pxExtractDateTime column to fetch only those records with higher pxExtractDateTime and removing the duplicates based on pzInsKey.
Hope this helps.
Thanks,
Venkat
Wells Fargo & Company
US
Thanks for the reply Venkat. I was told by someone that there is a way to have bix update a row if the pzinskey already exists. If not, then insert a new row.
There may be a way to do this in an activity, but I wanted to make sure there was not something already out of the box that accomplishes this.
Eric
Accepted Solution
Wells Fargo & Company
US
Hello,
After speaking with Pega support on this, it looks like there were plans to have this functionality in an upcoming release of Pega Bix, but it was determined that this would no longer be feasible due to the poor application performance. To accomplish what I am looking for we basically have to create a custom activity which would delete rows with the same pzInsKey value after the extract runs.
Pegasystems Inc.
US
Hi Divya,
Per the reply above that has been marked as Correct Answer
"To accomplish what I am looking for we basically have to create a custom activity which would delete rows with the same pzInsKey value after the extract runs."
Does that help?