Apache Calcite vs Spotfire Data Virtualization
Apache Calcite
calcite.apache.org
Spotfire Data Virtualization
spotfire.comSide by side
| Figure | Apache Calcite | Spotfire Data Virtualization |
|---|---|---|
| Price from | Free | — |
| Free plan | Yes | — |
| Free trial | — | Yes |
| Open source | — | — |
| Web | — | Yes |
| Windows | — | Yes |
| Linux | — | Yes |
| API | Yes | Yes |
| Self-hosted | Yes | Yes |
| Plans published | 1 | 1 |
| Spec score · Data Federation Software | 8.1 (#6) | 7.6 (#13) |
| Adapters | Listed adapters include Arrow, Cassandra, CSV, Druid, Elasticsearch, JDBC, MongoDB, Redis, Spark, and Splunk. | The data virtualization datasheet says the product includes 300+ adapters and can extend its adapter library through JDBC, ODBC, ADO.NET, REST, and SOAP APIs. |
| Founded | 2014 | 1996 |
| Security | Apache's Security Team coordinates vulnerability handling for Apache projects, and the project releases fixes through affected package releases. | The data virtualization datasheet describes authentication, authorization, encryption, fine-grained access controls, traceability, and uniform policies across data sources. |
| Support | The project directs users to its developers mailing list, Calcite Jira, Stack Overflow, and source code for help. | Spotfire provides a support portal, knowledge base, product documentation, and a community discussion forum. |
Plans
Spotfire Data Virtualization
- Spotfire Enterprise Advanced Data ServicesPriced on request
In their own words
Apache Calcite
Apache Calcite is a free, open-source data management framework for applications that need database-management components without built-in storage. It provides an industry-standard SQL parser, validator, and JDBC driver. Queries are represented as relational algebra, then transformed with planning rules and a cost model for optimization. Calcite can mediate between applications and several storage locations or processing engines, and can push computation to a source database. Listed adapters include Arrow, Cassandra, CSV, Druid, Elasticsearch, JDBC, MongoDB, Redis, Spark, and Splunk. Its JDBC driver supports local connections and remote connections using JSON over HTTP or Protobuf over HTTP. Calcite is available as source and through Maven, for API or self-hosted use. Build prerequisites include Git and Java JDK 8u220 or later, with Java 11 preferred. It does not store data; each source must be registered through a schema or adapter.
Spotfire Data Virtualization
Spotfire Data Virtualization has no write-up on Specifiction yet; its figures are above.