Introduction

About SAS Federation Server

SAS Federation Server is a data server that provides scalable, threaded, multi-user, and standards-based data access technology in order to process and seamlessly integrate data from multiple data sources. The server acts as a hub that provides clients with data by accessing, managing, and sharing SAS data as well as several popular relational databases.
SAS Federation Server enables powerful querying capabilities, as well as improved data source management. With SAS Federation Server, you can efficiently unite data from many sources, without moving or copying the data.
SAS Federation Server provides the following data capabilities:
  • A central location for setup and maintenance of database connections.
  • Access to popular database systems including IBM DB2®, Netezza, Oracle®, SAP®, SAP Hana®, Microsoft® SQL Server®, PostgreSQL®, Teradata®, and Greenplum®.
  • Access to distributed storage with the SAS Federation Driver for Apache HiveTM.
  • ODBC and native drivers to connect to select data sources.
  • Threaded data access technology that enhances enterprise intelligence and analytical processes.
  • Multi-user services that enable multiple clients to access the same data concurrently.
  • Ability to reference data from disparate data sources with a single query, known as data federation. SAS Federation Server also includes its own SQL syntax, Federated Query Language (FedSQL), to provide consistent functionality – independent of the underlying data source.
  • A data abstraction layer, providing the ability to present a consistent data model throughout the organization. This is accomplished through the use of FedSQL views.
  • Data source access control that includes user permissions and row-level security. 
The following figure illustrates the architecture of SAS Federation Server:
SAS Federation Server Architecture
Federation Server Architecture
Copyright © SAS Institute Inc. All Rights Reserved.
Last updated: March 6, 2018