Target group
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
Course structure
Introduction to Data Federation
- Introduction to data federation.
- Features of SAS Federation Server.
- Architecture and installation.
- Interaction with SAS Metadata Server.
- SAS Federation Server Manager interface.
- 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 other 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.
- Creating FedSQL views.
- Caching FedSQL views for performance and availability.
- SAS DS2 on SAS Federation Server.
- Data quality on SAS Federation Server.
Working with SAS Federation Server Security
- Introduction.
- Authentication and authorization.
- Role-based permissions and privileges.
- Data masking and row-level filtering.
- Auditing, logging, and compliance.
- Data transmission encryption.
Accessing SAS Federation Server Data
- Introduction to accessing SAS Federation Server data.
- Accessing federated data in DataFlux Data Management Studio.
- Programming access in SAS code.
- Access in SAS Platform applications.
- Programming using the REST API.
- Third-party access using SAS Federation Server Client drivers.
SAS Federation Server Performance Considerations
- Introduction.
- Introduction to caching.
- Resource caching and information views.
- Data caching.
- Connection pooling.
- SQL logging and server encryption.
