Skip to content
SPECIFICTION
Get listed

Apache Calcite vs SAS Federation Server

Apache Calcite

calcite.apache.org

SAS Federation Server

support.sas.com

Side by side

FigureApache CalciteSAS Federation Server
Price fromFree—
Free planYes—
Free trial——
Open source——
Web—Yes
Windows—Yes
Linux—Yes
APIYesYes
Self-hostedYesYes
Plans published11
Spec score · Data Federation Software8.1 (#6)7.2 (#19)
Founded20141976
PurposeApache Calcite is a dynamic data management framework that provides components of a database management system while omitting data storage, data processing algorithms, and metadata storage.SAS Federation Server provides scalable, multi-user data access and integrates data from multiple data services.
SecurityApache's Security Team coordinates vulnerability handling for Apache projects, and the project releases fixes through affected package releases.The course describes centralized role-based access, data masking and encryption of personally identifiable information.
SupportThe project directs users to its developers mailing list, Calcite Jira, Stack Overflow, and source code for help.The support page offers a knowledge base, SAS user community and technical support through its support track system.

Plans

Apache Calcite

  • Apache CalciteFree

Apache Calcite pricing →

SAS Federation Server

  • SAS Federation ServerPriced on request

SAS Federation Server pricing →

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.

Visit calcite.apache.org

SAS Federation Server

SAS Federation Server provides multi-user access to data across multiple services through a virtualized layer. It brings separate sources into a federated view, with listed relational database connections for DB2, Oracle, SAP, SQL Server, Teradata, and Greenplum. Federated views can apply data-quality functions such as standardization and parsing. Described performance features include database pushdown, connection pooling, privilege access caching, and in-memory data caching. Security capabilities include centralized role-based access, data masking, and encryption of personally identifiable information. Users can create and share SAS metadata with other SAS solutions, and a Data REST API reference is listed for version 4.6. The most recent releases identified are SAS Federation Server 4.6 and SAS Federation Server Manager 4.6. Server-tier requirements list Oracle Linux 8.10 and 9.1, Red Hat Enterprise Linux 8.10 and 9.1, and SUSE Linux Enterprise Server 15 SP3. SAS names IT administrators, technical users, and business users among its intended audience. Pricing is on request; support includes a knowledge base, user community, and technical support.

Visit support.sas.com