- Home
- Data Transformation Tools
- Apache Hop
Apache Hop
What it is
Apache Hop is a free, open-source platform for data integration and orchestration. Users assemble visual pipelines on a canvas, preview rows at individual steps, and monitor live data and metrics during execution. A pipeline can run locally, on Hop Server, on Apache Spark, or on Flink and Dataflow through Apache Beam. Hop includes more than 250 pipeline transforms, over 80 workflow actions, and more than 40 database dialects. Listed connections include PostgreSQL, MySQL, Oracle, SQL Server, Snowflake, BigQuery, Kafka, Salesforce, SAP, S3, REST, and SFTP. Projects can switch environments between development and production, and credentials can be kept outside pipelines. The software runs on Linux, macOS, and Windows; Hop Web supports modern browsers. Release 2.19.0 requires Java 21. Docker images and a Kubernetes Helm chart are available, though Hop Web is work in progress and provided as-is. The project warns that operations can affect databases, filesystems, and other infrastructure, so permissions and restrictions matter.
For and against
For
- Free under the Apache License 2.0
- Visual pipeline design with row previews
- Runs on multiple execution environments
- Includes over 250 transforms and 80 actions
- Supports environment switching and separated credentials
Against
- Release 2.19.0 requires Java 21
- Hop Web is work in progress and provided as-is
- Operations can alter or delete connected data
- Community support has no promised response times
The verdict
Apache Hop combines visual pipeline and workflow design with several execution choices and a broad set of integrations. Its free availability is useful, but Java requirements, operational cautions, and the work-in-progress status of Hop Web are worth considering.
Who it suits
It suits teams building and running data integration pipelines across varied environments. Users should be prepared to manage permissions carefully because operations can affect connected data infrastructure.
Plans and prices
Apache Hop
open-source platform · desktop and web interfaces · optional plugins and commercial support available separately
Read 15 Oct 2026 · hop.apache.org
On the record
- Built-in scale
- The homepage states that the distribution includes more than 250 pipeline transforms, 80 workflow actions and 40 database dialects.hop.apache.org · read 15 Oct 2026
- Cloud runtimes
- Run configurations include Databricks, native Spark, Beam Spark, Beam Flink and Google Dataflow options.hop.apache.org · read 15 Oct 2026
- Commercial listing
- The Apache Hop project says its commercial-support listing is informational and that it does not endorse, rank, or vet the listed companies.hop.apache.org · read 29 Sep 2026
- Commercial support
- The commercial-support directory lists Avizing, know.bi and Yupiik, while stating that Apache does not endorse or vet them.hop.apache.org · read 15 Oct 2026
- Configuration
- Projects can be moved between development and production by switching environments, and credentials can be kept out of pipelines.hop.apache.org · read 29 Sep 2026
- Deployment
- The download page provides Docker images for Hop and Hop Web and a Helm chart for Kubernetes; Hop Web is described as work in progress and provided as-is.hop.apache.org · read 29 Sep 2026
- Download
- The Apache archive lists source code and a 333 MB apache-hop-client-2.19.0.zip released on 17 August 2026.archive.apache.org · read 15 Oct 2026
- Execution
- The same pipeline can run locally, on Hop Server, on Apache Spark, or on Flink and Dataflow through Apache Beam.hop.apache.org · read 29 Sep 2026
- Included components
- The platform includes 250+ pipeline transforms, 80+ workflow actions, and 40+ database dialects.hop.apache.org · read 29 Sep 2026
- Independent documentation criticism
- A 2025/2026 academic project report said limited official documentation can make developing plugins from scratch challenging.eprints.ost.ch · read 15 Oct 2026
- Independent usage description
- An OpenSchoolMaps training document describes Hop GUI, Hop Run CLI and Hop Server REST execution as the three primary clients.openschoolmaps.ch · read 15 Oct 2026
- Integrations
- Listed integrations include PostgreSQL, MySQL, Oracle, SQL Server, Snowflake, BigQuery, Redshift, Databricks, MongoDB, Neo4j, Kafka, Cassandra, Salesforce, SAP, Parquet, Avro, S3, Azure Blob, Google Cloud Storage, REST and SFTP.hop.apache.org · read 15 Oct 2026
- Java requirement
- Current Hop 2.19.0 documentation requires a 64-bit Java 21 runtime.hop.apache.org · read 15 Oct 2026
- Java SDK
- A documented Hop SDK provides Java initialization APIs and supports loading plugins from configured folders.hop.apache.org · read 15 Oct 2026
- Licence
- Apache Hop is released under the Apache License 2.0.hop.apache.org · read 15 Oct 2026
- License
- The project says Hop is developed in the open under the Apache License 2.0.hop.apache.org · read 29 Sep 2026
- Limit: CDC
- The CDC guide says Hop has no single CDC transform and no built-in Debezium or GoldenGate connector; users must choose among log, watermark or snapshot approaches.hop.apache.org · read 15 Oct 2026
- Limit: connector parsing
- A Reddit commenter reported BigQuery connector problems parsing queries containing a LIMIT clause and difficulty scaling component-based designs.reddit.com · read 15 Oct 2026
