SAS 9.1 Companion for Windows (2 Volumes)

Introduction to Using Lotus Notes with SAS

The NOTESDB Engine

SAS provides an access engine, NOTESDB, that enables client users to add new Notes documents to an existing Notes database. This engine is compatible with Lotus Notes R5.

The NOTESDB access engine cannot create a new database and does not provide a way to retrieve information from existing Notes documents. However, the NotesSQL ODBC driver allows for retrieval of data from Notes databases. See 'Retrieving Information from Preexisting Notes Documents' on page 219 for these details.

Do not schedule a program using the NOTESDB engine as a batch job because the server prompts for a password.

Client Requirements

The following are requirements for using Lotus Notes with SAS:

• A client version of Lotus Notes and a valid Notes user ID certification must be installed on the machine that will be using the NOTESDB engine. However, Lotus Notes does not have to be running in order for SAS to access it. You will be prompted for a password to access the Notes server through SAS.

• The Lotus Notes directory must be in the system path. You update the system path by adding to the PATH system environment variable in the Advanced tabbed page of the System Properties dialog box.