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 client on the network that has a browser. In addition, you must have SPD Server tables available for use somewhere on the network, htmSQL loaded and configured on a UNIX or Windows operating system, and SPD Server and SPD Server SNET server running.
Why 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 Use htmSQL?

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 running 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. You have UNIX, Windows PCs, and workstations. The clients might have browser access to your corporate intranet.
  • Users of the information understand browsing and want point-and-click access to the information.
  • 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 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 same time the SPD Server is installed. Instructions for installing htmSQL are included in the SPD Server installation package.
  • htmSQL must be installed on the Web server. You need the name of a data source that points to the SPD Server SNET server and to the specific LIBNAME domain that contains the SPD Server data that you are interested in.

How Is htmSQL Set Up on the Client?

On the network or Web client, nothing more than a browser is required.
htmSQL Configured on an SPD Server Client
htmSQL Configured on an SPD Server Client

How Do I Use htmSQL to Make a Query?

  1. Log on to the Web and enter the URL for the Web page that contains the htmSQL code.
  2. Click on the information.
  3. htmSQL handles the request, formats the information, and returns the results to the Web page.

Examples of Setting Up an htmSQL Web Page

SAS has a Web site that explains how to set up htmSQL Web pages. In some cases, there are references to SAS/SHARE. The rules for setting up htmSQL for SPD Server or SAS/SHARE are basically the same.
The Web site is located at http://support.sas.com/rnd/web/intrnet/htmSQL/index.html.
Copyright © SAS Institute Inc. All rights reserved.