Setting Up Heroku External Objects with Salesforce Connect

Integrate data from a Heroku Postgres database into Salesforce by using Heroku External Objects and Salesforce Connect. While the data remains in Heroku Postgres, this integration allows the data to be read from within Salesforce. Also, the data can often be written to within Salesforce.

Required Editions

Available in: all editions

User Permissions Needed
To set up Heroku External Objects:	ModifyAllData and PrivacyCenter
To connect External Objects to your Salesforce org:	ModifyAllData and PrivacyCenter
To relate External Objects using External IDs:	ModifyAllData and PrivacyCenter

Salesforce Connect makes it easy to integrate data stored outside your Salesforce org into the Lightning Platform. External objects are available to Salesforce tools, such as global search, lookup relationships, record feeds, and the Salesforce mobile app. Heroku External Objects is a Heroku Connect feature that provides an OData wrapper for a Heroku Postgres database configured for use with Heroku Connect. This configuration allows other web services to retrieve data from the specified Heroku Postgres database using RESTful endpoints generated by the wrapper. When used together, data in a Heroku Postgres database is represented in a Salesforce deployment, where it can be viewed, searched, and related to other objects.

For more information, read Heroku External Objects with Salesforce Connect in the Heroku Dev Center.

Set Up Heroku External Objects
Provision Heroku Connect, create OData service login credentials, and choose the tables and views you want to expose.
Connect External Objects to Your Salesforce Org
Set up the OData service as an External Data Source, and customize object tabs and External Object layouts.
Relate External Objects Using External IDs
Use external IDs to associate records in Salesforce with their corresponding records in Heroku Postgres.