The following figure
provides a logical view of using Oracle with
SAS/ACCESS as a data
source.
Setting up a connection
from SAS to a database management system is a two-stage process:
-
Register the database
server.
-
Register the database
library.
This example shows the
process for establishing a SAS connection to an Oracle database. It
assumes that the software for the database has already been loaded
by using the standard installation wizard for the database client.
The following prerequisites have been satisfied:
-
installation of
SAS/ACCESS Interface
to Oracle. For configuration information, see the Install Center at
http://support.sas.com/documentation/installcenter/93 and use the operating system and SAS version to locate
the appropriate SAS Foundation Configuration Guide.
-
installation of a supported Oracle
Database Client.
-
validation that the Oracle client
can communicate with the Oracle server.
-