Apache Drill vs Spotfire Data Virtualization
Apache Drill
drill.apache.org
Spotfire Data Virtualization
spotfire.comSide by side
| Figure | Apache Drill | Spotfire Data Virtualization |
|---|---|---|
| Price from | Free | — |
| Free plan | Yes | — |
| Free trial | — | Yes |
| Open source | — | — |
| Web | — | Yes |
| Windows | Yes | Yes |
| macOS | Yes | — |
| Linux | Yes | Yes |
| API | Yes | Yes |
| Self-hosted | Yes | Yes |
| Plans published | 1 | 1 |
| Spec score · Data Federation Software | 9.0 (#1) | 7.6 (#13) |
| Spec score · Data Virtualization Software | 9.0 (#2) | 7.6 (#14) |
| Deployment | Drill can run embedded on a laptop or in distributed mode on a cluster of servers. | 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 features include Kerberos, username and password authentication, Digest authentication, authorization and user impersonation. | The data virtualization datasheet describes authentication, authorization, encryption, fine-grained access controls, traceability, and uniform policies across data sources. |
| Support | The project directs questions to its drill-dev mailing list and welcomes contributions. | Spotfire provides a support portal, knowledge base, product documentation, and a community discussion forum. |
| What it does | Apache Drill is a schema-free SQL query engine for Hadoop, NoSQL databases, and cloud storage. | 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
Apache Drill
Apache Drill is a schema-free SQL query engine for Hadoop, NoSQL databases, and cloud storage. It can query raw data where it resides without first loading it, defining schemas, or transforming it. Its JSON data model supports complex and nested structures, and a single query can join data across multiple datastores. Listed sources include HBase, MongoDB, HDFS, Amazon S3, Azure Blob Storage, Google Cloud Storage, Swift, NAS, and local files. JDBC and ODBC drivers connect Drill to tools including Tableau, Qlik, MicroStrategy, Spotfire, SAS, and Excel; developers can also use its REST API in custom applications. Drill can run embedded on a laptop or in distributed mode on a server cluster, and the homepage lists Mac, Windows, and Linux. Documented security options include Kerberos, username and password authentication, Digest, authorization, and impersonation. The software is free under Apache License 2.0. A compatibility limit: official support for Hadoop 2 and Java 8 was dropped with Drill 1.22.0.
Spotfire Data Virtualization
Spotfire Data Virtualization has no write-up on Specifiction yet; its figures are above.