By Louise de Leyritz from Castor (www.castordoc.com)
As companies engage in operational analytics, operational departments in companies are using data. For this reason, there is a need to distribute data from the warehouse to different cloud applications used by operational teams.
This explains the recent explosion in the past two years of Reverse ETL tools. (internal, open-source, and SaaS). This new trend is not going to stop, and we'd rather bring visibility and structure soon.
/w=3840,quality=90,fit=scale-down)
At CastorDoc, we believe the first step to structure the Reverse ETL tools market, is more transparency. For that reason, we put up a list of all the Reverse ETL tools we heard of.
This list is still exploratory, may contain errors, or lack information. Please reach out to us, if you notice anything wrong: louise@castordoc.com
Get started on Reverse ETL
In-depth analysis and evolution
Read the full breakdown by generation and market analysis of Reverse ETL here.
Deeper dive into Reverse ETL tools
‣
| Name | Website | Classification | Data sources | n° data sources | Segmentation | modeling | Integration with dbt | Custom API connector | Refresh frequency | Incremental updates | Integrations | Observability | Security |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Hightouch 🇺🇸 | Reverse ETL part of a larger offering | data warehousespreadsheetsdatabase | 11 | No-codeSQL | Yes | Near real timeEvents basedAPI | 60 | alert when sync failssync historical log | Data stays in your warehouse Version controlGDPR compliantHIPAA compliantSOC2 compliantCCPA compliantData governance | ||||
Census 🇺🇸 | Reverse ETL only | data warehousedatabase | 6 | SQLno-code coming soon | Yes | Near real timeEvents basedAPI | 43 | sync historical logalert when sync fails | Data stays in your warehouse GDPR compliantCCPA compliantVersion controlSOC2 compliant | ||||
Octolis 🇫🇷 | Reverse ETL only | data warehousespreadsheetsdatabase | No-codeSQL | Nocoming soon | 1 minAPINear real timeEvents based | 30 | alert when sync failssync historical log | GDPR compliantData stays in your warehouse | |||||
Grouparoo 🇺🇸 | Reverse ETL only | data warehousedatabasespreadsheetsCloud applications | 9 | SQL | No | Near real time | 18 | alert when sync failssync historical log | GDPR compliantData stays in your warehouse | ||||
Polytomic 🇺🇸 | Reverse ETL part of a larger offering | data warehousespreadsheetsdatabasehttp APICloud applications | 15 | No-codeSQL | Yes | Near real timeAPIEvents based | 22 | alert when sync failssync historical log | GDPR compliantSOC2 compliantData stays in your warehouse HIPAA compliantCCPA compliantPCI compliantOn-premise deployment available | ||||
Rudderstack 🇺🇸 | Reverse ETL part of a larger offering | data warehousespreadsheetsdatabaseCRM | 34 | SQL | No | Near real time | 84 | Data stays in your warehouse | |||||
Workato 🇺🇸 | Reverse ETL part of a larger offeringIpaas | data warehousedatabasespreadsheetsCloud applications | 600 | SQLNo-code | No | Near real time | 1000 | PCI compliantSOC2 compliant | |||||
Omnata 🇦🇺 | Reverse ETL part of a larger offeringEmerging solution | data warehouse | 1 | SQL | dbt packages | Near real timeEvents based | 3 | sync historical log | APPS compliantGDPR compliantData stays in your warehouse |
