Apache Calcite vs Enterprise Enabler

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.

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.