Synchronize data between Postgres and Salesforce via Heroku Connect
- Dec
- 22
- Posted by Lin
- Posted in Heroku, Other, Salesforce
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 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.
Create Mapping for data synchronization.
Query account records in Postgres.
It’s working!
※The price of SFDC is always an enigma. – -!

Let me show you the usage of it.
Heroku Addons
New a Heroku app and add heroku-postgresql and herokuconnect to the app.
Heroku Connect
Open Heroku Connect and Setup Connection.






Operation check
New an Account in Salesforce.

Notes
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. – -!
Recent Posts
- Salesforce DevTools Release Notes (version 3.10.0) – mass edit custom fields on lightning
- Salesforce DevTools Release Notes (version 3.9.0) – Object Fields, SOQL Query Editor
- Salesforce DevTools Release Notes (version 3.8.0)
- Salesforce DevTools JUST HIT 10,000 USERS! THANK YOU!
- Using Promise for Apex Server-Side request in Lightning Component
Top Posts
- Salesforce DevTools – Powerful Salesforce developer tools, loved by over 50K developers - 226.8K views
- Date format and DateTime format - 209.9K views
- Salesforce Mass Editor (Chrome Extension) – Mass create, mass update, mass clone, mass delete on any list view. Support for both Classic and Lightning! - 161.1K views
- Writing a Schedulable Batch Apex in Salesforce - 124.9K views
- Setup an awesome Salesforce developer environment with Sublime Text 3 - 123.1K views
Categories
- APEX
- Apps
- Custom Label
- Custom Metadata
- Custom Setting
- Design & UI
- Event
- Heroku
- iOS & Object-c
- Lightnint Component
- Linux & Mac OS
- Metadata API
- Node.js
- Open Source
- Other
- PHP Framework
- Release Notes
- REST API
- Salesforce
- Salesforce DevTools
- Salesforce DX
- SOQL
- Tooling API
- Unit Tests
- Validation Rule
- Visualforce
- WordPress
You must be logged in to post a comment.