Skip to the content
Know your tech before you buy it. Makers: get listed from $49/mo

SAS Federation Server

support.sas.com

  • Windows
  • Linux
  • Web
  • API
  • Self-hosted
6.9 Club score Visit support.sas.com

What SAS Federation Server is

SAS Federation Server provides multi-user data access through a virtualized layer that brings multiple services into a federated view. Listed relational database connections include DB2, Oracle, SAP, SQL Server, Teradata, and Greenplum. Federated views can apply data-quality functions such as standardization and parsing. The described performance tools 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 latest 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 describes the intended audience as IT administrators, technical users, and business users addressing data-access, security, or performance needs. Pricing is on request.

Who it suits

It is aimed at IT administrators, technical users, and business users who need to address data access, security, or performance across multiple sources. Organizations should check the listed server-tier environments against their deployment requirements.

Good to know, and what to watch

  • Unifies multiple data services in a federated view.
  • Lists connections to six relational database systems.
  • Includes role-based access, masking, and PII encryption.
  • Offers a Data REST API reference for version 4.6.
  • Pricing is on request.
  • Server-tier requirements list specific Linux versions.

SAS Federation Server

—

Pricing on request

Getting started

  1. Open the SAS Federation Server support website
  2. Contact SAS to request pricing
  3. Prepare a server tier on Oracle Linux, Red Hat Enterprise Linux, or SUSE Linux Enterprise Server
  4. Install SAS Federation Server and SAS Federation Server Manager
  5. Connect supported relational databases and create federated views
  6. Configure security, data-quality functions, caching, or REST API access

Limits to check

No public price is listed; pricing is on request. The 4.6 server-tier requirements list Oracle Linux 8.10 or 9.1, Red Hat Enterprise Linux 8.10 or 9.1, and SUSE Linux Enterprise Server 15 SP3.

The Club's review

SAS Federation Server is infrastructure for giving multiple users governed access to data spread across different services. It suits IT administrators and technical or business teams that need one controlled layer over established databases. Choose it when federation, security and performance controls matter more than transparent pricing or a lightweight setup.

Overview

The server builds a virtualized data layer that presents disparate sources through a federated view. Relational database support covers DB2, Oracle, SAP, SQL Server, Teradata and Greenplum, a practical match for organizations operating several of those systems at once. It is less compelling when your data estate falls outside those connections or when a simple, single-source query tool is all you need.

Its design is aimed at shared, scalable access rather than an individual analyst working in isolation. SAS users can create and share SAS metadata with other SAS solutions, while a documented Data REST API provides programmatic access. The current releases are SAS Federation Server 4.6 and SAS Federation Server Manager 4.6.

Key features

  • Federated querying: SQL querying across a virtualized view lets users work with combined data without relocating every source. Database pushdown can move suitable work toward the source database, helping avoid unnecessary data movement.
  • Performance controls: Connection pooling, privilege-access caching and in-memory data caching address repeated access and multi-user overhead. They are most valuable in shared operational environments, but workload assessment remains important before deployment.
  • Centralized security: Role-based access and row-level security provide administrator control at the federated layer. Data masking and encryption of personally identifiable information add protection for sensitive fields, making the platform a better fit for governed data access than an unmanaged collection of direct connections.
  • Data quality in views: Standardization and parsing functions can be applied within federated views, allowing inconsistent values to be addressed as data is accessed rather than only in a separate preparation process.
  • SAS interoperability: Shared SAS metadata supports organizations already using other SAS solutions, reducing the separation between federation work and the wider SAS environment.
  • Operational access: A REST API supports integration scenarios, and scheduled queries suit recurring retrieval workflows. These capabilities matter to technical teams building repeatable access patterns rather than occasional ad hoc analysis.

Pricing

SAS Federation Server uses paid, custom pricing. The SAS Federation Server plan has no public price; prospective customers need to contact SAS. That model can accommodate enterprise scope and deployment requirements, but it prevents straightforward budget comparison and makes the product a poor fit for buyers who need an immediately purchasable, fixed-cost service.

Platforms

Deployment is self-hosted, with API and web access and support for Windows and Linux environments. For the server tier in version 4.6, supported systems include Oracle Linux 8.10 and 9.1, Red Hat Enterprise Linux 8.10 and 9.1, and SUSE Linux Enterprise Server 15 SP3. The Linux requirements and self-managed operating model suit organizations with infrastructure and administration capacity; teams looking for a vendor-run cloud service should consider alternatives instead.

Who it's for

SAS positions the product for IT administrators, technical users and business users dealing with security, performance and data-access issues. It is a strong candidate for enterprises consolidating access to several supported relational databases, especially where row-level controls, masking, caching and SAS integration are operational requirements. It is not the natural choice for a small team seeking a low-cost, no-administration analytics tool.

Pros and cons

Pros

  • Broad supported database mix: DB2, Oracle, SAP, SQL Server, Teradata and Greenplum can be brought into one federated access layer.
  • Serious governance controls: Role-based and row-level security, masking and PII encryption address sensitive-data access directly.
  • Performance-oriented architecture: Pushdown, pooling and caching target common costs in shared, distributed access.
  • SAS ecosystem fit: Shared metadata and a REST API support integration with SAS solutions and custom applications.

Cons

  • Custom pricing: No public price makes initial budgeting and comparison harder.
  • Self-hosted responsibility: Buyers must operate a supported server environment, including the specified Linux versions.
  • Enterprise-oriented scope: Its governance and infrastructure focus can be excessive for simple or single-database use cases.

Alternatives

For a broader market view, compare Data Virtualization Software and Data Federation Software. If the primary need is merchandising rather than governed data access, Retail Assortment Planning Software is the more relevant category.

  • Circana Liquid Activation is a paid web platform with a free trial, better suited to buyers wanting a trial-based, browser-accessible option.
  • Increff Merchandising Software is a paid cloud SaaS platform with a free trial and demo-led purchasing, fitting merchandising teams rather than self-hosted federation projects.
  • Flowlity offers a free trial and a €249.00-per-month Lite plan for up to 5,000 SKUs with CSV upload and no ERP integration; choose it for a bounded, subscription-based planning use case.
  • NIQ is a paid, multi-platform product with no free plan, suited when its broader platform coverage matches the requirement.
  • Assortment.AI is a paid API and web product sold through a demo.
  • Centric Planning & Pricing is a paid web product with demo-based pricing.
  • RELEX Demand Planning is a paid web platform for demand-planning needs.
  • SAP Retail is a paid option spanning self-hosted and many client platforms, with a private-edition contract running one to five years.

Verdict

Choose SAS Federation Server if your organization needs a self-hosted, governed access layer across supported databases and already values SAS integration. Its main reason to choose is the combination of federation, security and performance controls; its main reason to look elsewhere is custom pricing and the operational burden of managing the server environment.

The verdict

SAS Federation Server is a data-access layer for organizations working across disparate sources, with described controls for security and performance. The listed server requirements and on-request pricing are important factors when considering deployment.

Questions people ask

What does SAS Federation Server do?

It provides scalable, multi-user access to data from multiple services through a virtualized layer that creates federated views.

Which databases are listed as supported?

The listed relational databases are DB2, Oracle, SAP, SQL Server, Teradata, and Greenplum.

Is SAS Federation Server self-hosted?

Yes. Self-hosted deployment is listed, with server-tier requirements for Oracle Linux 8.10 or 9.1, Red Hat Enterprise Linux 8.10 or 9.1, and SUSE Linux Enterprise Server 15 SP3.

Does it provide API access?

Yes. SAS lists a SAS Federation Server 4.6 Data REST API reference, along with API access as a product capability.

How is pricing handled?

The SAS Federation Server plan has no public price; pricing is available on request.

What security features are described?

The described controls include centralized role-based access, data masking, and encryption of personally identifiable information.

What the maker publishes

Audience
SAS describes the intended audience as IT administrators, technical users and business users who need to address security, performance and data-access issues. source
Current release
The support page identifies SAS Federation Server 4.6 and SAS Federation Server Manager 4.6 as the most recent releases. source
Database connections
The product page lists DB2, Oracle, SAP, SQL Server, Teradata and Greenplum as supported relational databases. source
Data quality
Federated views can apply data quality functions such as standardization and parsing. source
Founded
1976 source
Founded
1976 source
Headquarters
Cary, North Carolina, USA source
Headquarters
Cary, North Carolina, USA source
Purpose
SAS Federation Server provides scalable, multi-user data access and integrates data from multiple data services. source
Querying and performance
The course describes database pushdown, connection pooling, privilege access caching and in-memory data caching for improving data access performance. source
REST API
The support page lists a SAS Federation Server 4.6 Data REST API reference. source
SAS integration
The course says users can create and share SAS metadata with other SAS solutions. source
Security
The course describes centralized role-based access, data masking and encryption of personally identifiable information. source
Support
The support page offers a knowledge base, SAS user community and technical support through its support track system. source
Supported environments
The 4.6 system 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 for the server tier. source
Virtualization
It creates a virtualized data layer that unifies disparate sources into a federated view. source

Checked against the maker's pages on 29 Sept 2026.