Introduction

Reverse ETL is the concept of writing data back into business applications, using the data warehouse as a source. This approach allows to use curated clean data from the data warehouse to keep data in business applications in sync. For example you could sync customers and invoices from your ERP to your accounting software (using the data warehouse as in-between).

<aside> <img src="attachment:80e7363b-d411-4bb2-ad18-c3f7174f555d:youtube.svg" alt="attachment:80e7363b-d411-4bb2-ad18-c3f7174f555d:youtube.svg" width="40px" />

Click here to watch a 7 minute how-to video on Reverse ETL in Peliqan

</aside>

Data flow overview

The entire data flow consists of 2 phases:

  1. ELT pipeline: Data is synced from the source into the Peliqan data warehouse
  2. Reverse ETL: Data from the data warehouse is written to a business application

reverse etl overview.png

Phase 1 is done by adding a connection in Peliqan to the source system. This will automatically set up an ELT pipeline and sync the data into the data warehouse.

Phase 2 is done by adding a connection in Peliqan to the target system and using the Peliqan Reverse ETL app. Install the app in your Peliqan account, configure the Reverse ETL flow and set a schedule on the app for ongoing syncs. All the steps of phase 2 are described below.

Reverse ETL app flow.png

<aside> ☝

You can also implement Custom Data Syncs (Custom Reverse ETL flows) in Peliqan using low-code Python scripts, based on one of the provided templates. For more information visit:

Custom data syncs

</aside>

Prerequisites