Reverse ETL — A Primer.

medium.com

The category of reverse ETL, which empowers operational analytics, has been a good idea for a little while but has truly captured the zeitgeist in just the past six months or so. I wrote about it in my ecosystem post late last year and Astasia @ Redpoint dives in much more deeply in this post. She makes some fantastic delineations that I hadn't fully processed yet.

We’ve also heard customers consider Tray.io and Workato as alternatives to reverse ETL solutions. Tray.io and Workato are visual programming solutions to configure data pipelines while reverse ETL is declarative. They send all the data on every run rather than only sending differences from the last run. Reverse ETL solutions use batch APIs and handle only sending the rows that have changed.

This is the most complete description I've read yet on this important tooling category; highly recommended.

Read more...
Linkedin

Want to receive more content like this in your inbox?