What Is ETL / Data Integration Software?
Mix (17 tools)
- License: 7 open source · 10 proprietary
- Hosting: 6 self-hosted · 9 SaaS · 2 both
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)
About this data & disclaimer
The information on these pages was researched by a combination of human review and large language models. This catalogue serves as a reference for the resources, applications, devices, deployment payloads, and other components that the ResorsIT platform integrates, deploys, and manages. 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. This information is compiled on a best-effort basis: it may be incomplete, contain errors, and become out of date as tools, vendors, licences, and features change. Use this catalogue only as a starting point for your own research, and independently verify and review any tool carefully against your own requirements before relying on it.
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: direct, docker, k8s · SSO: OIDC, SAML
ResorsIT usage: Web App with SSO
Access & Identity: Single sign-on
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: direct, docker · SSO: none
ResorsIT usage: Web App without SSO
Access & Identity: Forward-auth · Directory / LDAP
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: direct · SSO: none
ResorsIT usage: Web App without SSO
Access & Identity: Forward-auth · Vaulted credential
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: direct · SSO: none
ResorsIT usage: Web App without SSO
Access & Identity: Forward-auth · Vaulted credential
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: direct, docker · SSO: OIDC, SAML
ResorsIT usage: Web App with SSO
Access & Identity: Single sign-on · Directory / LDAP
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: OIDC, SAML
ResorsIT usage: Web App with SSO
Access & Identity: Single sign-on · Provisioned account
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
ResorsIT usage: Web App with SSO
Access & Identity: Single sign-on · Provisioned account
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
ResorsIT usage: Web App with SSO
Access & Identity: Single sign-on
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
ResorsIT usage: Web App with SSO
Access & Identity: Single sign-on · Directory / LDAP · Provisioned account
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
ResorsIT usage: Web App with SSO
Access & Identity: Single sign-on
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
ResorsIT usage: Web App without SSO
Access & Identity: Forward-auth · Vaulted credential
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, direct, package · SSO: none
ResorsIT usage: Web App without SSO
Access & Identity: Forward-auth · Vaulted credential
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
ResorsIT usage: Web App without SSO
Access & Identity: Directory / LDAP
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
ResorsIT usage: Web App with SSO
Access & Identity: Single sign-on
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
ResorsIT usage: Web App without SSO
Access & Identity: Forward-auth · Vaulted credential
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
ResorsIT usage: Web App with SSO
Access & Identity: Single sign-on
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
ResorsIT usage: Web App with SSO
Access & Identity: Single sign-on · Directory / LDAP · Provisioned account
