Overview

This chapter describes using SAS Scalable Performance Data (SPD) Server to connect with ODBC, JDBC, htmSQL, and SQL C API clients.
SPD Server provides ODBC, JDBC, htmSQL, and SQL C API access to SPD Server data stores from all supported platforms.
SPD Server can read tables exported from Base SAS software using PROC COPY. With the proper drivers installed on the network, SPD Server allows queries on the tables from client machines that do not have SAS software.
There are four possible options.
  • ODBC: This is an interface standard that provides a common interface for accessing databases. Many applications running in a Windows environment are compliant with this standard and can access data created by other software. This is a good choice if you have client machines running Windows applications, such as Microsoft Excel or Microsoft Access.
  • JDBC: This option allows users with browsers to log on to a Web page and make a query. The results of the request are formatted and returned to a Web page. This functionality makes information available across a wide range of client platforms because all that you need after installing the JDBC driver on SPD Server is a Web page with Java code and a client machine with a browser enabled by Java.
  • htmSQL: This option allows users with browsers to log on to a Web page and make a query. The results of the request are formatted and returned to a Web page. This functionality makes information available across a wide range of client platforms because all that you need after installing the htmSQL driver in SPD Server is a client machine with a browser.
  • SQL C API: This option allows access to SPD Server tables from SQL statements generated by C and C++ language applications. This access is provided in the form of a C language run-time access library. This library provides a set of functions that you can use to write custom applications to process SPD Server tables and to generate new tables. This library is designed to support threaded applications and is available on all supported SPD Server platforms.
Note: GUIs might not display all return codes or error messages that SPD Server generates.