SAS Scalable Performance Data Server 4.5 Administrator'S Manual Download Page 100

Page: 100 / 271

SPD Server can read tables exported from Base SAS software using PROC COPY, and,
with the proper drivers installed on the network, allows queries on the tables from client
machines that do not have SAS software.

There are four possible options:

•

ODBC:

Open Database Connectivity - This is an interface standard that provides a

common interface for accessing databases. Many software 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:

Java Database Connectivity - 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 makes information available across a wide range of client platforms
because all you need, after installing the JDBC driver on SPD Server, is a Web page
with some Java code, and a client machine with a Java-enabled browser.

•

htmSQL:

HyperText Markup Structured Query Language - 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 makes information available across a wide
range of client platforms. Why? After installing the htmSQL driver in SPD Server, all
you need is an htmSQL Web page and a client machine with a browser.

•

SQL C API:

This option allows access to SPD Server tables from SQL statements

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 is designed to support 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.

Using Open Database Connectivity (ODBC) to
Access SPD Server Tables

Read this section if you do not have Base SAS software on the network client, but you want
to access SPD Server tables on the network, using an ODBC compliant program, such as
Microsoft Word, Query, Excel, or Access, and you have SPD Server tables available for
use, somewhere on the network, or Scalable Performance Data Servers and SPD SNET
servers running, or client machines in a Windows environment.

Why Use ODBC?

You have SPD Server tables available on your network, and one or more of the following
might be true:

•

You do not have Base SAS software running on the Windows client, but you need to
view or change SPD Server tables.

•

You need to view or change the SPD Server tables using a Microsoft spreadsheet,
database or word processor.

•

You need to view or change SPD Server tables in ways that cannot be predetermined
or programmed into a Web page.

Chapter 9 • Using SPD Server With Other Clients