Skip to content
SPECIFICTION
Get listed

Presto vs SAS Federation Server

Presto

prestodb.github.io

SAS Federation Server

support.sas.com

Side by side

FigurePrestoSAS Federation Server
Price fromFree—
Free planYes—
Free trial——
Open source——
WebYesYes
Windows—Yes
macOSYes—
LinuxYesYes
APIYesYes
Self-hostedYesYes
Plans published11
Spec score · Data Federation Software7.7 (#11)7.2 (#19)
SecurityDocumented security options include Kerberos, LDAP, password-file authentication, access control, secure internal communication, and OAuth 2.0 authentication.The course describes centralized role-based access, data masking and encryption of personally identifiable information.

Plans

Presto

  • Presto open-source projectFree

Presto pricing →

SAS Federation Server

  • SAS Federation ServerPriced on request

SAS Federation Server pricing →

In their own words

Presto

Presto is an open-source distributed SQL query engine for working with large datasets across different data sources. Its ANSI SQL interface can query information where it is stored and combine data from multiple sources in one query, for both interactive and batch workloads. The project lists ad hoc queries, reporting and dashboards, and open lakehouse workloads among its uses. Documented connectors include BigQuery, Cassandra, Delta Lake, Elasticsearch, Hive, Iceberg, Kafka, MongoDB, MySQL, PostgreSQL, and Redis. Presto can be installed from a server tarball or deployed with Homebrew, Docker, or Helm. Security options include Kerberos, LDAP, password-file authentication, access controls, secure internal communication, and OAuth 2.0. Users can work through its CLI or Console, connect with DBeaver or Tableau, use Java, Python, Go, or JavaScript clients, or access the REST API. The project is free and open source, overseen by the Presto Foundation, which describes it as independent of any single company. The documentation identifies release 0.299, while the getting-started page still refers to version 0 from June 2022.

Visit prestodb.github.io

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