Heroku postgres Integration with Force.com

Login to www.heroku.com

Go to heroku Dashboard

Click ‘New’ to create Application

Create App

Enter App name: sfdc-heroku-integration

click ‘Create app’ button to continue


Click on App icon and select Elements

Select Heroku Postgres on the Heroku Elements page



Click on ‘Install Heroku Postgres’ and continue



Select your app name to install Postgres



select the free version and click on Provision button



You will landup on the below page after successfully installing Postgres on the Heroku platform



Installing Heroku Connect

Heroku connect  helps you to synchronize data to Salesforce



Select app name to install Heroku Connect, in our case app name is sfdc-heroku-integration



Click on Provision button to continue


After successful installation, you will be landed on to the below page


Configuring Heroku Connect to Sync data from Salesforce


Click on Heroku Connect from Dashboard->App->Resources section


Click ‘Setup Connection’


Enter schema name and click Next


Click ‘Authorize’ and continue


Select your Salesforce org to install, After successful installatoin, you will see below screen



Synchronize Salesforce object data into Heroku Postgres


Click ‘Create Mapping’


select Objects you want to synchronize


Select Object Fields you want to Synchronize, you can also set Poll Frequency ( minimum poll frequency set at 10 minutes )




After you complete the setup you will see below screen. We can clearly see number of fields, number of records that are inserted into Postgres DB

Leave a Reply

Your email address will not be published. Required fields are marked *