SAS Scalable Performance
Data (SPD) Server provides ODBC, JDBC,, 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.
-
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.