Question

4
Replies
282
Views
GAVINHSU Member since 2011 19 posts
Mediatek Inc. China
Posted: 1 year ago
Last activity: 1 year 1 month ago
Closed

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
Share this page LinkedIn