ETL vs ELT vs reverse ETL vs CDC: the data-movement map

By Rafal Fila, ShadowGenRead Guide

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.

SourcesETLscheduled batchELTloads raw, transforms inside the warehouseCDCcontinuous, read from the database logReverse ETLscheduledSource systemsapps and databasesDatabase logrow changes, deletes tooProcessing enginetransforms before loadWarehouseraw layer,then modelsBusiness appsCRM, ad toolsSourcesETLELTtransforms insideCDCcontinuousReverse ETLscheduledSource systemsapps and databasesDatabase logrow changesProcessing enginetransforms firstWarehouseraw layer, then modelsBusiness appsCRM, ad tools
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

Fivetran Free plan 500,000 rows checked
Monthly active rows a month, free
500,000 rows
Fivetran bills on monthly active rows, the rows it processes in a calendar month.
Paid connections
$5 base charge each, 1 to 1M MAR
Connectors
700+ on Standard
Source fivetran.com/pricing, page undated. Read . Fivetran pricing
Airbyte Standard $20 a month checked
Airbyte Cloud, credit-based
$20 a month
Plus starts at $189 a month. Core is free to self-host under the Elastic License 2.0.
Pro, Enterprise Flex
custom quote
Syncs
hourly on Standard
Source airbyte.com/pricing, page undated. Read . Airbyte pricing
Estuary Cloud $0.50 per GB checked
Plus $100 a month per connector
$0.50 per GB
Each connector instance after the sixth costs $50 a month.
Free tier
10 GB a month, 2 connectors
Log-based CDC
in all three plans
Source estuary.dev/pricing. Dated 13 Oct 2026. Read . Estuary pricing
dbt Starter $100 a seat checked
Per seat per month
$100 a seat
The free Developer plan is one seat with 3,000 successful models a month.
Owner
Fivetran, since dbt Labs joined it
Meter
seats
Source getdbt.com/pricing, page undated. Read . dbt pricing

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.

Four data-movement approaches by direction, transformation point, latency, fit and example tools. Tool facts as of 16 Nov 2026; roles are Atlas's reading, and pricing is in the second table. Direction of flow and where transformation happens are drawn in the figure above.
ApproachTypical latencyUse it whenWrong choice whenExample tools
ETLScheduled batchData must be cleaned, masked or reshaped before it landsYou want raw data kept for later reanalysisInformatica, Informatica pricing Talend (Qlik), Qlik Talend pricing Matillion matillion.com
ELTScheduled batch to frequent micro-batchThe warehouse is your compute and you want raw historyRegulated fields cannot land unmaskedFivetran, Fivetran pricing Airbyte, Airbyte pricing Stitch, Stitch pricing Hevo, Hevo pricing dbt for the transform step dbt pricing
Reverse ETLScheduled batchSales or marketing need modelled data inside a CRM or ad toolYou need an app to react in the moment, or the warehouse data is staleHightouch, Hightouch pricing Fivetran Activations, formerly Census Fivetran pressFivetran pricing
CDCContinuous, near real timeYou must replicate row changes, including deletes, without querying the source heavilyThe source exposes no log, or a nightly copy of a small table is enoughDebezium, 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

015304560CDC: continuousRaw layer: both land hereOne hourFivetran connectionsa batch every 15 minutes on Standard, MARTransformdbt, billed by seatsActivateActivations, formerly Census, MAROne Fivetran contract015304560Transformdbt, billed by seatsActivateActivations, formerly Census, MAROne hourclock axis, minutes 0 to 60Raw layer: both land hereCDC: continuousFivetran connectionsa batch every 15 minutes on Standard, MAROne Fivetran contract
This figure in words

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

Pricing unit, grouped by AtlasRows or eventsCredits orcompute unitsData volume,per GBSeatsQuote or capacity,no unit priceFree toself-hostJobETL3 tools, 2 unitsMatilliontask-hour creditsInformaticaIPUs per scalerTalendcapacityELT4 tools, 3 unitsFivetranactive rows (MAR)Stitchrows a monthHevoeventsAirbytecredits, CloudAirbyte CoreELv2 licenceTransform1 tool, 1 unitdbtper seatReverse ETL2 tools, 2 unitsActivationsactive rows (MAR)Hightouchusage, no rateCDC5 tools, 4 unitsAWS DMSDCU-hoursEstuaryGB + connectorConfluentGB + task-hourStriimquoteDebeziumApache 2.0ETL3 tools, 2 unitsCredits orcompute unitsMatilliontask-hour creditsInformaticaIPUs per scalerQuote or capacity,no unit priceTalendcapacityELT4 tools, 3 unitsRows or eventsFivetranactive rows (MAR)Stitchrows a monthHevoeventsCredits orcompute unitsAirbytecredits, CloudFree toself-hostAirbyte CoreELv2 licenceTransform1 tool, 1 unitSeatsdbtper seatReverse ETL2 tools, 2 unitsRows or eventsActivationsactive rows (MAR)Quote or capacity,no unit priceHightouchusage, no rateCDC5 tools, 4 unitsCredits orcompute unitsAWS DMSDCU-hoursData volume,per GBEstuaryGB + connectorConfluentGB + task-hourQuote or capacity,no unit priceStriimquoteFree toself-hostDebeziumApache 2.0
This figure in words

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.

ToolRole in the mapEntry point
FivetranELTFree plan with 500,000 rows Fivetran pricing; $5 base charge per standard connection Fivetran pricing
AirbyteELTStandard from $20 per month Airbyte pricing
StitchELTFrom $100 Stitch pricing
HevoELT, though the vendor says ETL hevodata.comStarter from $265 per month annual Hevo pricing; 14-day trial Hevo pricing
MatillionETLFree trial; no list price Matillion pricing
dbtTransform step, now part of Fivetran dbt pricingStarter $100 per seat per month dbt pricing
InformaticaETLFree Cloud Data Integration service; no list price per unit Informatica pricing
Talend (Qlik)ETLNo list price Qlik Talend pricing; open-source Studio retired 31 Jan 2024 Qlik, Talend Studio
HightouchReverse ETLFree tier, up to 2 active syncs Hightouch pricing
Fivetran Activations, formerly CensusReverse ETL14-day free trial on each new activation Fivetran pricing
DebeziumCDCFree to run, inside a Kafka Connect cluster you operate debezium.io
EstuaryCDC, ETL and streaming estuary.devFree Developer tier Estuary pricing
StriimCDC and streaming striim.comFree Developer tier up to 25 million events per month Striim pricing
AWS DMSCDC and migrationHourly rate varies by region and Single-AZ or Multi-AZ AWS DMS pricing
Kafka Connect on Confluent CloudCDC and streamingNo 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

Hover a row for its reading. Scheduled tools wait between syncs; CDC tools stream.Tool and plan1 min5 min15 min1 hourcontinuousFivetranEnterpriseevery 1 minStandardevery 15 minAirbyteProevery 5 minStandardevery 1 hourCDC toolsEstuaryStriimDebeziumShortest time between syncs, log scaleFivetran Enterprisesyncs as often as every 1 minuteFivetran Standardsyncs as often as every 15 minutesAirbyte Prosyncs as often as every 5 minutesAirbyte Standardsyncs as often as every 1 hourEstuarystreams continuouslyStriimstreams continuouslyDebeziumstreams continuouslyTap a row for its reading.Tool and plan151560cont.FivetranEnterprise1 minStandard15 minAirbytePro5 minStandard1 hourCDC toolsEstuaryStriimDebeziumShortest time between syncs, minutes, log scaleFivetran Enterprisesyncs as often as every 1 minuteFivetran Standardsyncs as often as every 15 minutesAirbyte Prosyncs as often as every 5 minutesAirbyte Standardsyncs as often as every 1 hourEstuarystreams continuouslyStriimstreams continuouslyDebeziumstreams continuously
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

  1. Fivetran, PricingPage undated. Read 16 Nov 2026. Also the page getcensus.com/pricing now redirects to.
  2. Airbyte, PricingPage undated. Read 16 Nov 2026.
  3. Stitch, PricingPage undated. Read 16 Nov 2026.
  4. Hevo, PricingPage undated. Read 16 Nov 2026.
  5. Matillion, PricingPage undated. Read 16 Nov 2026.
  6. dbt Labs, PricingPage undated. Read 16 Nov 2026.
  7. Informatica, Cloud integration pricingPage undated. Read 16 Nov 2026.
  8. Qlik, Data integration pricingPage undated. Read 16 Nov 2026.
  9. Hightouch, PricingPage undated. Read 16 Nov 2026.
  10. Estuary, PricingDated 13 Oct 2026. Read 16 Nov 2026.
  11. Striim, PricingPage undated. Read 16 Nov 2026.
  12. AWS, Database Migration Service pricingPage undated. Read 16 Nov 2026.
  13. Confluent, Confluent Cloud pricingPage undated. Read 16 Nov 2026.

Vendor product and docs pages

  1. Airbyte, Home pagePage undated. Read 16 Nov 2026.
  2. Hevo, Home pagePage undated. Read 16 Nov 2026.
  3. Matillion, Home pagePage undated. Read 16 Nov 2026.
  4. Qlik, Talend Open StudioRetirement 31 Jan 2024. Read 16 Nov 2026.
  5. Debezium, Home pagePage undated. Read 16 Nov 2026.
  6. Estuary, Home pagePage undated. Read 16 Nov 2026.
  7. Striim, Home pagePage undated. Read 16 Nov 2026.

Announcements

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