Overview

The server creates a virtualized layer that presents disparate sources through a federated view. It supports DB2, Oracle, SAP, SQL Server, Teradata and Greenplum relational databases, making it relevant to organizations with data spread across those systems. The mix of sources and workloads still matters: this is a platform to evaluate against an organization’s own access needs, not a universal connector layer.

Performance features include database pushdown, connection pooling, privilege access caching and in-memory data caching. Together, these target the cost of repeated or distributed access. They are useful capabilities for multi-user environments, though they do not remove the need to assess fit for actual workloads.

Key features

Centralized security: Role-based access, row-level security, data masking and encryption of personally identifiable information give administrators controls over access to sensitive data through the federated layer.
Data quality: Federated views can apply standardization and parsing. This can address inconsistent values as data is accessed, rather than limiting the product to connectivity.
SAS integration and API: Users can create and share SAS metadata with other SAS solutions, and a Data REST API reference is available for version 4.6. The integration is a stronger fit for organizations already using SAS than for buyers seeking a standalone planning product.
Query and planning: The plan includes SQL querying, query result caching, scheduled queries and API access. It also lists size and color, location, seasonal, scenario, open-to-buy and channel planning, which may suit retail planning workflows alongside its data-access role.

Pricing

SAS Federation Server: custom pricing; contact SAS for a quote. The paid plan is self-hosted and includes SQL querying, query result caching, row-level security, API access and scheduled queries, as well as the listed retail planning capabilities. The breadth may appeal to teams looking to combine governed data access with planning, but the absence of a public price means buyers must establish cost directly with SAS. No lower-priced or free tier is given.

Platforms

SAS Federation Server is offered for self-hosted deployment and supports API, Linux, web and Windows platforms. For the server tier, version 4.6 requirements include Oracle Linux 8.10 and 9.1, Red Hat Enterprise Linux 8.10 and 9.1, and SUSE Linux Enterprise Server 15 SP3. Those specific Linux requirements make environment compatibility a practical early checkpoint for organizations planning deployment.

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, a SAS user community and technical support through SAS’s support track system.

Who it's for

This is aimed at IT administrators and technical or business users addressing data access, performance and security across multiple services. It is a sensible candidate when teams need a governed virtualized data layer, especially if they also use SAS metadata or need the listed data-quality functions. Organizations without a Linux server environment to match the requirements, or those that need transparent pricing before evaluation, may find it a poor starting point.

Pros and cons

Pro: A federated view across supported relational databases can unify access without requiring users to treat each source as a separate destination.
Pro: Role-based and row-level controls, masking and encryption address sensitive-data governance, while standardization and parsing add data-quality functions.
Pro: Caching, connection pooling and database pushdown target performance concerns in shared data access.
Con: Custom pricing requires direct engagement with SAS, complicating early budget comparisons.
Con: The server’s stated 4.6 environments are specific Linux distributions and versions, so compatibility needs checking before deployment.

Alternatives

For a broader category comparison, browse Data Federation Software or Data Virtualization Software. Retail-focused buyers can also compare the Retail Assortment Planning Software category.

NIQ is a paid option on Android, iOS, API, web and Windows; consider it when those platform choices better match your needs.
Assortment.AI is a paid API and web option with pricing not listed and a demo booking path, making it an alternative for buyers evaluating a demo-led purchase.
Centric Planning & Pricing is a paid web option with pricing not listed and a demo request path.
Increff Merchandising Software is a paid web cloud SaaS platform with a free trial and demo request option.
RELEX Demand Planning is a paid web alternative for buyers considering another web-based option.
Retalon Price Management and Optimization is a paid web option with pricing not listed and demos by request.
Style Arcade is a paid web option whose price depends on estimated annual sales orders and number of data sources.
Toolio is a paid web option; contact Toolio to learn more.

Verdict

Choose SAS Federation Server if your organization needs a self-hosted, governed federated data layer across supported databases, with performance and data-quality functions in the same platform. Its main drawbacks are custom pricing and specific server-tier requirements, so buyers prioritizing clear upfront costs or a simpler deployment should compare alternatives.

	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