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.