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

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...
Build LINE Bot web application with Node.js and He... Overview In order to check the operation of the LINE Bot web application that using the LINE Messaging API, you need a server that can be accessed externally.This post shares the creation procedure of LineBot web application using Heroku. Basic flow 1. Heroku development environment For web onli...
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 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://