Synchronize data between Postgres and Salesforce via Heroku Connect

Somtimes we need to built a Web App with standard open source stacks, like PHP, Node.js and Python,but manage and analytic data with Salesforce standard functions,like record CRUD,views and reports. Heroku Connect Heroku Connect provides us a pretty simple solution for this case, that using bi-directional synchronization between Salesforce and Heroku Postgres,whatever standard objects or custom objects. and the most important thing is, no coding or complex configuration is required.

Let me show you the usage of it.

Heroku Addons

New a Heroku app and add heroku-postgresql and herokuconnect to the app.

sfdc postgres · Resources   Heroku

Heroku Connect

Open Heroku Connect and Setup Connection. Heroku Connect 1 Heroku Connect 2 Heroku Connect 3 Create Mapping for data synchronization. Heroku Connect 4 Heroku Connect 5 Heroku Connect 6 Heroku Connect 7

Operation check

New an Account in Salesforce. Account Edit  New Account   Salesforce   Developer Edition Query account records in Postgres.

Query in Postgres It’s working!


The free plan of Heroku Connect has a limit of 10,000 rows under management regardless of the number of times those rows are changed.And If there are more than 10,000 rows,you need to contact Heroku Sales for purchasing.
※The price of SFDC is always an enigma. – -!

Related Post

Setup an awesome Salesforce developer environment ... Why Sublime Text 3 ? I've been working with for about 2 years, and always using IDE(See here, Eclipse IDE Installation)as my development environment. I don't think it is really difficult to use, but it could be more friendly. For example: 1. It doesn't suppo...
Using URL parameters on Salesforce standard pages Salesforce has many URL parameters can be used on its standard page, with this kind of parameters, you can do some URL hacking on it, as below: Note: All of parameters must be encoded with UTF-8. Login page There are two ways to login and access into Salesforce from url. 1. https://
Write Apex Test Classes efficiently with Tesforce 1.Why Tesforce The Test Classes are required to deploy Apex to a production environment or to be packaged and placed on AppExchange, it must provide at least 75% code coverage. That will be a huge workload to SFDC Developers if the project(application) include a lot of Apex Classes,the...
Salesforce Mass Editor (Chrome Extension) – ... This's my second Chrome Extension (First one is HERE) this year, named "Salesforce Mass Editor" and it supports for doing the below things : ・Makes any Salesforce list view to be a powerful mass editor. ・Mass insert, mass clone, mass update, mass delete, ALL-IN-ONE. ・Export record data to CSV fi...