Mediatek Inc. China

Mediatek Inc. China
GAVINHSU Member since 2011 24 posts
Mediatek Inc. China
Posted: March 6, 2019
Last activity: August 13, 2019
Posted: 6 Mar 2019 1:34 EST
Last activity: 13 Aug 2019 1:39 EDT

Is it possible to perform BIX update to target database

We're trying to use BIX for extracting PEGA data into external database for data analysis.

And we found that there will be exceptions when extracting same data into external database with primary key defined.

  • For example, we have created an external database table A with primary key.
  • When we first time ran exaction, it worked.
  • After while, the source data changed; so we want to extract the same record again into the external database.
  • We're getting "Duplicate entry 'BTR-1028' for key 'PRIMARY'" error

I understand we can remove the primary key definition to escape this error.

But this will make duplicated records existing in the external database.

Is there any way that the BIX perform update when record already existed?

Thanks very much.

***Edited by Moderator: Pallavi to update platform capability tags***

Pega Platform 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.