+ Start a Discussion
melhedgesmelhedges 

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!
 
Thanks,
Melissa
qmanqman

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.

Bill

forceAmp.com

adamgadamg
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.
melhedgesmelhedges

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!

Melissa