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

Batch Apex running mode (parallel and series) and ... In my early post, I’d shared about how to write a Schedulable Batch Apex in Salesforce, and I’ll show you how transactions run in batch Apex and how to maintain their state across these transactions in this post. Batch Apex running mode (parallel / series) As we know, each execution of a batch...
Using Custom Metadata Types and Custom Settings in... Custom Metadata is one of the new features that released at Summer'15 of Salesforce, which is customizable, deployable, packageable, and upgradeable application metadata, and it supports the following custom field types.   • Checkbox   • Date   • Date and Time  ...
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...
Setup an awesome Salesforce developer environment ... Why Sublime Text 3 ? I've been working with Force.com for about 2 years, and always using Eclipse+Force.com IDE(See here, Eclipse Force.com IDE Installation)as my development environment. I don't think it is difficult to use, but it could more friendly. For example: 1. It doesn't support APEX an...