Apache Hop vs Prophecy
Apache Hop
hop.apache.org
Prophecy
prophecy.aiSide by side
| Figure | Apache Hop | Prophecy |
|---|---|---|
| Price from | Free | $150/mo |
| Free plan | Yes | Yes |
| Free trial | — | — |
| Open source | Yes | — |
| Web | Yes | Yes |
| Windows | Yes | — |
| macOS | Yes | — |
| Linux | Yes | — |
| API | Yes | Yes |
| Self-hosted | Yes | — |
| Plans published | 2 | 4 |
| Spec score · Data Transformation Tools | 9.0 (#5) | 7.7 (#21) |
| 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. | Visual workflows deploy as production-ready code on the customer’s cloud data platform, including native Snowflake SQL workflows that run inside Snowflake. |
| Security | The security page advises upgrading to a version containing a vulnerability fix because binary patches are not produced for individual vulnerabilities. | Prophecy says it works against data in place and keeps descriptive metadata; its trust page describes AES-256 encryption at rest and TLS 1.3 in transit. |
| Support | Community support is volunteer-based and free, but the project says it cannot promise response times; commercial providers offer services such as SLAs, training, and migration. | Users without Support Portal access can use documentation, community resources, troubleshooting guides, and tutorials; free-version users are not eligible for Support Portal access. |
| What it does | Apache Hop is a metadata-driven platform for visual data integration, engineering and orchestration using pipelines and workflows. | Prophecy uses AI agents to turn natural-language business goals into visual data preparation workflows and analysis. |
Plans
Prophecy
- StarterFree
- Professional$150 a month
- Enterprise Express$4,000 a month
- EnterprisePriced on request
In their own words
Apache Hop
Apache Hop is an open-source platform for data integration and orchestration. Its visual canvas lets users assemble pipelines, preview rows at individual steps, and watch 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, more than 80 workflow actions, and support for over 40 database dialects. Listed connections include PostgreSQL, MySQL, Oracle, SQL Server, Snowflake, BigQuery, Kafka, Salesforce, SAP, S3, REST, and SFTP. Teams can switch environments when moving projects from development to production and keep credentials outside pipeline definitions. Apache Hop is free under the Apache License 2.0. It runs on Linux, macOS, and Windows; Hop Web works in modern browsers. Release 2.19.0 requires Java 21. Docker images and a Kubernetes Helm chart are available; Hop Web is work in progress and provided as-is.