License & Deployment Mix: 17 tools – 1 OSS, 8 SaaS. (OSS and SaaS counts can overlap when an open-source tool also offers a vendor-hosted edition.)
What Is ETL / Data Integration Software?
ETL (Extract, Transform, Load) and data integration software moves data between systems – databases, APIs, files, warehouses, and cloud services. It is the backbone of any data pipeline, enabling analytics, reporting, synchronization, and operational workflows.
Modern data integration has evolved beyond traditional batch ETL into several patterns:
- ETL – extract data from sources, transform it in a staging area, then load it into a target (traditional approach; transformations happen before loading)
- ELT – extract and load raw data into a warehouse or lake, then transform it in-place using SQL or dbt (modern cloud-native approach)
- CDC (Change Data Capture) – capture incremental changes from source databases in real-time using transaction logs (WAL, binlog)
- Reverse ETL – push transformed data from warehouses back into operational tools (CRM, marketing, support)
- Data replication – continuous synchronization between databases or systems
- API integration – connect SaaS applications via REST/GraphQL APIs with scheduling and error handling
- Stream processing – real-time event-driven data movement (Kafka-based pipelines)
The information on these pages was researched by a combination of human review and large language models. To suggest an addition or correction, please contact us. Prepared by Rhodium Systems Inc., author of the ResorsIT platform — a unified IT operations management platform for IT teams and MSPs that integrates a curated suite of open-source, commercial, and SaaS applications into a single system with shared identity, single sign-on, access control, and a common audit trail. Use this catalogue only as a starting point for your own research, and review any tool carefully against your own requirements before relying on it. Catalogue data version 2026.197.
Comparison
Feature Matrix – Open Source
| Feature | NiFi | Airbyte | dbt | Airflow | Meltano | Singer | Kafka Connect |
|---|---|---|---|---|---|---|---|
| Extract | Yes | Yes | No | Orch | Yes | Yes | Yes |
| Load | Yes | Yes | No | Orch | Yes | Yes | Yes |
| Transform | Yes | Post-load | Yes | Orch | dbt | No | SMT only |
| CDC | Yes | Yes | No | Orch | No | No | Yes |
| Scheduling | Yes | Yes | No* | Yes | Yes | No | N/A** |
| Web UI | Yes | Yes | Cloud | Yes | No | No | No |
| REST API | Yes | Yes | Cloud | Yes | No | No | Yes |
Orch = orchestrates external tools (not built-in) * = dbt Cloud has scheduling; dbt Core does not ** = Kafka Connect runs continuously (streaming)
Feature Matrix – Commercial / Enterprise
| Feature | Fivetran | Stitch | Matillion | Hevo | Rivery |
|---|---|---|---|---|---|
| Extract | Yes | Yes | Yes | Yes | Yes |
| Load | Yes | Yes | Yes | Yes | Yes |
| Transform | dbt | No | Yes | Yes | Yes |
| CDC | Yes | Yes | Basic | Yes | No |
| Scheduling | Yes | Yes | Yes | Yes | Yes |
| Web UI | Yes | Yes | Yes | Yes | Yes |
| REST API | Yes | Ltd | Yes | Yes | Yes |
| Feature | Informatica | Talend | SSIS | ODI |
|---|---|---|---|---|
| Extract | Yes | Yes | Yes | Yes |
| Load | Yes | Yes | Yes | Yes |
| Transform | Yes | Yes | Yes | Yes |
| CDC | Yes | Yes | Yes | Yes |
| Scheduling | Yes | Yes | Yes | Yes |
| Web UI | Yes | IDE | IDE | IDE |
| REST API | Yes | Yes | No* | Ltd |
Ltd = limited API * = SSIS uses T-SQL procedures, not REST API
Deployment Comparison
| Tool | Type | Self-Hosted | SaaS | Platform |
|---|---|---|---|---|
| Apache NiFi | OSS | Yes | No | Java (any OS) |
| Airbyte | Open Core | Yes | Yes | Docker/K8s |
| dbt | Open Core | Yes* | Yes | Python CLI |
| Apache Airflow | OSS | Yes | Yes** | Python |
| Meltano | OSS | Yes | No | Python CLI |
| Singer | OSS | Yes | No | Python CLI |
| Kafka Connect | OSS | Yes | Yes*** | Java (Kafka) |
| Fivetran | Commercial | No | Yes | SaaS only |
| Stitch | Commercial | No | Yes | SaaS only |
| Matillion | Commercial | Legacy | Yes | SaaS/Cloud VM |
| Hevo Data | Commercial | No | Yes | SaaS only |
| Rivery | Commercial | No | Yes | SaaS only |
| Informatica | Enterprise | Hybrid | Yes | SaaS + Agent |
| Talend | Enterprise | Legacy | Yes | Java |
| Microsoft SSIS | Enterprise | Yes | Azure | Windows only |
| Oracle ODI | Enterprise | Yes | OCI | Oracle/Java |
* = dbt Core is CLI; dbt Cloud is SaaS ** = MWAA, Cloud Composer, Astronomer *** = Confluent Cloud
Licensing Comparison
| Tool | License | Cost Model |
|---|---|---|
| Apache NiFi | Apache 2.0 | Free |
| Airbyte | Elv2 / MIT | Free self-hosted; Cloud usage-based |
| dbt | Apache 2.0 | Free Core; Cloud from $100/seat/mo |
| Apache Airflow | Apache 2.0 | Free |
| Meltano | MIT | Free |
| Singer | Apache 2.0 | Free |
| Kafka Connect | Apache 2.0 | Free |
| Fivetran | Proprietary | Usage-based (MAR) |
| Stitch | Proprietary | From $100/mo |
| Matillion | Proprietary | Usage-based credits |
| Hevo Data | Proprietary | From $239/mo |
| Rivery | Proprietary | Usage-based credits |
| Informatica | Proprietary | Enterprise ($50k+/yr) |
| Talend | Proprietary | Enterprise ($30k+/yr) |
| Microsoft SSIS | Proprietary | SQL Server license |
| Oracle ODI | Proprietary | Per-processor ($22.5k) |
Connector Count Comparison
| Tool | Connectors | Notes |
|---|---|---|
| Informatica | 1,000+ | Includes legacy PowerCenter |
| Talend | 900+ | Components in Talend Studio |
| Singer | 600+ | Via MeltanoHub; quality varies |
| Meltano | 600+ | Singer-based via MeltanoHub |
| Fivetran | 500+ | All managed by Fivetran |
| Airbyte | 350+ | Mix of Airbyte and community |
| Apache NiFi | 300+ | Processors (connectors) |
| Kafka Connect | 200+ | Via Confluent Hub |
| Rivery | 200+ | Growing library |
| Hevo Data | 150+ | Growing library |
| Stitch | 130+ | Singer-based |
| Matillion | 100+ | Growing library |
| dbt | 30+ | Warehouse adapters only |
| Airflow | 80+ | Provider packages (orchestrator) |
| SSIS | ~50 | ODBC/OLEDB for others |
| ODI | ~40 | Knowledge Modules |
SSO / OIDC Comparison
OIDC is the preferred SSO protocol; the notes below assume Authentik as the external identity provider.
| Tool | OIDC | SAML | Notes |
|---|---|---|---|
| Apache NiFi | Yes | Yes | Native support |
| Airbyte | Ent | Ent | Enterprise tier only |
| dbt Cloud | No | Ent | SAML on Enterprise |
| Airflow | Custom | No | Via FAB security manager |
| Meltano | N/A | N/A | CLI tool (no auth) |
| Singer | N/A | N/A | CLI tool (no auth) |
| Kafka Connect | No | No | API secured externally |
| Fivetran | No | Biz+ | SAML on Business+ |
| Stitch | No | Ent | SAML on Enterprise |
| Matillion | Ent | Ent | Enterprise tier |
| Hevo Data | No | Ent | SAML on Enterprise |
| Rivery | No | Ent | SAML on Enterprise |
| Informatica | Yes | Yes | Full SSO support |
| Talend | Yes | Yes | Full SSO support |
| SSIS | No | No | Windows AD only |
| ODI | No | No | LDAP only |
Ent = Enterprise tier only Biz+ = Business tier and above Custom = requires custom configuration
Best SSO support: Apache NiFi (native OIDC), Informatica IDMC, and Talend offer the best SSO integration with Authentik. Airbyte Enterprise and Matillion Enterprise also support OIDC.
CDC Comparison
| Tool | CDC Type | Databases Supported |
|---|---|---|
| Kafka Connect | Debezium (log) | PG, MySQL, SQL Server, MongoDB, Oracle |
| Airbyte | Debezium (log) | PG, MySQL, SQL Server, MongoDB |
| Informatica | PowerExchange | Oracle, SQL Server, Db2, PG, MySQL |
| ODI | GoldenGate | Oracle, SQL Server, MySQL, Db2 |
| Fivetran | Log-based | PG, MySQL, SQL Server |
| Stitch | Log-based | PG, MySQL, SQL Server, MongoDB |
| Hevo Data | Log-based | PG, MySQL, SQL Server, MongoDB |
| SSIS | Trigger/log | SQL Server native; Attunity for others |
| Talend | Log/trigger | Oracle, SQL Server, Db2 |
| NiFi | Processor-based | PG, MySQL (via CDC processors) |
| Matillion | Change query | Basic (not log-based) |
| Meltano | No | N/A |
| Singer | No | N/A |
| dbt | No | Transform only |
| Airflow | No | Orchestrator only |
| Rivery | No | N/A |
Best CDC: Kafka Connect (Debezium) is the gold standard for open-source CDC. Airbyte also uses Debezium internally.
Tools
17 tools.
Airbyte
Airbyte is the leading open-source ELT platform focused on data movement – extracting data from sources and loading it into warehouses, lakes, or databases.
License: LicenseRef-Airbyte-ELv2 (source-available) · Kind: web · Deploy: native, docker, k8s · SSO: SAML
Apache Airflow
Apache Airflow is the most widely adopted open- source workflow orchestration platform. It enables users to programmatically author, schedule, and monitor complex data pipelines as Directed Acyclic Graphs (DAGs) written in Python.
License: Apache-2.0 (OSS) · Kind: web · Deploy: native, docker · SSO: none
Apache Camel
Apache Camel is an open-source integration framework that implements the Enterprise Integration Patterns (EIP) from the Hohpe/Woolf book as first-class constructs.
License: Apache-2.0 (OSS) · Kind: web · Deploy: native · SSO: none
Apache Kafka Connect
Apache Kafka Connect is a streaming data integration framework built into the Apache Kafka ecosystem.
License: Apache-2.0 (OSS) · Kind: web · Deploy: native · SSO: none
Apache NiFi
Apache NiFi is a powerful, visual data flow automation tool originally developed by the NSA and donated to the Apache Software Foundation.
License: Apache-2.0 (OSS) · Kind: web · Deploy: native, docker · SSO: OIDC
dbt (data build tool)
dbt (data build tool) is the industry-standard transformation layer for the modern data stack. It enables data analysts and engineers to transform data already loaded into a warehouse using SQL SELECT statements and Jinja templating.
License: Apache-2.0 (OSS) · Kind: web · Deploy: saas · SSO: SAML
Fivetran
Fivetran is the market-leading managed ELT platform that automates data extraction and loading from SaaS applications, databases, and files into cloud data warehouses.
License: Proprietary (proprietary) · Kind: web · Deploy: saas · SSO: OIDC, SAML
Hevo Data
Hevo Data is a no-code managed ELT platform that provides automated data pipelines from sources to cloud warehouses and destinations.
License: Proprietary (proprietary) · Kind: web · Deploy: saas · SSO: OIDC, SAML
Informatica Cloud (IDMC)
Informatica Intelligent Data Management Cloud (IDMC) is an enterprise data integration platform unifying integration, quality, governance, catalog, and MDM, with 1,000+ connectors and CLAIRE AI.
License: Proprietary (proprietary) · Kind: web · Deploy: saas · SSO: OIDC, SAML
Matillion
Matillion is a data productivity platform that provides visual, low-code ELT pipeline design with native execution in cloud data warehouses.
License: Proprietary (proprietary) · Kind: web · Deploy: saas · SSO: OIDC, SAML
Meltano
Meltano is an open-source DataOps platform that provides a CLI-first workflow for the entire data lifecycle: extract, load, transform, analyze, and orchestrate.
License: MIT (OSS) · Kind: web · Deploy: docker · SSO: none
Microsoft SSIS
SQL Server Integration Services (SSIS) is Microsoft’s enterprise ETL platform included with SQL Server. It provides a visual package designer (in Visual Studio) for building data extraction, transformation, and loading workflows.
License: Proprietary (proprietary) · Kind: web · Deploy: saas, native, package · SSO: none
Oracle Data Integrator (ODI)
Oracle Data Integrator (ODI) is Oracle’s enterprise data integration platform designed primarily for Oracle-centric environments.
License: Proprietary (proprietary) · Kind: web · Deploy: saas · SSO: none
Rivery
Rivery is a managed data integration platform that combines ELT, reverse ETL, and workflow orchestration in a single SaaS product.
License: Proprietary (proprietary) · Kind: web · Deploy: saas · SSO: SAML
Singer
Singer is an open-source specification for moving data between systems, defining a JSON-based protocol between taps (extractors) and targets (loaders); its ecosystem is now maintained largely via Meltano.
License: Apache-2.0 (OSS) · Kind: web · Deploy: saas, docker, k8s · SSO: none
Stitch
Stitch is a managed ELT platform that extracts data from sources and loads it into cloud data warehouses.
License: Proprietary (proprietary) · Kind: web · Deploy: saas · SSO: SAML
Talend
Talend is a comprehensive data integration and data quality platform that has been a major player in the ETL market since 2005.
License: Proprietary (proprietary) · Kind: web · Deploy: saas · SSO: OIDC, SAML
