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

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.

Virtual Training nebo e-Learning?

Máme dostatečnou flexibilitu, takže vybírat můžete jak prezenční termíny, tak online kurzy.

Zkuste živý kurz virtuálně

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

Target group

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.

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.
  • Prerequisites

    Jak nás hodnotí

    V čem jsou naše reference výjimečné? Nejsou to jednorázové akce. K nám se lidé vrací rádi a nezavírají před námi dveře.

    Podívejte se na úplný seznam referenčních klientů, kteří na nás nedají dopustit.

    Vaše hodnocení
    *****

    Nejste si jisti, zda je tento kurz pro vás?

    Zavolejte nám a my vám poradíme.

    Jsme vám k dispozici na telefonním čísle +420 222 553 101 vždy od pondělí do pátku: 9:00 - 17:00.

    *položky označené hvězdičkou jsou povinné

    Chcete získat dárek k narozeninám?