Overview

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, Oracle, SAP, SQL Server, 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, Federation Server SQL (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.

Integration with SAS DataFlux Data Management Studio and Web Studio

SAS Federation Server is a product that can be used by DataFlux Data Management Studio and Data Management Server. The following figure illustrates the DataFlux Data Management Platform architecture, with SAS Federation Server as a single point of access to provide multiple client applications with data from different sources:

DataFlux Data Management Studio Architecture