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!

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. – -!




Related Post

Using Promise for Apex Server-Side request in Ligh... In Lightning Components, each communication with Apex Server-Side is handled as a Javascript async request, and the callback you set is called after the server-side action is completed. A server-side action can return any JSON object, such as sObject or a map of name-value pairs. The followoing s...
Pipeline for Salesforce – Be less busy, less... Overview Pipeline is a metadata deploy app for Salesforce, supports: ・Making Changeset with Excel file in seconds. ・Exporting Pipeline target metadata list to Excel file. ・No dependencies on Salesforce Org, deploying metadata between any different organizations. ・Deploying metadata base o...
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. Support for both Classic and ...
Salesforce Smart Importer – 1-Drag to import... This is my third Chrome Extension named Salesforce Smart Importer (Other two popular extensions are Salesforce Mass Editor and Salesforce DevTools), it is designed for Salesforce not only admin but also normal user, supports : ・1-Drag to import any Excel / CSV data on anywhere in Salesforce, both ...