SAS Companion for the Microsoft Windows Environment

Using the SAS UODBC Driver to Access SAS Data from Other Applications

The SAS Universal ODBC (UODBC) driver is an implementation of the open database connectivity (ODBC) standard that enables you to obtain read-only access to SAS data sources. Data sources include SAS data sets, catalogs, consolidation databases, multi-dimensional databases, and JMP data.

The SAS UODBC driver does not require the SAS System in order to access SAS data. It is useful when read-only access to SAS data is required, but the power of the data manipulation capabilities of the SAS ODBC driver is not needed. A typical use of UODBC is on an Internet WEB page for sharing read-only real-time data.

For information about how to access data from other Windows applications that comply with the UODBC standard, see the SAS online Help.

The SAS UODBC driver supports these data access methods:

Direct: enables the driver to be configured to open a data source by accessing the file that is either on the driver's local machine or on a network drive that is attached to the driver's local machine.
FTP: enables users to access SAS data files that are stored on a File Transfer Protocol (FTP) server. The UODBC driver can be configured to log in to the server, if necessary.
HTTP: enables users to access SAS data files that are stored on a WEB server that supports the Hypertext Transfer Protocol (HTTP). The UODBC driver can be configured to log in to the server, if necessary.

The SAS UODBC driver is not included as part of base SAS , but it is available as a separate product. For evaluation purposes, a trial version of the driver may be downloaded from SAS Institute at http://www.sas.com.

For details about installing the SAS UODBC Driver, see the installation documentation for the SAS System under Windows.

Chapter Contents
Previous
Next
Top of Page