Introduction

SAS Scalable Performance Data (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 the COPY procedure. When the appropriate drivers are installed on the network, SPD Server allows queries on the tables from client machines that do not use SAS software. SPD Server provides the following four connectivity options.
  • ODBC (Open Database Connectivity): ODBC is an interface standard that provides a common interface for accessing databases. Many software applications running in a Windows environment are compliant with ODBC and can access data created by other software. ODBC is a good choice if you have client machines running Windows applications, such as Microsoft Excel or Microsoft Access.
  • JDBC (Java Database Connectivity): Users with browsers can log on to a Web page and make a query. The results of the request are formatted and returned to a Web page. After you install the JDBC driver on SPD Server, all you need is a Web page with some Java code and a client machine with a browser enabled by Java. For this reason, information is available across a wide range of client platforms.
  • htmSQL (HyperText Markup Structured Query Language): Users with browsers can log on to a Web page and make a query. The results of the request are formatted and returned to a Web page. After you install the htmSQL driver in SPD Server, all you need is an htmSQL Web page and a client machine with a browser. For this reason, information is available across a wide range of client platforms.
  • SQL C API: SPD Server tables are accessible from SQL statements that are generated by C/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 ones. This library supports multi-threaded applications and is available on all supported SPD Server platforms.
Note: GUI interfaces might not display all return codes or error messages that the server generates.