Question

1
Replies
49
Views
Abhishek Gubba (ABHI1230)
Cognizant

Cognizant
IN
ABHI1230 Member since 2013 19 posts
Cognizant
Posted: January 16, 2020
Last activity: 2 weeks 5 days ago
Posted: 16 Jan 2020 1:33 EST
Last activity: 2 Jun 2021 7:30 EDT
Closed

Filter criteria for BIX extract from pr_operators table

Team,

We have a requirement to extract pr_operators table to external database using BIX extract. The current criteria to extract the records is to check if pxupdatedatetime of operator record is greater than pxextractdatetime.

Issue: We are using a model operator to create operators in LDAP, which is saving all the operator records with same pxupdatedatetime of the model operator. The BIX extract job ran fine for the first time, however from the second run, above mentioned criteria was never matching and none of the new records are extracted.

Please suggest a solution here, so that any newly added or updated record in pr_operators table is properly extracted. We have tried to use existing properties like PXCOMMITDATETIME, PXSAVEDATETIME but none of them are returning right set of results.

The ask here is to only extract the delta between last and current run of BIX.

Thanks

***Edited by Moderator: Pooja Gadige to add product details tag, add platform capability tag***
Pega Platform Pega Business Intelligence Exchange Data Integration
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.