Skip to main content

This content is closed to future replies and is no longer being maintained or updated.
Links may no longer function. If you have a similar request, please write a new post.

Question

 Himanshu Upadhyaya (HIMANSHU-2)
Rabobank
Himanshu Upadhyaya
Rabobank
NL
HIMANSHU-2 Member since 2013 2 posts
Rabobank
Posted: Nov 13, 2020
Last activity: Nov 18, 2020
Posted: 13 Nov 2020 9:53 EST
Last activity: 18 Nov 2020 17:41 EST
Closed

Can BIX update the same record instead of inserting a new one ?

Hi,

There are some issues with BIX extraction in our application.

In case Pega inserts a new record then it is inserting more than one records for multiple assignments or in some cases multiple records are inserted even for a single update on the case.

So I wanted to know if there is a way to update the same record in the BIX table ?

***Edited by Moderator Marissa to update Content Type from Discussion to Question***
To see attachments, please log in.
Pega Platform
Case Management
Financial Services

Posted: 4 years ago
Posted: 18 Nov 2020 17:41 EST
Braam Smith (BraamSmithCLSA)
PEGA
Partner Success Tech Lead - APAC
Pegasystems Inc.
AU

I'm not sure if this answers your question, but BIX is an extraction tool and will always INSERT. It is the "Extract" component of an Extract-Transform-Load (ETL) sequence. 

The consumer of the records Extract'ed by BIX must determine how to Load each Extract'ed record into the destination system. For example, if the 'key' of the extracted record matches the 'key' of a record in the target table, the Load process might choose to UPDATE the record.

To see attachments, please log in.

Related content:

Related content has not currently been identified for this post.

We'd prefer it if you saw us at our best.

Pega Collaboration Center has detected you are using a browser which may prevent you from experiencing the site as intended. To improve your experience, please update your browser.

Close Deprecation Notice