Overview

Federation Server virtualizes disparate data sources into a federated view, so users can access combined data without treating every source as a separate destination. Supported relational databases include DB2, Oracle, SAP, SQL Server, Teradata, and Greenplum. That breadth is useful in mixed environments, though buyers should assess their own source requirements before committing.

For performance, the product supports database pushdown, connection pooling, privilege access caching, and in-memory data caching. These mechanisms target the overhead of repeated or distributed data access; they make the product relevant where performance and shared access are operational concerns, not a substitute for evaluating workload fit.

Key features

Governed access: Centralized role-based access, row-level security, data masking, and encryption of personally identifiable information give administrators tools to control sensitive data across the federated layer.
Data quality: Federated views can apply standardization and parsing, allowing teams to address inconsistencies as data is accessed.
SAS workflow support: Users can create and share SAS metadata with other SAS solutions, a practical advantage for organizations already working in the SAS ecosystem.
Interfaces and querying: SQL querying and API access are supported, and a Data REST API reference is available for version 4.6. Query result caching and scheduled queries are also included in the plan.

Pricing

SAS Federation Server is paid software with custom pricing; contact SAS for a quote. There is one plan, SAS Federation Server, with no public price. Organizations should weigh that procurement route against their need for a multi-user federated layer, security controls, and data-quality functions. No cheaper tier is described, so teams seeking a self-serve entry option or a published price should look elsewhere.

Platforms

The product is self-hosted and supports Linux, Windows, web, and API access. The documented server-tier requirements for version 4.6 include Oracle Linux 8.10 and 9.1, Red Hat Enterprise Linux 8.10 and 9.1, and SUSE Linux Enterprise Server 15 SP3. That defined Linux support makes environment compatibility an important deployment check; self-hosted operation will suit organizations prepared to manage infrastructure, not those looking solely for a cloud-hosted service.

The support page identifies SAS Federation Server 4.6 and SAS Federation Server Manager 4.6 as the most recent releases. Support resources include a knowledge base, SAS user community, and technical support through SAS’s support track system.

Who it's for

This is a fit for IT administrators and technical users responsible for access, security, and performance across multiple data services, as well as business users who need governed access to combined data. SAS customers may particularly value the metadata-sharing connection. It is less suitable for teams that need a simple hosted product, want published pricing, or cannot accommodate the specified server environments.

Pros and cons

Pro: A federated view connects varied sources, including several major relational databases, which can reduce the friction of accessing data across a mixed estate.
Pro: Role-based and row-level controls, masking, and encryption address governance needs alongside access.
Pro: Caching, pooling, and database pushdown target performance, while standardization and parsing add data-quality functions to views.
Con: Custom pricing requires a direct sales conversation, limiting quick budget comparisons.
Con: The server tier has specified Linux requirements, so deployment depends on matching supported environments.

Alternatives

For a broader category comparison, explore Data Federation Software and Data Virtualization Software. Retail-focused readers can also browse Retail Assortment Planning Software.

Centric Planning & Pricing is a paid web option with pricing by demo request; consider it when a web-based planning product is a better fit than self-hosted data federation. RELEX Demand Planning is another paid web alternative. Toolio is paid web software with pricing by contact, while Increff Merchandising Software is a paid web option with a free trial and demo request. Retalon Price Management and Optimization is paid web software with pricing by demo request. Style Arcade bases pricing on estimated annual sales orders and number of data sources. AssortSmart is another paid alternative. Board offers paid self-hosted Finance, Supply chain, and Retail plans with customized quotes; consider it when those plan categories better match your needs.

Verdict

Choose SAS Federation Server when your organization needs a governed, performance-conscious layer across varied data sources, especially if SAS metadata sharing matters. Its combination of federation, security, and data-quality capabilities is the central reason to consider it. Look elsewhere if you need published pricing, a simpler hosted deployment, or a server environment outside its supported Linux configurations.

	Ontop	SAS Federation Server
Free plan	No	No
Free trial	No	No
Paid from	—	—
Open source	No	No
Platforms	api, Linux, macOS, self-hosted, Web, Windows	api, Linux, self-hosted, Web, Windows

Ontop vs SAS Federation Server

Ontop

SAS Federation Server