Call : (+91) 968636 4243
Mail : info@EncartaLabs.com
EncartaLabs

SAS Federation Server - Accessing and Virtualizing Enterprise Data

( Duration: 2 Days )

This SAS Federation Server - Accessing and Virtualizing Enterprise Data training course provides skills to create a virtualized data layer that unifies disparate data sources into a federated view providing federated data as a service (DaaS).

By attending SAS Federation Server - Accessing and Virtualizing Enterprise Data workshop, delegates will learn 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.

  • Familiar with creating data connections to SAS data sets and relational databases in SAS and third-party applications.
  • Able to write simple queries in SQL or possess equivalent knowledge.

The SAS Federation Server - Accessing and Virtualizing Enterprise Data class is ideal for:

  • 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 AGENDA

1

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
2

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
3

Creating Federation SQL Views, Caches, and DS2 Queries

  • Creating FedSQL views
  • Caching FedSQL views for performance and availability
  • SAS DS2 on SAS Federation Server
  • Data quality on SAS Federation Server
4

Working with SAS Federation Server Security

  • Authentication and authorization
  • Role-based permissions and privileges
  • Data masking and row-level filtering
  • Auditing, logging, and compliance
  • Data transmission encryption
5

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
6

SAS Federation Server Performance Considerations

  • Introduction to caching
  • Resource caching and information views
  • Data caching
  • Connection pooling
  • SQL logging and server encryption

Encarta Labs Advantage

  • One Stop Corporate Training Solution Providers for over 6,000 various courses on a variety of subjects
  • All courses are delivered by Industry Veterans
  • Get jumpstarted from newbie to production ready in a matter of few days
  • Trained more than 50,000 Corporate executives across the Globe
  • All our trainings are conducted in workshop mode with more focus on hands-on sessions

View our other course offerings by visiting https://www.encartalabs.com/course-catalogue-all.php

Contact us for delivering this course as a public/open-house workshop/online training for a group of 10+ candidates.

Top
Notice
X