Hey all,

I am working on a web application for my work.  The business has decided on a roadmap to start porting functionality over from our application into Salesforce.  Here is what we are trying to accomplish:

1. We need users to interact with our web application from Salesforce.  Any changes made in Salesforce should be reflected in our application near real-time.
2. We need changes in our application to be reflected in Salesforce in near real-time.
3. In addition to just porting data between the two systems, we need to users to be able to perform actions from Salesforce that are currently built into our web application.

We have a few constraints:

1. The integration should be very fault-tolerant.  If our servers go down or Salesforce goes down, we need to be able to sync the two systems back to parity.
2. We need to be very efficient with our API requests.

So far, I have looked into the Streaming API as a way to pull in data from SF in near real-time.  I was thinking we could send updates from our application to Salesforce every 5 minutes or so using custom APEX endpoint.

Another option I looked into was building custom components that would call our API's and load the data in Salesforce via that route.

Any thoughts or ideas would be appreciated.