SAS® Federation Server: Accessing and Virtualizing Enterprise Data
3h 55m + Hands-On Practice
Available in:
SAS® Federation Server: Accessing and Virtualizing Enterprise Data
DIFD : DIFDSV
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.
Learn How To
- 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 Should Attend
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
Prerequisites
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 possess equivalent knowledge.
SAS Products Covered
DataFlux Data Management Studio;SAS Data Integration Studio;Base SAS;SAS Enterprise Guide;SAS Federation Server
Course Outline
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.
- 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.
- Introduction.
- Creating FedSQL views.
- Caching FedSQL views for performance and availability.
- SAS DS2 on SAS Federation Server.
- Data quality on SAS Federation Server.
- Introduction.
- Authentication and authorization.
- Role-based permissions and privileges.
- Data masking and row-level filtering.
- Auditing, logging, and compliance.
- Data transmission encryption.
- 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.
- Introduction.
- Introduction to caching.
- Resource caching and information views.
- Data caching.
- Connection pooling.
- SQL logging and server encryption.
Live Class Schedule
Duration: 14 hours
Step into our live classes and experience a dynamic learning environment where you can ask questions, share ideas, and connect with your instructor and classmates. With on-demand lab hours, you can explore the material at your own pace. Our globally acclaimed instructors will motivate you to think bigger, so you can take what you've learned and achieve your biggest goals.
This course isn't publicly scheduled, but private training and mentoring may be available. Contact us to explore options.
Private Training
Get training tailored specifically for your team, led by expert SAS instructors. Choose from virtual sessions, or training at your location (or ours). Perfect for teams seeking a customized curriculum and plenty of interaction with a SAS specialist. We'll schedule it at a time that works for you.
Mentoring Services
Take your training to the next level with personalized mentoring. While private training offers structured coursework, mentoring provides hands-on, real-time support from a subject matter expert. As you work with your own data, you'll receive expert guidance to help you uncover insights, unlock the full potential of your data, and make faster progress. Perfect for those looking to apply what they’ve learned and see quicker results.