What's New in SAS Federation Server 4.1

Overview

The following new features are available in SAS Federation Server 4.1:
  • There are four new SAS Federation Server drivers:
    • SAS Federation Server Driver for SAP HANA
    • SAS Federation Server Driver for Netezza
    • SAS Federation Server Driver for PostgreSQL
    • SAS Federation Server SASHDAT Data Source Driver
  • data masking function to protect sensitive data
  • SQL scripting for SAS Federation Server administration
  • API support for interacting with and managing SAS Federation Server using a REST interface

New Drivers for SAS Federation Server

SAS Federation Server Driver for SAP HANA

The SAS Federation Server Driver for SAP HANA enables Read and Write access to SAP HANA data sources. The driver supports both native SQL and FedSQL dialects. The SAS Federation Server Driver for SAP HANA is also available as a data service in SAS Federation Server Manager. For additional information, see SAP HANA Driver Reference .

SAS Federation Server Driver for Netezza

The SAS Federation Server Driver for Netezza enables SAS Federation Server to create, read, update, and drop Netezza tables. The driver supports both native SQL and FedSQL dialects. The SAS Federation Server Driver for Netezza is also available as a data service in SAS Federation Server Manager. For additional information, see Netezza Driver Reference.

SAS Federation Server Driver for PostgreSQL

The SAS Federation Server Driver for PostgreSQL enables SAS Federation Server to create, read, update, and drop PostgreSQL tables. The driver supports both native SQL and FedSQL dialects. The SAS Federation Server Driver for PostgreSQL is also available as a data service in SAS Federation Server Manager. For additional information, see PostgreSQL Driver Reference.

SASHDAT Data Source Driver

The SAS Federation Server Driver for SASHDAT is a write-only driver designed for use with Hadoop on SAS LASR Analytic Server. SAS LASR Analytic server integrates Hadoop by storing SAS data in the Hadoop Distributed File system (HDFS). Using the SAS Federation Server Driver for SASHDAT, you can create files in the SASHDAT format in HDFS. These files can later be quickly loaded into the SAS LASR Analytic server for processing. The SAS Federation Server Driver for SASHDAT is also available as a data service in SAS Federation Server Manager. For additional information, see SASHDAT Driver Reference.

Data Masking

SAS Federation Server delivers a new data masking function as a method of ‘de-identifying’ sensitive information within data sources. The purpose of data masking is to protect the original data by using a functional substitute in situations where the audience is not privileged to access the original data. The primary focus of data masking is to protect data that is classified as personally identifiable information (PII). For additional information, see Data Masking.

SQL Scripting for SAS Federation Server

SAS Federation Server provides SQL language scripting capabilities to handle administrative needs for start-up and shutdown events. SQL scripts, executed at start-up or shutdown, manage auditing or related event notifications. Administrators can also manage content of in-memory MDS tables to a persistent data store when the server is stopped, as shown in the Example SQL Script.

REST Interface for SAS Federation Server

SAS Federation Server delivers a new API that provides a simple method to access data on SAS Federation Server. The API is implemented as a REST interface that provides direct interaction with SAS Federation Server, including metadata and data queries and SQL submissions. The SQL can include SAS Federation Server administration DDL or queries, DML, and DDL for back-end data sources. With the REST interface, you can perform the following tasks:
  • Discover servers and data sources that are accessible through SAS Federation Server.
  • Submit ad hoc queries for execution.
  • Operate on query results.
The API is supported through a Java mid-tier service that communicates with SAS Federation Server through the JDBC driver. This service is delivered as a single WAR file that is deployed as part of the SAS Federation Server Manager installation. The WAR file does not depend on the SAS middle tier or use SAS WIP services.
The API provides examples of all media formats used, with in-line examples for collection objects of known media types. The collection usage indicates the media type that is used. Templated resource values are based on names of resources within the data architecture of SAS Federation Server. Resources might change during operations as data is manipulated. (for example, dropping or adding a table). The API returns a data element by name as it exists at the time of a request, so this information should be considered as requests are processed. This information should also be considered when designing a consuming application. For additional details, see the documentation delivered with the REST interface.