SAS Federation Server review
A mature SAS-centered federation server for governed, cross-source SQL access.
Reviewed by iTechGuides Editors · Editorial team · Updated Oct 2026
SAS Federation Server is a server-based data access and virtualization platform for organizations that need to query, combine, and govern data across disparate systems. It is aimed at enterprise data integration, analytics, and governed data access, with support for web, Windows, and Linux environments. FedSQL provides a common SQL syntax across several data sources, while ODBC and JDBC connectivity exposes federated views to applications. The platform also supports object- and row-level security for controlled access.
Pricing and ecosystem fit are central considerations. SAS Federation Server uses contact-sales pricing, so buyers request a quote rather than selecting a published self-service plan. Its drivers and integrations cover SAS data sets, DB2, Greenplum, ODBC, Oracle, Teradata, SAP, SAP HANA, Apache Hive, Netezza, and PostgreSQL. This breadth suits organizations with established SAS environments and mixed relational or distributed data estates. Cached views and materialized cache tables can retain reused query results, while scheduled refreshes use an integrated scheduler and CRON options.
The standout capability is governed federation across varied systems without requiring every query to use a source-specific SQL dialect. Administrators can apply row-level security through predicates and user or group permissions, manage data services through browser-based tools, and monitor access. The result is a focused fit for mature enterprises that need centralized data access controls, cross-source querying, and reusable cached results. Organizations seeking a hosted service, a simpler narrowly scoped connector, or transparent published pricing should consider a different type of tool.
SAS Federation Server pros and cons
- Where it wins
- FedSQL queries across multiple sources with common SQL syntax
- Row-level security with predicates and user or group permissions
- Cached views, scheduled refreshes, APIs, and browser management
- Where it doesn't
- Pricing requires contacting SAS for a quote
- Self-hosted deployment requires server infrastructure
- Its enterprise scope may exceed narrow federation needs
SAS Federation Server fact sheet, pricing and score →
Advertiser disclosure: iTechGuides is reader-supported. Vendors can pay for top positions in our rankings and for a place on other products' pages, and we may earn a commission when you click some links. Bought places stand at the number bought; this page and our disclosure say so. Paying vendors may get a fuller, more detailed review from our editors, and that review can change their score. How we rank.
Last updated · How we research and update