Apache Drill vs Enterprise Enabler

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.

Enterprise Enabler 10 is data integration middleware for connecting IT and business users to data held across different sources. Its transformation engine can federate live data from multiple systems and transform it without staging it in a physical or virtual database. A data catalog provides another way to search within the product, and lineage traces a dataset’s origin, destination, formulas, business rules, and intervening steps. Fast Virtualization uses drag and drop to create virtual models for BI reports, web services, and applications. Data masking and obfuscation control partial or full user views; the product page says these features support GDPR compliance, row-level security, and column-level security. Listed relational integrations include Oracle RDBMS, Microsoft SQL Server, IBM DB2, MySQL, and PostgreSQL. Deployment options include on-premise, cloud, hybrid, and a cloud edition designed to run without extra installation and setup. Stone Bond Technologies offers a no-cost trial, with setup instructions sent by email. AWS Marketplace bundles are billed per hour: EE 10 Bundle A is $2.17 a month for 3 data sources, and Bundle B is $8.50 a month for 12.