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***