Help get this topic noticed by sharing it on Twitter, Facebook, or email.

Can I use DBAmp to synchronize data between SalesForce with our backoffice SQL Server database without additional code?

Hello, I want to set up synchronization of contacts, leads etc. between SalesForce and out back-office database.

I.e. if a contact changes in SF, I want the changes pushed to SQL Server and if a contact changes in SQL Server, I want those changes pushed to SalesForce.

I've been using a combination of the "Data Loader" app, and the SalesForce API (via custom code written in .Net).... but I want something more robust than this and I don't want to have to write me own synchronisation process :)

Hoping that DBAmp can help :)

Thanks,
Mark.
1 person has
this question
+1
Reply
  • There are 2 real issues with bi-synch integration and salesforce:

    1. Salesforce does not maintain a "per column" change log, only a "per row" timestamp. This means that at any one time we know the row changed but not what specific column changed.

    2. The same row could change on both salesforce.com and locally durning the same time interval. This fact coupled with item 1 above means there must be some "conflict resolution" code. How conflicts are handled is different from organization to organization. Therefore, there is always a requirement to "code" a conflict resolver for your business needs.

    DBAmp can provided robustness by moving your data loader app into our sf_bulkops stored proc. The .net code get replaced by a T-SQL script that handles the conflict resolution. It all can be scheduled using SQL jobs or SSIS.

    Hope this helps, let me know if you have further questions.
  • (some HTML allowed)
    How does this make you feel?
    Add Image
    I'm

    e.g. kidding, amused, unsure, silly happy, confident, thankful, excited indifferent, undecided, unconcerned sad, anxious, confused, frustrated