What's New in SAS(R) 9.2

What's New

New Products in SAS 9.2: SAS Table Server

The SAS Table Server is the newest addition to the suite of SAS servers. This new data server provides scalable, threaded, multi-user, and standards-based data access technology in order to process and seamlessly integrate data from multiple data sources.

The SAS Table Server provides the following key benefits:

both user scalability and processing scalability to improve performance.
threaded data access technology that enhances enterprise intelligence and analytical processes. Threaded data access extends the strengths of legacy SAS data access technology by supporting the technology needs of enterprise-class software.
multi-user services that enable multiple clients to access the same data concurrently.
access to multiple types of data, which removes the need for a client to connect to one server for some data and to another server for other data. The SAS Table Server supports SAS files and several third-party relational databases including DB2, MySQL, Oracle, ODBC databases, and Teradata.
a standards-based interface for Structured Query Language (SQL), which defines the data access language for the server. An application creates, requests, and manipulates data with SQL statements. SQL can be submitted by using Table Server SQL (TSSQL), which supports the ANSI SQL:1999 syntax, or by using the SQL dialect that is implemented by a third-party database.
federated queries that reference multiple tables from different data sources, thereby joining disparate data.
security services that ensure that both the server and its data are protected against unauthorized access. The SAS Table Server supports authentication along with configurable single sign-on, authorization processes, and other security features such as the encryption that is supported on SAS servers.

The SAS Table Server provides the following interfaces in order to connect to the server:

For remote clients, the SAS Table Server supports industry standard application programming interfaces (APIs). The server supports APIs for JDBC (Java Database Connectivity), ODBC (Open Database Connectivity), and OLE DB.
The SAS Table Server provides SAS language interfaces that enable connection from a Base SAS session. Rather than process data through legacy SAS data access services, a SAS application can use the SAS Table Server data access technology. The SAS language interfaces include a LIBNAME engine named SASTS, the TSSQL procedure to submit TSSQL statements, and the TSPL procedure to submit Table Server Programming Language (TSPL) statements.