Presto vs Spotfire Data Virtualization
Presto
prestodb.github.io
Spotfire Data Virtualization
spotfire.comSide by side
| Figure | Presto | Spotfire Data Virtualization |
|---|---|---|
| Price from | Free | — |
| Free plan | Yes | — |
| Free trial | — | Yes |
| Open source | — | — |
| Web | Yes | Yes |
| Windows | — | Yes |
| macOS | Yes | — |
| Linux | Yes | Yes |
| API | Yes | Yes |
| Self-hosted | Yes | Yes |
| Plans published | 1 | 1 |
| Spec score · Data Federation Software | 7.7 (#11) | 7.6 (#13) |
| Deployment | The documentation describes installing Presto from a server tarball and deploying it with Homebrew, Docker, or Helm. | Spotfire data virtualization can be deployed on-premises, in private or public clouds, and in containerized environments such as Kubernetes and Docker. |
| Security | Documented security options include Kerberos, LDAP, password-file authentication, access control, secure internal communication, and OAuth 2.0 authentication. | The data virtualization datasheet describes authentication, authorization, encryption, fine-grained access controls, traceability, and uniform policies across data sources. |
| What it does | Presto is a distributed SQL query engine for querying large datasets across heterogeneous data sources. | Spotfire Enterprise Advanced Data Services virtualizes data across sources so teams can access and query distributed data without replication. |
Plans
Spotfire Data Virtualization
- Spotfire Enterprise Advanced Data ServicesPriced on request
In their own words
Presto
Presto is an open-source distributed SQL query engine for working with large datasets across different data sources. Its ANSI SQL interface can query information where it is stored and combine data from multiple sources in one query, for both interactive and batch workloads. The project lists ad hoc queries, reporting and dashboards, and open lakehouse workloads among its uses. Documented connectors include BigQuery, Cassandra, Delta Lake, Elasticsearch, Hive, Iceberg, Kafka, MongoDB, MySQL, PostgreSQL, and Redis. Presto can be installed from a server tarball or deployed with Homebrew, Docker, or Helm. Security options include Kerberos, LDAP, password-file authentication, access controls, secure internal communication, and OAuth 2.0. Users can work through its CLI or Console, connect with DBeaver or Tableau, use Java, Python, Go, or JavaScript clients, or access the REST API. The project is free and open source, overseen by the Presto Foundation, which describes it as independent of any single company. The documentation identifies release 0.299, while the getting-started page still refers to version 0 from June 2022.
Spotfire Data Virtualization
Spotfire Data Virtualization has no write-up on Specifiction yet; its figures are above.