Connecting Salesforce to a Heroku Database

Sam Garforth

A popular use of Salesforce is as a front end system of engagement application, using a lookup integration to the more static system of record data in a back-end such as SAP. I wanted to set up a demo to show this but I didn’t have access to an SAP environment so I decided to simulate the back-end by creating a Postgres database in Heroku.

I decided to use some publicly available open data on properties as the database and for this to be looked up dynamically from the account record in Salesforce.

Here are the steps I went through.

First get a Heroku account. Go to and ‘sign up for free’


Then login.
On my computer I installed node.js from

And npm from

And the Heroku toolbelt from

Once installed, you can use the heroku command from your command shell. Log in using the email address and…

View original post 855 more words