
While sometimes unfortunate it is often necessary to have data silos that share data. The _Extract, Transform, and Load_ (ETL) pattern has been around for a long time to address this need and there are tons of solutions out there. If you just need a quick and easy way to copy new & updated records in Salesforce to an external data source, a simple Heroku app and Salesforce Workflow might be the quickest and easiest solution. I've put together a sample Node.js application for this: <a href="https://github.com/jamesward/salesforce-etl-mysql" target="_blank">https://github.com/jamesward/salesforce-etl-mysql</a>

Check out a demo:
<iframe width="853" height="480" src="https://www.youtube.com/embed/FYO1y9Kkx8o?rel=0" frameborder="0" allowfullscreen></iframe>  

This sample app uses a Salesforce Workflow that sends created and updated Contact records to an app on Heroku, which inserts or updates those records in a MySQL database. A simple [transform][1] JavaScript function makes it easy to customize this app for your own use case. To setup this app for your own uses, check out the instructions in the GitHub repo: <a href="https://github.com/jamesward/salesforce-etl-mysql" target="_blank">https://github.com/jamesward/salesforce-etl-mysql</a>

Let me know how it goes!

 [1]: https://github.com/jamesward/salesforce-etl-mysql/blob/master/server.js#L7-L13
