Heroku Connect: The Definitive Guide

Are you only interested in syncing data between Postgres and Salesforce?

Are you comfortable with Salesforce, rather than your warehouse being the single source of truth?

The Alternative: Reverse ETL

Many of the above problems mentioned are completely eliminated with Reverse ETL. Unlike ELT, which focuses solely on extracting data from 3rd party sources, and loading/transforming data in the data warehouse, Reverse ETL specializes in copying data from the warehouse and syncing it back into the operational systems of business users (i.e. Salesforce, Hubspot, Marketo, Braze, Iterable, Google Ads, etc.)

Reverse ETL has a constantly expanding number of integrations. However, it is important to note that Reverse ETL is not bi-directional, data only flows from the warehouse. For data ingestion, many customers often turn to tools like Fivetran for analytical workloads and Reverse ETL for Data Activation. With Reverse ETL there is no replication, data is simply synced from the warehouse to the destination and this is where Hightouch comes into the picture.

Getting Started With Hightouch

Heroku Connect can cost more than $50k per year and that’s just for a single integration between Postgres and Salesforce. The first integration in Hightouch is completely free, so syncing data from Postgres to Salesforce would cost absolutely nothing.

With Hightouch, users can simply define the data in their warehouse by leveraging SQL or the existing data models in the warehouse or SQL. After this, it is really easy to map the appropriate columns and rows to the proper fields in the end destination.

To learn more download our Complete Guide to Reverse ETL.