What’s New in SAS Scalable Performance Data Server 5.3

Overview

SAS Scalable Performance Data (SPD) Server 5.3 includes support for secure sockets communication, a new language driver, and documentation enhancements.

Secure Sockets Communication

SPD Server supports secure sockets communication by using Transport Layer Security (TLS), the successor to Secure Sockets Layer Security (SSL). TLS and SSL are cryptographic protocols that are designed to provide communication security. TLS and SSL provide network data privacy by encrypting client/server communication. In addition, TLS performs client and server authentication, and it uses message authentication codes to ensure data integrity. For more information, see Configuring Secure Sockets Communication.

New Language Driver

The new language driver enables users to read and write SPD Server tables with the SAS DS2 Language and the SAS FedSQL Language, both of which were introduced with SAS 9.4. The driver is enabled in SPD Server SAS clients by specifying the LIBGEN=YES option in the SPD Server LIBNAME statement. Users submit DS2 language statements to the server by using the DS2 procedure. Users submit FedSQL language statements by using the FEDSQL procedure. For more information, see Using the SAS DS2 and FedSQL Languages with SPD Server in SAS Scalable Performance Data Server: User’s Guide.

SAS Federation Server Support for SPD Server Tables

Beginning in February of 2017, SPD Server tables can be accessed for reading, writing, and update by SAS Federation Server. SAS Federation Server is a data server that provides scalable, threaded, multi-user, and standards-based data access technology in order to process and seamlessly integrate data from multiple data sources. The server acts as a hub that provides clients with data by accessing, managing, and sharing SAS data as well as several popular relational databases. SAS Federation Server enables powerful querying capabilities, as well as centralized data source management. With SAS Federation Server, you can efficiently unite data from many sources, without moving or copying the data. For more information about how SPD Server tables are accessed with SAS Federation Server, see SAS Federation Server: Administrator’s Guide.

Documentation Enhancements

Beginning in SPD Server 5.3, the documentation for configuring and using SPD Server on Hadoop is contained it its own document: SAS Scalable Performance Data Server: Processing Data in Hadoop.
In addition, SAS Scalable Performance Data Server: Administrator’s Guide and SAS Scalable Performance Data Server: User’s Guide have been modified as follows:
  • The administrator’s guide has been reorganized to distinguish between installation, basic configuration, security, advanced configuration tasks, and system management tasks.
    The system management section includes reference information about SPD Server utilities. This includes information about the psmgr utility, which is used to create and maintain the SPD Server password database. See Password Database Utility. It also includes information about the SPDO procedure, which serves as the operator interface for SPD Server. In previous server releases, information about the SPDO procedure was divided between the user’s guide and the administrator’s guide. See SPDO Procedure.
  • The user’s guide has been reorganized into the following sections: Introduction, Getting Started, SPD Server SQL Processor, Optimizing SPD Server Queries, SPD Server Reference, and ODBC and JDBC Clients.
    The user’s guide now provides reference as well as usage information about the SPD Server LIBNAME statement. See Connecting to the Server in SAS Scalable Performance Data Server: User’s Guide and SPD Server LIBNAME Statement in SAS Scalable Performance Data Server: User’s Guide.
    In addition, the user’s guide now provides reference information about explicit pass-through statements and server-specific SQL statements. See Explicit Pass-Through SQL Statements in SAS Scalable Performance Data Server: User’s Guide and SPD Server SQL Statement Additions in SAS Scalable Performance Data Server: User’s Guide.
  • SAS Scalable Performance Data Server: Administrator’s Guide also has the following enhancements:
Copyright © SAS Institute Inc. All Rights Reserved.
Last updated: February 3, 2017