SAS® Federation Server Features

Virtualized data layer

  • Federated data source names (DSNs) allow users to access multiple data sources via the same connection.
  • JDBC and ODBC drivers help third-party applications query federated data.
  • Federated data as a service (DaaS) simplifies data access and allows web-based query submission, server and database discovery via a robust REST interface.
  • Shared metadata allows for easier integration with other SAS solutions.

Single point of administration

  • Web-based administration console for improved governance.
  • Query builder graphically creates materialized views.
  • A scheduler helps manage and schedule data cache refreshes.
  • Capability to enable or disable data caches.
  • Options to monitor current and historical session status.

Improved performance

  • Supports data caching of materialized views to reduce loads on operational systems.
  • Supports connection pooling between the federation server and source data systems.
  • Includes support for statement pooling from the federation server JDBC driver.
  • Lets you combine multiple data sources and write to SASHDAT to simplify and speed data preparation for visual analytics.
  • Incorporates advanced data manipulations that can run inside the database, such as data cleansing, merging and scoring.
  • Runs SAS DS2 code inside the database if in-database technologies are installed.

Data masking for more security & auditability

  • Allows you to define access permissions for a user or group at the catalog, schema, table, column and row levels.
  • Includes support for definer’s rights views as well as user and group functions.

On-demand data quality

  • Apply data quality functions like match-code generation, parsing, and gender or identification analysis inside the view.
  • Take advantage of SAS In-Database Technologies to run functions inside the database for improved performance.