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

Display Address type field on Visualforce Page Address is an especial type of fields in Salesforce, which is a structured compound data type, that we can't use it directly on Visualforce page. And there will occure a compile error like "Unsupported type: common.api.soap.wsdl.Address used in expression: record.BillingAddress", if we did that. ...
Using HTML tag(e.g. line break) in Custom Label Custom Label is a really useful feature in Salesforce, not only can be edited after deployed, but also can be used for making an app multilingual with Translation Workbench. If you want to use HTML tag with it on Visualforce Page, e.g.
tag, the only thing you need to do is using an u...
Display DateTime with TimeZone in Visualforce Page In Salesforce,Date and Date/Time values are stored in GMT,and a GMT time will be outputed when we use apex:outputText tag. e.g. Result ※Time Zone : (GMT+09:00) Japan Standard Time (Asia/Tokyo) As we know,we can not determine a user’s time zone...
Use Salesforce Mini Page Layout in Visualforce Pag... Mini Page Layout is a nice feature of Salesforce,it can be maintained for every parent object in master-detail or lookup relationship in order to display additional record information without jumping to its detail page. Enable Mini Page Layout First,navigate to Customize > User Interface an...