Last updated December 01, 2022

Each Heroku Connect add-on is configured to connect to a single Heroku Postgres database and a single Salesforce org. This article covers how to manage your sync and connections.

Configuring a Connection

See the Quick Start: Heroku Connect to configure your connection.

Pause a Connection

When performing certain tasks, such as upgrading your database, you can pause synchronization activity in Heroku Connect.

To pause synchronization:

1. Open the Heroku Connect dashboard.
2. Click the Settings tab.
3. Click Manage Connection.
4. Click the Pause button.

Heroku Connect completes any pending operations before entering the paused state. When paused, changes to data in the database are still added to the trigger log. There’s no polling for changes made in Salesforce. Push Topic notifications from Salesforce for mappings using the streaming mode are also ignored.

Resume a Connection

Any changes made to data in the Heroku Postgres database or in Salesforce while it was paused automatically syncs upon resuming the connection.

To resume synchronization:

1. Open the Heroku Connect dashboard.
2. Click the Settings tab.
3. Click Manage Connection.
4. Click Resume.

Heroku Connect continues where it left off by processing trigger log entries to push changes to Salesforce. It also retrieves changes made in Salesforce using polling, including mappings that normally use the Streaming API.

Recreating a Connection After a Sandbox Refresh

If you’ve reloaded a sandbox organization, you must delete your existing connection and recreate it.

The following settings are manually configured:

• Collaborators and their notifications settings
• Beta features
• The Write Algorithm
• The Salesforce API version

The rest of the recreation can be automated as follows:

1. Export your configuration from the Connect Dashboard. Click Settings, then click Import/Export Configuration, then click the Export Configuration button.
2. If you have any read/write mappings, make sure you aren’t writing any new data to those tables. Also, make sure all the mappings are in DATA_SYNCED to ensure all your data is present in Salesforce. You can click Settings, Manage Connection and click the Pause button to stop activity on the connection.
3. Destroy the Connection from the heroku CLI heroku addons:destroy -a appname herokuconnect-resource-name
4. Create a new connection from https://elements.heroku.com or heroku addons:create herokuconnect from the command line.
5. Authenticate your new connection, and import the config you exported from step 1.

Select the Write Algorithm For Your Connection

Select the algorithm Heroku Connect uses when writing data to Salesforce. The same algorithm is used for all read-write mappings. See Write Algorithms for more info.

1. Open the Heroku Connect dashboard.
2. Click the Settings tab.
3. Click Manage Connection.
4. Scroll down to the Write Algorithm section and select your choice.

Recover Synchronization After an Error

1. Open the Heroku Connect dashboard.
2. Click the Settings tab.
3. Click Manage Connection.
4. Click Recover From Error to clear out an unexpected error state and resume synchronization. See Heroku Connect Log Messages and Common Errors for more info.

Recover Synchronization After a Database Rollback

Heroku Connect uses a high-water mark methodology. Rolling back a synced Heroku Postgres database causes inconsistent data. Reload mappings after a database rollback to recover data consistency.

Changing Field Definitions in Salesforce

Heroku Connect doesn’t automatically change the table schema in PostgreSQL after you’ve changed the corresponding field definition in Salesforce. Attempts to automatically change the field can result in data loss or corruption. See Changing Field Definitions in Salesforce for more info.

Connection Configuration Audit Trail

Heroku Connect keeps a record of administrative changes to your connection’s configuration. Click Download Audit Trail to export to CSV. See Audit Messages for more info.