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.