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.

Deploying a Job With SAS Federation Server Connections

If you have SAS Federation Server installed, you must define its connections in 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.

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 Connection

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. Make sure that the directory contains the SAS Federation Server data source name file.
  3. Locate the etc directory in the SAS Data Management Server installation menu path.
  4. Paste the SAS Data Management Studio dftkdsn directory and the SAS Federation Server data source name file that it contains into the SAS Data Management Server etc directory.