Catalog of ETL and EL-T tools
Catalog of ETL and EL-T tools

Catalog of ETL and EL-T tools

As companies collect increasing amounts of data, the latter tends to end up scattered around various different sources. For this reason, there is a need to distribute data from various data sources to the data warehouse.

This explains the recent explosion in the past few years of ETL/ELT tools. (internal, open-source, and SaaS). This new trend is not going to stop, and we'd rather bring visibility and structure soon.

At Castor, we believe the first step to structure the ETL tools market, is more transparency. For that reason, we put up a list of all the ETL/EL-T tools we heard of. More context on this analysis and the state of the ETL tools ecosystem here.

image
💡
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 with ETL and EL-T tools

📢
In-depth analysis and evolution Read the full breakdown by generation and market analysis of ETL tools here.
image
🌱
What does Reddit think about ETL tools? You can find the thread here.
image

Dive deeper into ETL and EL-T tools

‣
What does each column in the benchmark below mean?

ETL Benchmark and Key Features

NameWebsiteDeploymentPricingProcess usedOptimized forProcessingOut-of the box connectorsTransformationsincremental updatesChange data captureHistoryAutomatic scalingImport APIFailed syncfeaturesSecurityObservabilityNo-code platformSetup timeCommunity
Fivetran

https://fivetran.com

Proprietary Cloud-based
Volume-based
ELT
ExtractionLoading
BatchStream/real-time
150+
DbtSQL
HistoryCapture deletesData blocking
GDPR compliantHIPAA compliant
Stitch

https://www.stitchdata.com

Proprietary
Volume-based
ELTETL
Transformation LoadingExtraction
BatchStream/real-time
130+
SQLPythonJavaGUI
Import APIAutomatic scalingSupport for paying customersExtract data from any source using singerEasy schedulingEnterpriseNo code
GDPR compliantHIPAA compliantSOC2 compliant
Airbyte

https://airbyte.io

Open-source
To be announced
ELT
ExtractionLoading
BatchStream/real-time
110+
Dbt
Historysupport within 2-3hrsBuild a new connector under two hoursNormalized schemas.Easy schedule
Xplenty

https://www.xplenty.com

Proprietary Cloud-based
Connector-based
ETLELT
ExtractionLoadingTransformation
Stream/real-timeBatch
140+
GUINo-code
Import API
SOC2 compliantGDPR compliantHIPAA compliantCCPA
Popsink

https://www.popsink.com

SaaS
24
Rivery

https://rivery.io

Proprietary SaaS
Volume-based
ETLELT
ExtractionLoadingTransformation
Stream/real-time
150+
SQL
Change data capture
GDPR compliantHIPAA compliantSOC2 compliant
Alooma

https://www.alooma.com

Proprietary
Contact only
ETLELT
ExtractionLoadingTransformation
Stream/real-timeBatch
GUINo-code
Automatic scalingData visualization
SOC2 compliantHIPAA compliantGDPR compliantOAuth 2.0
10 min
Improvado

https://www.sisense.com/marketplace/improvado/

Proprietary
Contact only
ETL
ExtractionLoadingTransformation
200+
GUINo-code
Import APINormalized schemas.
Segment

https://segment.com/product/warehouses/

SaaSProprietary
Company size
ETL
ExtractionLoading
BatchStream/real-time
40+
GUINo-code
Rudderstack

https://www.rudderstack.com/

SaaSOpen-sourceEnterprise VPC
Volume-based
ETL
ExtractionLoadingTransformation
BatchStream/real-time
150+Create custom
javascript
event streamtransformationsReverse ETLEvent replaySSOSingle tenantGrafana dashboards
SOC2 compliantGDPR compliantHIPAA compliantCCPA compliant
Minutes
Portable

https://portable.io/

Proprietary Cloud-based
Connector-based
ELT
ExtractionLoading
Batch
250+
N/A
HistoryCapture deletesSupport for paying customersAutomatic scalingEnterpriseNo code
5-30min
Meltano

https://meltano.com

Open-source
Free
ELT
ExtractionLoading
BatchStream/real-time
30+
Dbt
Minutes
Hevo

https://hevodata.com

Proprietary
Events-based
ELT
ExtractionLoadingTransformation
Stream/real-time
100+
SQL
Automatic scaling24/7 live support
GDPR compliantSOC2 compliantHIPAA compliant
Minutes
Meroxa

https://meroxa.com

PaaSOpen-source
Events-based
ELT
ExtractionLoadingTransformation
Stream/real-time
10+
Change data capture
Panoply

https://panoply.io

SaaSProprietary
Volume-based
ELT
50+
GDPR compliantSOC2 compliant
Matillion

https://www.matillion.com

Proprietary
Contact only
ETL
ExtractionLoadingTransformation
Batch
100+
GUINo-code
Automatic scaling
Few days
Singer

https://www.singer.io

Open-source
Free
ETL
Batch
100+
Apache camel

https://kafka.apache.org

Open-source
Free
Stream/real-time
Logstache

https://www.elastic.co/fr/logstash/

Open-source
Free
ETLELT
Stream/real-time
200+
Safe

https://www.safe.com

ETL
ExtractionLoadingTransformation
Batch
450+
No-code
IBM Datastage

https://www.ibm.com/products/datastage

Proprietary
Contact only
ETL
ExtractionTransformation Loading
Batch
Informatica

https://www.informatica.com/services-and-training

Proprietary
Contact only
ETL
ExtractionLoadingTransformation
Batch
HIPAA compliantSOC2 compliantSOC 3 compliant
Talend

https://www.talend.com/fr/products/data-integration/

Open-sourceOn-premises
Mulesoft

Proprietary
Pipeline wise

https://transferwise.github.io/pipelinewise/

Proprietary
Integrations with Singer
Oracle

https://www.oracle.com/middleware/technologies/data-integrator.html?

Proprietary
Pentaho

Proprietary
Skyvia

Proprietary
SAP data services

Proprietary
FlyData

https://flydata.com

Volume-based
ETL
Stream/real-time
GDPR compliant
30 min

*This is a brief attempt at classifying the tools on the market. If anything seems wrong. The feature list seems off, or if you don't see your data catalog and want to have it placed, please reach out: louise@castordoc.com