Question4Replies316Views×Close popoverBin Xu (GAVINHSU) Mediatek Inc. China Mediatek Inc. China CN View ProfileSend Message GAVINHSU Member since 2011 24 posts Mediatek Inc. China Posted: March 6, 2019Last activity: August 13, 2019Posted: 6 Mar 2019 1:34 ESTLast activity: 13 Aug 2019 1:39 EDT 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: 2 years agoPosted: 6 Mar 2019 4:09 EST×Close popoverSimon Chan (chans3) PEGA Principal GCS Solutions Engineer PEGA GB View ProfileSend Messagechans3 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: 2 years agoPosted: 6 Mar 2019 4:16 EST×Close popoverUday Kumar Reddy Teegala (teegu) PEGA Senior Technical Solutions Engineer Pegasystems Inc. IN View ProfileSend Messageteegu 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: 2 years agoPosted: 6 Mar 2019 4:17 EST×Close popoverUday Kumar Reddy Teegala (teegu) PEGA Senior Technical Solutions Engineer Pegasystems Inc. IN View ProfileSend Messageteegu 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 agoPosted: 13 Aug 2019 1:39 EDT×Close popoverGeorge Chen (GeorgeC1219) Envision Energy Envision Energy CN View ProfileSend MessageGeorgeC1219 Envision Energy replied to GAVINHSUGet the same case.