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:

Question

BIX can do updates in same record instead of inserting duplicate record in table when same case/transaction updated.

Question

BIX - Not extracting records based on pxcreatedatetime from an external table

Question Solved

New line in BIX extract file

Question Solved

Obj-Save make an INSERT instead of an UPDATE

Question

Can BIX output CSV files be split based on number of records to avoid file IO issues ?

Discussion

How to insert default 0 values instead of null using BIX

Question

To insert a new record via Savable Data page saving only 1 record

Question Solved

Sending one email for all the records fetched using activity instead of sending one email for each record.

Question Solved

steps to use savable data pages to insert a new record in db

Question Solved

BIX Extract File name with date value in csv output format

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