SAS(R) Federation Server: Accessing and Virtualizing Enterprise Data

Course Details
Code: DIFD42
Tuition (USD): $1,600.00 • Classroom (2 days)
$1,600.00 • Virtual (2 days)
Course Details
GSA (USD): $2,176.32 • Classroom (2 days)
$2,176.32 • Virtual (2 days)

SAS Federation Server makes it easier for business users to access secure data for reporting and analysis. It provides a virtual layer or view, giving users the appropriate level of control without physically moving data. This frees up IT staff to focus on other tasks by giving them a simple method of sharing data using a centralized, governed security layer

The self-study e-learning includes:

  • Annotatable course notes in PDF format.
  • Virtual Lab time to practice.

Skills Gained

  • maintain, configure, and monitor data access from a single point of administration in a web browser interface
  • create a virtualized data layer that unifies disparate data sources into a federated view providing federated data as a service (DaaS)
  • improve data access performance by using database pushed capabilities, connection pooling, privilege access caching, and in-memory data caching capabilities
  • provide centralized security of sensitive data using role-based data access for groups and users, along with data masking and encryption of personally identifiable information (PII)
  • create and share SAS metadata with other SAS solutions for easier integration
  • apply data quality functions such as standardization and parsing in federated views in a consistent form to support data governance initiatives
  • leverage SAS In-Database technologies to run SAS DS2 code and analytical scoring model inside the database for improved performance.

Who Can Benefit

  • IT administrators and technical users who need to address business issues such as security, performance, and data access, as well as business users, who will become more empowered to control and manage their data


  • Before attending this class, you should
  • be familiar with creating data connections to SAS data sets and relational databases in SAS and third-party applications
  • be able to write simple queries in SQL or have equivalent knowledge.

Course Details

Introduction to Data Federation

  • what is data federation?
  • data federation and data warehouse relationship
  • course logistics

Understanding the Technology and Architecture

  • introduction to SAS Federation Server
  • SAS Federation Server architecture and installation
  • SAS Federation Server Manager interface
  • interaction with the SAS Metadata Server
  • steps to ensure proper data access

Configuring Data Services and Connections

  • introduction to data services and connections
  • connecting to SAS data sets
  • connecting to relational databases
  • connecting to remote SAS Federation Servers
  • configuring the Memory Data Store (MDS)
  • creating federated data connections
  • connecting to additional data sources

Creating Federation SQL Views, Caches, and DS2 Queries

  • introduction to SAS Federation SQL views
  • definer’s rights versus invoker’s rights
  • creating FedSQL views
  • caching FedSQL views for performance and availability considerationsl
  • SAS DS2 on SAS Federation Server
  • data quality on SAS Federation Server

Working with SAS Federation Server Security

  • introduction to the SAS Federation Server security framework
  • authentication and authorization
  • role-based permissions and privileges
  • data masking and row-level filtering
  • auditing, logging, and compliance
  • data transmission encryption

Accessing Data on SAS Federation Server Data

  • introduction to accessing SAS Federation server data
  • access in DataFlux Data Management Studio
  • programming access in SAS code
  • access in SAS platform applications
  • programming access using REST API
  • third-party access using Federation Server client drivers

SAS Federation Server Performance Considerations

  • introduction to SAS Federation Server performance
  • resource caching and information views
  • connection pooling
  • SQL logging and server encryption