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 services. 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 DB2, Netezza, Oracle, SAP, SQL Server, PostgreSQL, Teradata, and Greenplum.
  • 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. 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 access control with user permissions and data source security. 
The following figure illustrates the architecture of SAS Federation Server:
SAS Federation Server Architecture
SAS Federation Server Architecture
Copyright © SAS Institute Inc. All rights reserved.