When bi-directional (“read-write”) sync is configured, Heroku Connect writes changes to Salesforce using SOAP or Bulk API. If you have multiple connections, be sure to mention them so that they can enable the setting for each one. If you’d like to enable your default assignment rules for Leads and Cases, create a support ticket. This single process for writes runs independently and concurrently with reads from Salesforce for mapped objects.īy default, when Heroku Connect writes data to Salesforce, assignment rules aren’t run. It sends changes to Salesforce using the SOAP or Bulk API, depending on your write algorithm and other requirements. Heroku Connect processes all captured changes in a single process per add-on. See The Heroku Connect Trigger Log for more info. All read-write data tables share a single _trigger_log table per Heroku Connect add-on. When a read-write table updates, a Postgres trigger fires and captures the change by inserting it into the _trigger_log ( trigger log) table. Heroku Connect captures changes made in Heroku Postgres on read-write mappings and sends them to Salesforce. There’s no mechanism to prioritize a set of writes over any other set. Additionally, it executes write operations across all mappings in order in serial. Heroku Connect doesn’t poll for additional database updates while a write operation to Salesforce is underway. When a set of writes completes, a new poll cycle starts and wait either two minutes or for a new change event from pg_notify. When Connect polls the database and finds changes it begins to write changes back to Salesforce. These polls are limited to at most every 10 seconds.
Heroku Connect polls your Heroku Postgres database for updates every two minutes, unless it detects an update from a pg_notify trigger. This article covers how Heroku Connect writes data from Postgres to Salesforce. It employs best practices that take data change volume and the details of Salesforce API operation into account. Heroku Connect automatically chooses the most efficient method to transfer data between your database and your Salesforce org. Diagnosing Perceived Performance Problems.Why Does My Postgres Data Not Match Salesforce?.Using Custom Triggers with Heroku Connect.Importing Large Quantities of Data Into Read/Write Mappings.