Managing Stored Process Metadata

Choosing or Defining a Server

Types of Servers That Host Stored Processes

You must choose a server to host your stored process. Servers are defined in metadata and are actually logical server definitions that can represent one or more physical server processes. There are many options, including pre-started servers, servers that are started on demand, and servers that are distributed across multiple hardware systems. You can use the Server Manager in SAS Management Console to create or modify server definitions. For more information about server configurations, see the SAS Intelligence Platform: Application Server Administration Guide.

Because the logical server description in metadata hides the server implementation details, a stored process can be moved to or associated with any appropriate server without modifying the stored process. Moving a stored process from one server to another requires changing only the metadata association and moving the source code, if necessary. A stored process is the combination of a SAS program, the server that hosts that program, and the metadata that describes and associates the two. It is not possible to create a stored process that is associated with more than one server, although it is possible to create stored processes that share the same SAS program or source file.

Stored processes can be hosted by two types of servers: SAS Stored Process Servers and SAS Workspace Servers. The two servers are similar, but they have different capabilities and they are targeted at different use cases.

SAS Stored Process Server

The SAS Stored Process Server is a multi-user server. A single server process can be shared by many clients. The recommended load-balancing configuration enables client requests to be serviced by multiple server processes across one or more hardware systems. This approach provides a high-performance, scalable server, but it imposes some restrictions. Because the same server handles requests from multiple users, it cannot easily impersonate a user to perform security checks. By default, the server runs under a single, shared user identity (defined in metadata) for all requests. All security checks based on client identity must be performed in the stored process. For more information about stored process server security, see the SAS Intelligence Platform: Application Server Administration Guide.

The stored process server implements several features that are not available on the workspace server, including streaming output (see Setting Result Capabilities) and sessions (see Using Sessions). Stored process Web services are supported on the stored process server only.

SAS Workspace Server

The SAS Workspace Server is a single-user server. A new server process is started for each client. This approach is not as scalable as the load-balanced stored process server, but it has a major security advantage. Each server is started under the client user identity and is subject to host operating environment permissions and rights for that client user. The workspace server also provides additional functionality, including data access and execution of client-submitted SAS code. For more information about workspace server security, see the SAS Intelligence Platform: Application Server Administration Guide.

Some features that are available on the stored process server are not available on the workspace server, as described in the previous section. Information map stored processes are supported only on the workspace server.

Top of Page