Setting Up Heroku External Objects with Salesforce Connect

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.