Using htmSQL to Access SPD Server Tables

Read this section if you do not have Base SAS software on the network client, but you want to use the point-and-click convenience of a Web page to query SPD Server tables from any browser-enabled client on the network. You must have SPD Server tables available for use, htmSQL loaded and configured on a UNIX or Windows operating system, and Scalable Performance Data Servers and SPD SNET servers running.

Why Would I Want to Use htmSQL?

How Is htmSQL Set Up on the Server?

How Is htmSQL Set Up on the Client?

How Do I Use htmSQL to Make a Query?

Examples of Setting Up an htmSQL Web Page

Why Would I Want to Use htmSQL?

You might want to use htmSQL if you have SPD Server tables available on your network and one or more of the following is true:

You do not have Base SAS software on the network client to process the data sets.
You want to distribute the information across your corporate intranet through a Web page.
The clients on your network are varied: UNIX boxes, Windows PCs, and workstations. One thing they might have in common is browser access to your intranet.
The audience for the information understands Web browsing and wants point-and-click access to the data.
You would like to use the JDBC option to extract the information but cannot permit Java applets to run on your network browsers.
You want to distribute the information over the World Wide Web.
Your developers are familiar with SQL and HTML.

How Is htmSQL Set Up on the Server?

htmSQL is usually set up on the server at the time the SPD Server is installed. The process is covered in the SPD Server installation manual.
htmSQL must be installed on the Web server and you need the name of a data source that points to the SPD SNET server and to the specific LIBNAME domain that contains the SPD Server data you are interested in.

How Is htmSQL Set Up on the Client?

HtmSQL requires nothing more than a browser on the network or Web client.

htmSQL Configured on an SPD Server Client

How Do I Use htmSQL to Make a Query?

Log on to the World Wide Web and enter the URL for the Web page that contains the htmSQL code.
Click on the desired information.
htmSQL handles the request, formats the information, and returns the result to the Web page.

Examples of Setting Up an htmSQL Web Page

SAS Institute maintains a Web site that explains the technical details of setting up htmSQL Web pages. In some cases, there are references to the SAS/SHARE product. The rules for setting up htmSQL for either the SPD Server or SAS/SHARE are virtually the same.

The SAS Institute Web page for htmSQL is http://support.sas.com/documentation/cdl/en/htmsql/59546/HTML/default/main_contents.htm