This project populates a Heroku Postgres database with demo data. You can then use Heroku Connect to share this data via Heroku External Objects to Salesforce using Salesforce Connect.
- Click the following button to deploy your own clone of this demo.
-
After the app is deployed, click the Manage App button.
-
Click Heroku Connect, Setup Connection, select the existing Postgres database, click Next, then Skip the Authorization.
-
Inside Heroku Connect, click External Objects, Create Credentials, then select all the Data Sources.
-
Click Show Credentials, then use these credentials to setup Salesforce Connect.
To RESET the demo data, click the Open app button from your Heroku app and click RESET.
-
Make sure you have Node.js and the Heroku CLI installed.
-
Clone this repo...
$ git clone https://github.com/gabesumner/heroku-external-objects.git
$ cd heroku-external-objects
- Fetch the NPM libraries...
$ yarn install
- Create your Heroku resources...
$ heroku create
$ heroku addons:create heroku-postgresql:hobby-dev
$ heroku addons:create herokuconnect
- Setup an environment variable that points to your new Heroku Postgres database.
$ export DATABASE_URL=$(heroku config:get DATABASE_URL -a your-heroku-app-name)
- Run your app.
yarn watch
- Access the website from your web browser. Your Postgress database tables are now populated. Refer to the instructions above to setup Heroku Connect and Salesforce Connect.