Question4Replies282Views GAVINHSU Member since 2011 19 posts Mediatek Inc. China Posted: 1 year agoLast activity: 1 year 1 month ago Closed Is it possible to perform BIX update to target databaseWe'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'" errorI 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 ×Close popoverFacebookTwitterLinkedinEmail Copy Link Copied! 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. Posted: 1 year agochans3 PEGA replied to GAVINHSUI am not aware that BIX has inbuilt functionality to check pre extracted record. However, I think you can simply overcome this issue with a database trigger to remove the old record once the new one has been inserted. Regards Simon Posted: 1 year agoteegu PEGA replied to GAVINHSUBix always inserts the records, if already exist than it will throw the error , if your getting the duplicate records than extract records which are in resolved status Posted: 1 year agoteegu PEGA replied to GAVINHSUplease check the bix design models in the below document https://community.pega.com/knowledgebase/articles/bix-design-models Posted: 1 year agoGeorgeC1219 Envision Energy replied to GAVINHSUGet the same case.