Connecting to Common Data Sources

Overview of SAS/ACCESS Connections to RDBMS

This section provides generic instructions for using SAS Management Console to configure access to a database. SAS/ACCESS must be licensed and configured before using SAS Management Console to register the library that holds the tables. The generic procedure has two stages:

To register a DBMS server, perform the following steps:

Right-click Server Manager and select the New Server option to access the New Server wizard.
Select the database server type from the Database Servers list. Then, click Next.
Enter an appropriate server name in the Name field. Click Next.
Accept the defaults for the server properties. Click Next.
Specify the database vendor-specific values on the connection properties page. If the user credentials for the database are different from the credentials used to log in to SAS, then you must create an Authentication domain to store valid database credentials. For more information, see How to Store Passwords for a Third-Party Server in the SAS Intelligence Platform: Security Administration Guide.

Click Next.
Examine the final page of the wizard to ensure that the proper values have been entered. Click Finish to save the wizard settings.

To register a DBMS library, perform the following steps:

In SAS Management Console, expand Data Library Manager. Right-click Libraries and select the New Library option to access the New Library wizard.
Select the database type from the Database Data list. Click Next.
Enter an appropriate library name in the Name field. Click Next.
Select an application server from the list, and use the right arrow to assign the application server. This step makes the library available to the server and makes the library visible to users of the server. Click Next.
Specify a libref on the library properties page. You can also click Advanced Options to perform tasks such as pre-assignment. Pre-assigning a library is valuable if your clients include SAS Enterprise Guide or SAS Add-In for Microsoft Office. For more information, see Assigning Libraries. Click Next to access the next page of the wizard.
On the server and connection page, select the database server from the previous stage. Contact your database administrator if you are unsure of the correct value for the schema field. Click Next.
Examine the final page of the wizard to ensure that the proper values have been entered. Click Finish to save the library settings. At this point, you can register tables, as explained in Registering and Verifying Tables.

Top of Page