Currently I've designed an integration using a scheduled Batch Apex class and REST API callouts to sync certain Accounts and Contacts from one org to another org that represents the company's master data. In the receiving (master) org, I'm using a phonetic matching algorithm to see if the Account and Contact already exist. Depending on the match confidence the code may choose to use an existing Account and attach the Contact (or use an existing Contact). If the match confidence is too low for the Account, it will create the Account and the associated Contact. There's also some task creation logic depending on the match confidence for a rep to double check the created records for a duplicate.

My question is, what other options are out there that can automatically create records in another org with somewhat advanced duplication checking? I understand that there may be a number of paid tools out there to do this, but I'm looking to do the legwork myself here, as we're working with a limited budget.

Curious to know other's thoughts on what I've designed, any pitfalls I'm not seeing, or how you personally would accomplish it.


  • 1
    Is there a reason you can't use Duplicate Rules and the FindDuplicates class? – David Cheng Jul 16 '20 at 18:18
  • I actually explored that route before heading down the phonetic path. I never got it to work, as it began throwing an odd Oracle error that I couldn't find any answers for. I also think that part of the reason I forwent the built-in class was to control what happened based on the match confidence, and I couldn't figure out how I would extract that from the FindDuplicates results. Thanks for reminding me though! I should definitely explore this option again before committing fully to the custom matching logic. – 02384705287409872098374 Jul 16 '20 at 18:39

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.