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>

The entire flow consists of 2 phases:

• ETL (or ELT): ERP customer & invoicing data to the data warehouse
• Reverse ETL: customer & invoicing data from the data warehouse to the accounting software

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 via 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.

<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>

Install the Reverse ETL app

In Peliqan, go to the Build section (rocket icon in left).

Find the Reverse ETL app and click on Install Template.

Bookmark the app to your Peliqan homepage.