function readOnly(count){ }
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
+ Start a Discussion

Website Integration -- Insert directly into SFDC or Replicated Database?

Hi There!
I am undertaking a web overhaul and will be integrating the website with SFDC. I am currently integrating directly with SFDC via the API in real-time; however, some developers have recommended replicating the database and then doing a nightly data dump into SFDC. Can anyone offer a compelling reason to choose one over the other?
I appreciate any insight into this matter!

With real-time integrations, if salesforce goes down your website workflow is halted as well.

By using replication and uploading, you are using locals tables as a 'queue' and that could make the overall website more resilient to salesforce hiccups.

We have a lot of customers who have done just that with DBAmp. Let me know if you need more details.


For reads of infrequently changing data, I'd recommend an in memory cache or local db; for writes I'd go directly via the API.

Thanks for the information, Bill. I am researching my options now, but leaning towards the DbAmp pro option, as you mentioned. I will probably be talking to you in more detail soon!