SAS Federation Server
support.sas.com
- Windows
- Linux
- Web
- API
- Self-hosted
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.
Plans
Every plan and priceSAS Federation Server
Pricing on request
Getting started
- Open the SAS Federation Server support website
- Contact SAS to request pricing
- Prepare a server tier on Oracle Linux, Red Hat Enterprise Linux, or SUSE Linux Enterprise Server
- Install SAS Federation Server and SAS Federation Server Manager
- Connect supported relational databases and create federated views
- 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.