Accessing SAS Federation Server Connections

Overview

The SAS Federation Server is a scalable data server that uses threaded, multi-user, standards-based technology to integrate heterogeneous data sources. The server acts as a hub that provides clients with data by accessing, managing, and sharing SAS data as well as several third-party relational databases.

Using a SAS Federation Server connection in SAS Data Management Studio

SAS Federation Server connections are defined for SAS Metadata Server. These connections are defined using SAS Management Console. When you log in to SAS Data Management Studio using a SAS Metadata Server that contains a SAS Federation Server connection definition, you can access that SAS Federation Server in the Data Connections pane:

  1. Select the Data riser in Data Management Studio.
  2. Select Data Connections.
  3. Select a SAS Federation Server to view defined DSN connections.

SAS Federation Server connections are defined for SAS Metadata Server. These connections are defined using SAS Management Console. If you log in to SAS Data Management Studio using a SAS Metadata Server that contains a SAS Federation Server connection definition, you can access that SAS Federation Server in the Data Connections pane. The Data Connections pane is located in the Data riser.

For information about logging on SAS Data Management Studio, see Log On to SAS Data Management Studio. See the documentation page for SAS Federation Server for more information about SAS Federation Server.

Deploying a Job With SAS Federation Server Connections

You can deploy a SAS Data Management Studio job to a SAS Data Management Server for execution, as described in Deploying Jobs to a SAS Data Management Server. However, you must perform the additional configuration on the SAS Data Management Server whenever the job accesses data through a connection specified in a SAS Federation Server. This configuration enables the SAS Data Management Server to recognize and access the SAS Federation Server.

Perform these steps:

  1. Locate the etc directory in the SAS Data Management Studio installation menu path.
  2. Locate and copy the dftkdsn directory that is installed under etc.
  3. Locate the etc directory in the SAS Data Management Server installation menu path.
  4. Paste the SAS Data Management Studio dftkdsn directory into the SAS Data Management Server etc directory.