Issue
I need to connect two or more Heroku Connect add-ons to a single Salesforce Org, with the same mappings.
Resolution
You can set up multiple Heroku Connect connections to a single Salesforce Org, as long as each connection has a unique database schema. So app-a::DATABASE ::salesforce
, app-b::DATABASE ::salesforce
, app-a::DATABASE ::another-schema
are all fine but you couldn't have two connections in app-a::DATABASE ::salesforce
.
There should be no issues regarding performance with a setup like this, as long as you are not trying to sync two extremely large connections at the same time on a very frequent basis. Eg: if you had hundreds of millions of rows being updated millions of times per hour by both connections; this could cause performance issues.