Is there a use case for a Salesforce-Postgres realtime bi-directional
synchronization tool? Is this something companies using Salesforce
would spend money on?<p>Tools such as Heroku Connect[1] or Skyvia[2] provide this functionality but are
they being utilized?<p>I was involved in a project that rebuilt Heroku Connect as a standalone tool.
Part of our reasoning for doing this:<p>- Centralizing the update logic for external services into Salesforce,
- Having a better (i.e. SQL) method of querying Salesforce data,
- Saving costs on additional Salesforce seats as employees used external tooling instead, and
- Heroku Connect was found to be prohibitively extensive for our requirements.<p>This was a Ruby/Rails shop so all updates went via ActiveRecord into
Postgres and then, via our tool, into Salesforce. Changes in Salesforce
triggered our tool to retrieved those changes and make the corresponding
updates in Postgres.<p>Financially the company has offset the cost of maintenance against the
savings made by not having extra Salesforce seats and not paying for Heroku
Connect.<p>Salesforce, of course, does not encourage this type of workflow (perhaps also the
reason why Heroku Connect is so expensive - Heroku being owned by Salesforce)
however it remains possible.<p>[1] https://www.heroku.com/connect
[2] https://skyvia.com/data-integration/integrate-salesforce-postgresql
When Heroku Connect came out, I thought it was really cool and tried to play with it. After I concepted a hobby project for it, I looked at the data/pricing requirements and ran away screaming. (iirc, 5k total data rows across the whole DB then you had to start paying)<p>This was a while ago, so perhaps the limits have gotten less onerous.