SAS Institute. The Power to Know

Add an OLE Database Connection by Using ArcMap

Because SAS and ArcGIS exchange data using an OLE protocol, each SAS library is treated as an OLE database. Therefore, to exchange data you must first add an OLE database connection to ArcGIS's list of database connections. Even if you have not previously added an OLE database connection using ArcCatalog, you can add one using ArcMap while you are within the process of adding or joining SAS data to ArcMap.

You can do one of the following:

Connect to a Local SAS Server

  1. Select Database Connections from the menu in the Add Data window.
  2. Double-click Add OLE DB Connection.
  3. Select SAS IOM Data Provider 9.x from the Provider tab of the Data Link Properties window.
  4. Select the Connection tab and specify _local_ in the Data Source field.
    This specifies that the SAS libraries are on the same machine as ArcCatalog.
  5. Click OK to add an OLE DB Connection.odc entry to your Add Data window.
    Note: The default name for an OLE connection is OLE DB Connection.odc. Additional connections are identified by number, for example, OLE DB Connection(2).odc.
  6. Double-click OLE DB Connection.odc to connect.


Connect to a Remote SAS Server by Using the SAS IOM Data Provider 9.2

When you connect to a remote SAS server, SAS Bridge for ESRI makes a request to an object spawner on the server. The object spawner starts a SAS session that listens for further requests from the SAS Bridge for ESRI.
To connect to a remote SAS server using ArcCatalog:

  1. Select Database Connections from the menu in the Add Data window.

  2. Double-click Add OLE DB Connection.

  3. Select SAS IOM Data Provider 9.2 from the Provider tab of the Data Link Properties window.
    Note: To connect to a remote SAS server, the object spawner must be running on the remote machine. If you cannot connect to the remote SAS server, then contact your system administrator for assistance.

  4. Select the Advanced tab.

  5. Deselect the Use default box, and then specify the following information:

    Metadata Server Location specifies the machine name where the SAS Metadata Server is running
    User name specifies the user name that is used to access the metadata server
    Password specifies the password for the metadata server
    Data Source specifies the SAS Workspace Server that SAS Bridge for ESRI interacts with. Select the server that you want to use from the drop-down list.
    User name specifies the user name that is used to access the workspace server
    Password specifies the password for the workspace server

  6. Click OK to add an OLE DB Connection entry to your catalog.
    Note: The default name for an OLE connection is OLE DB Connection.odc. Additional connections are identified by number, for example, OLE DB Connection(2).odc. You can rename a connection to something more easily recognizable by right-clicking on the name and selecting Rename.

  7. Right-click OLE DB Connection.odc and select Connect from the pop-up menu.

Connect to a Remote SAS Server by Using the SAS 9.1 IOM Data Provider

When you connect to a remote SAS server, SAS Bridge for ESRI makes a request to an object spawner on the server. The Object Spawner starts a SAS Object Server that listens for further requests from the SAS Bridge for ESRI.
To connect to a remote SAS server:

  1. Select Database Connections from the menu in the Add Data window.

  2. Double-click Add OLE DB Connection.

  3. Select SAS IOM Data Provider 9.1 from the Provider tab of the Data Link Properties window.
    Note: To connect to a remote SAS server, a SAS IOM Data Provider must already be running. If you cannot connect to the remote SAS server, contact your system administrator for assistance.

  4. Select the Connection tab and specify any name (other than _local_ ) in the Data Source field.

  5. Enter your user ID and password.

  6. Identify your SAS server, making sure that the SAS Protocol is ProtocolBridge.Your system administrator should provide you with the necessary information. A list of SAS OLE DB connections that you define in ArcCatalog is presented to you in ArcMap to choose from when you add data from, or export data to, a SAS data set.

  7. Click OK to add an OLE DB Connection entry to your catalog.
    Note: The default name for an OLE connection is OLE DB Connection.odc. Additional connections are identified by number, for example, OLE DB Connection(2).odc.

  8. Double-click OLE DB Connection.odc to connect.