ETL vs ELT vs reverse ETL vs CDC: the data-movement map
Of the four tools in the ELT row, three bill by rows or events and Airbyte bills by credits.
Fivetran counts monthly active rows, Stitch rows and Hevo events, while Airbyte sells credits. Fivetran pricingStitch pricingHevo pricingAirbyte pricing
Abstract
This guide separates four data-movement terms that vendors blur: ETL, ELT, reverse ETL and change data capture. It maps each by direction of flow, where transformation runs, latency and fit, then names sourced tools and what they charge. It also shows how the four sit together in one stack.
Which one should you start with?
Reverse ETL is the one route out of the warehouse.
Start with ELT unless you have a hard reason not to.
This figure in words
- ETL runs from sources to target, through a processing engine, and transforms the data before load, inside the engine.
- ELT, the green route, runs from sources to warehouse and transforms after load, inside the warehouse, often with dbt.
- CDC runs from the source database log to a target or stream, carrying row changes continuously, deletes included. AWS DMS pricingdebezium.ioestuary.dev It usually does no transformation in flight and leaves that to be done downstream.
- Reverse ETL is the only route out of the warehouse, running from warehouse to SaaS and operational apps on a schedule. Hightouch pricingFivetran pricing The data is transformed in the warehouse beforehand, with light field mapping at sync.
Routes show the direction of flow and where transformation happens, so the map table below leaves both out. Roles are Atlas's reading. No vendor publishes a latency figure, so none is drawn.
It loads raw data into a warehouse first and transforms it there with SQL, so reruns are cheap and history is kept.
Use CDC when the source is a transactional database and freshness matters, and ETL when data must be filtered or masked before it reaches the target. Use reverse ETL when the data you need is already modelled in the warehouse and the people who need it work in other apps.
The four terms describe four different jobs, and a stack often runs two or three of them at once.
Key figures
Monthly active rows a month, free
- Paid connections
- $5 base charge each, 1 to 1M MAR
- Connectors
- 700+ on Standard
Airbyte Cloud, credit-based
- Pro, Enterprise Flex
- custom quote
- Syncs
- hourly on Standard
Plus $100 a month per connector
- Free tier
- 10 GB a month, 2 connectors
- Log-based CDC
- in all three plans
Per seat per month
- Owner
- Fivetran, since dbt Labs joined it
- Meter
- seats
The map in one table
Since the figure above draws direction and the transformation point, this table keeps to when you'd use each one as well as when you shouldn't.
| Approach | Typical latency | Use it when | Wrong choice when | Example tools |
|---|---|---|---|---|
| ETL | Scheduled batch | Data must be cleaned, masked or reshaped before it lands | You want raw data kept for later reanalysis | Informatica, Informatica pricing Talend (Qlik), Qlik Talend pricing Matillion matillion.com |
| ELT | Scheduled batch to frequent micro-batch | The warehouse is your compute and you want raw history | Regulated fields cannot land unmasked | Fivetran, Fivetran pricing Airbyte, Airbyte pricing Stitch, Stitch pricing Hevo, Hevo pricing dbt for the transform step dbt pricing |
| Reverse ETL | Scheduled batch | Sales or marketing need modelled data inside a CRM or ad tool | You need an app to react in the moment, or the warehouse data is stale | Hightouch, Hightouch pricing Fivetran Activations, formerly Census Fivetran pressFivetran pricing |
| CDC | Continuous, near real time | You must replicate row changes, including deletes, without querying the source heavily | The source exposes no log, or a nightly copy of a small table is enough | Debezium, debezium.io Estuary, estuary.dev AWS DMS, AWS DMS pricing Striim striim.com |
Vendors don't always use the same labels, so judge a tool by what it does with the data rather than by the label on its page. Hevo calls itself an ETL platform, hevodata.com Airbyte says it runs ELT pipelines, airbyte.com and Estuary claims CDC, ETL and streaming at once. estuary.dev
How the four combine in one stack
Three of the four stages can now sit on one Fivetran contract.
Batches every 15 minutes on Fivetran Standard and a continuous CDC stream land in the same raw layer. Fivetran pricingestuary.dev Fivetran and dbt Labs operate as one company, and Census now sells as Fivetran Activations. dbt pricingFivetran pricing
This figure in words
- Most tables arrive through an ELT loader as scheduled extracts, every 15 minutes on Fivetran Standard, billed by monthly active rows. Fivetran pricing
- The few tables that must be fresh stream continuously through log-based CDC, and both land in the same warehouse raw layer. estuary.devstriim.comdebezium.io
- From there SQL transformation in dbt builds the warehouse models, billed by seats. dbt pricing
- Reverse ETL, here Activations, formerly Census, then copies the models to business apps on a schedule, billed by MAR. Fivetran pricingFivetran press
- Connections, transform and activation sit on one Fivetran contract, dbt pricingFivetran pricing whereas the CDC tools named on this page sit outside it. debezium.ioEstuary pricingAWS DMS pricingStriim pricing
Lines on the ground, one hour along the raw layer. Each arch is one batch; arch height means nothing. Only Fivetran Standard's 15 minutes is drawn; other plans and vendors are in the sync-interval chart below. The page gives no cadence for transform or activation, so they have no arches. The green outline is the shared contract.
A common pattern pulls most sources on a schedule and uses CDC only for the few tables that must be fresh. Both land in the same raw layer of the warehouse, where SQL transformation builds the models, and reverse ETL then pushes the finished models back to business apps.
The split matters for cost as well as blame, since when a sales dashboard is wrong you need to know whether the fault sits in capture, load, transform or sync. One tool per stage makes that answer quick and each bill easier to read.
One vendor can now cover three of the four stages. Fivetran and dbt Labs operate as one company, dbt pricing and Fivetran sells Census's reverse ETL as Activations on the same contract as connections and transformations. Fivetran pricing That shortens the vendor list, though you still need to know which stage failed.
What the named tools charge and how they meter
The five CDC tools sit under four different pricing units.
That's the widest spread of the five jobs, whereas in the ELT row three of the four tools count rows or events. Fivetran pricingStitch pricingHevo pricing
This figure in words
- In ETL, Matillion bills credits burned by task hours, and Informatica bills processing units counted per scaler. Matillion pricingInformatica pricing
- Talend (Qlik) sells capacity, counted as data moved, job runs and run time, with no list price. Qlik Talend pricing
- In ELT, Fivetran bills monthly active rows, Stitch rows per month and Hevo events. Fivetran pricingStitch pricingHevo pricing Airbyte Cloud uses credits, whilst Airbyte Core is self-hosted under the Elastic License 2.0. Airbyte pricing
- For the transform step, dbt bills by seats. dbt pricing
- In reverse ETL, Fivetran Activations bills monthly active rows, priced per activation, Fivetran pricing and Hightouch bills on usage without publishing a unit rate. Hightouch pricing
- In CDC, AWS DMS bills DCU-hours, and one DCU is 2 GB of RAM. AWS DMS pricing
- Estuary charges per GB plus per connector, Estuary pricing and Confluent Cloud charges for throughput per GB as well as a per-task hourly fee. Confluent pricing
- Striim prices Cloud and Platform by quote, Striim pricing and Debezium is Apache 2.0 open source. debezium.io
Each dot is one named tool in the cell for its job and pricing unit. Columns group the units, which is Atlas's grouping. Fivetran and Airbyte dots carry their company colours. Prices as of 16 Nov 2026.
Pricing units differ by tool, so the quotes below don't compare until you model your own volumes. Even so, the table is a useful map of what you will be asked to count, and its prices are as of 16 Nov 2026.
Row and event meters reward you for knowing how often your data changes, because Hevo counts every record inserted, updated or deleted Hevo pricing and Fivetran counts the rows processed in a month. Fivetran pricing Per-connector fees, as at Estuary, weigh most on estates with many small sources. Estuary pricing
Entry point for each tool, 15 rows
Pricing unit and entry point per named tool, from each vendor's own pricing or docs page, all re-read on 16 Nov 2026. No list price means the page was read and shows none.
| Tool | Role in the map | Entry point |
|---|---|---|
| Fivetran | ELT | Free plan with 500,000 rows Fivetran pricing; $5 base charge per standard connection Fivetran pricing |
| Airbyte | ELT | Standard from $20 per month Airbyte pricing |
| Stitch | ELT | From $100 Stitch pricing |
| Hevo | ELT, though the vendor says ETL hevodata.com | Starter from $265 per month annual Hevo pricing; 14-day trial Hevo pricing |
| Matillion | ETL | Free trial; no list price Matillion pricing |
| dbt | Transform step, now part of Fivetran dbt pricing | Starter $100 per seat per month dbt pricing |
| Informatica | ETL | Free Cloud Data Integration service; no list price per unit Informatica pricing |
| Talend (Qlik) | ETL | No list price Qlik Talend pricing; open-source Studio retired 31 Jan 2024 Qlik, Talend Studio |
| Hightouch | Reverse ETL | Free tier, up to 2 active syncs Hightouch pricing |
| Fivetran Activations, formerly Census | Reverse ETL | 14-day free trial on each new activation Fivetran pricing |
| Debezium | CDC | Free to run, inside a Kafka Connect cluster you operate debezium.io |
| Estuary | CDC, ETL and streaming estuary.dev | Free Developer tier Estuary pricing |
| Striim | CDC and streaming striim.com | Free Developer tier up to 25 million events per month Striim pricing |
| AWS DMS | CDC and migration | Hourly rate varies by region and Single-AZ or Multi-AZ AWS DMS pricing |
| Kafka Connect on Confluent Cloud | CDC and streaming | No connector rate on the pricing page Confluent pricing |
If X, start with Y
Fivetran Enterprise syncs as often as every 1 minute, and CDC tools stream continuously.
Freshness is the line between ELT and CDC, particularly on the Standard plans, where Fivetran waits 15 minutes and Airbyte an hour. Fivetran pricingAirbyte pricing
This figure in words
- Fivetran Enterprise syncs as often as every minute, and Fivetran Standard every 15 minutes. Fivetran pricing
- Airbyte Pro syncs as often as every 5 minutes, and Airbyte Standard every hour. Airbyte pricing
- Estuary and Striim sell streaming change capture, and Debezium lets you run it yourself, so the chart draws all three as continuous. estuary.devstriim.comdebezium.io
Each stem is the wait between syncs at the fastest setting the plan allows, on a log scale. Continuous is drawn as a zone because it has no number. No vendor publishes a latency figure.
- If you have a warehouse and mostly SaaS sources, start with ELT.
- If one operational database must feed another system within minutes, start with CDC.
- If a regulator or contract forbids raw personal data in the warehouse, start with ETL that masks first.
- If sales ops keeps exporting CSVs from the warehouse, start with reverse ETL.
- If you cannot staff operations, pick a managed service over a self-hosted open source project.
- If you run Kafka already, check whether Kafka Connect covers your sources before buying another capture tool.
Where each approach is the wrong choice
ETL is the wrong choice when requirements change weekly, because every change touches the engine and raw history is gone. Particularly if you later want to reanalyse the raw rows.
ELT is the wrong choice when the target cannot run SQL at scale, whilst CDC is the wrong choice for a handful of small tables that nobody needs fresh.
Reverse ETL is the wrong choice for transactional workflows because it copies warehouse data on a schedule, which suits dashboards and campaigns and will let you down on a payment screen.
Where to go next
This page doesn't rank tools, so for rankings see the best ETL and data pipeline tools and the best data integration platforms, and for the ETL basics alone start with what an ETL pipeline is.
Questions
What is the difference between ETL, ELT, reverse ETL and CDC, and which do I start with?
ETL transforms data before it lands. ELT loads raw data and transforms it in the warehouse. Reverse ETL copies warehouse data out to business apps, and CDC streams row changes from a database log. Start with ELT unless you have a hard reason not to.
How often can Fivetran and Airbyte sync?
Fivetran syncs every 15 minutes on Standard and every minute on Enterprise. Fivetran pricing Airbyte syncs every hour on Standard and every 5 minutes on Pro. Airbyte pricing
Who sells reverse ETL now that Census is part of Fivetran?
Fivetran sells the former Census product as Activations, on the same contract as connections and transformations. Fivetran pricing Hightouch also sells it, with a free tier of up to 2 active syncs. Hightouch pricing
How do CDC tools charge?
On different units. Estuary charges $0.50 per GB plus $100 a month per connector. Estuary pricing AWS DMS bills DCU-hours. AWS DMS pricing Debezium is free under Apache 2.0, inside a Kafka Connect cluster you operate. debezium.io
Is Talend still open source?
No. Qlik retired the open-source Talend Studio on 31 January 2024. Qlik, Talend Studio Qlik Talend Cloud is priced on capacity, and Qlik publishes no list price. Qlik Talend pricing
Sources
Vendor pricing pages
- Fivetran, PricingPage undated. Read 16 Nov 2026. Also the page getcensus.com/pricing now redirects to.
- Airbyte, PricingPage undated. Read 16 Nov 2026.
- Stitch, PricingPage undated. Read 16 Nov 2026.
- Hevo, PricingPage undated. Read 16 Nov 2026.
- Matillion, PricingPage undated. Read 16 Nov 2026.
- dbt Labs, PricingPage undated. Read 16 Nov 2026.
- Informatica, Cloud integration pricingPage undated. Read 16 Nov 2026.
- Qlik, Data integration pricingPage undated. Read 16 Nov 2026.
- Hightouch, PricingPage undated. Read 16 Nov 2026.
- Estuary, PricingDated 13 Oct 2026. Read 16 Nov 2026.
- Striim, PricingPage undated. Read 16 Nov 2026.
- AWS, Database Migration Service pricingPage undated. Read 16 Nov 2026.
- Confluent, Confluent Cloud pricingPage undated. Read 16 Nov 2026.
Vendor product and docs pages
- Airbyte, Home pagePage undated. Read 16 Nov 2026.
- Hevo, Home pagePage undated. Read 16 Nov 2026.
- Matillion, Home pagePage undated. Read 16 Nov 2026.
- Qlik, Talend Open StudioRetirement 31 Jan 2024. Read 16 Nov 2026.
- Debezium, Home pagePage undated. Read 16 Nov 2026.
- Estuary, Home pagePage undated. Read 16 Nov 2026.
- Striim, Home pagePage undated. Read 16 Nov 2026.
Announcements
- Fivetran, Fivetran signs agreement to acquire CensusDated 1 May 2025. Read 10 Nov 2026.
Each chip in the text opens its source here. The Talend secondary report in the brief was replaced by Qlik's own pricing page.