The following figure
provides a logical view of using Oracle as a data source and connecting
to the database with a
SAS/ACCESS ODBC interface.
Setting up a connection
from SAS to an Oracle database management system by using ODBC is
a three-stage process:
-
Define an ODBC data
source.
-
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
with the standard installation wizard for the database client. Before
you begin, satisfy the following prerequisites:
-
installation of
SAS/ACCESS Interface
to ODBC. For configuration information, go to 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 if your ODBC driver requires a client. Refer to the
ODBC driver vendor's documentation to determine whether an Oracle
client is required.
-
validation that the Oracle client
can communicate with the Oracle server.
-