Registering the Stored Process Metadata

After you write the stored process and define or choose a server, you must register the metadata by using the New Stored Process wizard in SAS Management Console. (SAS Enterprise Guide users can perform the same steps within the SAS Enterprise Guide application.) The New Stored Process wizard can be used to create new stored processes, or you can use the Stored Process Properties dialog box in SAS Management Console to modify existing stored processes. You can specify and manage the following information for stored processes:

Folder

specifies the metadata location where the stored process is registered. The folders are defined in metadata and do not correspond to any physical location. The folder hierarchies that are used for stored processes can also hold other objects such as SAS reports, information maps, and administrative metadata. You can create and modify folders using SAS Management Console.

Name

specifies the stored process name, which acts as both a display label and as part of the URI for the stored process.

Description

specifies an optional text description of the stored process.

Keywords

specifies an optional list of keywords to associate with the stored process. Keywords are arbitrary text strings that are typically used for searching or to indicate specific capabilities. For example, the keyword XMLA Web Service is used to indicate a stored process that can be executed by SAS BI Web Services by using the XMLA calling convention.

Responsibilities

specifies one or more users who are responsible for the stored process. This information is optional.

Hide from user

enables you to hide the stored process from the folder view and search results in a client application. The stored process is hidden only in clients that support this feature. The stored process is hidden from all users, even unrestricted users. The stored process is not hidden in SAS Management Console.

SAS server or Application server

specifies the server or application server context, respectively, that executes the stored process. For more information, see Choosing or Defining a Server.

Server type (available starting with 9.3)

specifies the type of server that runs the stored process that you are defining. If you choose Default server, then either a SAS Stored Process Server or a SAS Workspace Server can be used, depending on which one is available to the client running the stored process. If this option is selected, then the stored process server is used unless the client application specifies to use a workspace server. Select Stored process server only if the stored process uses sessions or if it uses replay (for example, to produce graphics in streaming output). Select Workspace server only if the stored process must be run under the client identity.

Source location and execution (available starting with 9.3)

specifies whether the stored process can be executed on other application servers or only on the selected application server, and where the source code is stored. If you allow the stored process to be executed on other application servers, then the source code is stored in metadata. If you allow execution on the selected application server only, then you must specify whether the source code is stored in metadata or on the application server. If the source code is stored on the application server, then you must specify the source code repository and source file.

Source Code Repository and Source File

specifies the directory and source file that contain the stored process. For more information, see Using Source Code Repositories.

Edit Source Code (or Edit)

enables you to add or edit the source code for the stored process.

Result capabilities (or Results)

specifies the type of output that the stored process can produce. For more information, see Setting Result Capabilities.

Parameters

specifies input parameters or output parameters for the stored process. Parameters are optional. For more information, see Using Input Parameters or Using Output Parameters.

Data Sources and Data Targets

specifies an optional list of data sources and data targets for the stored process. Streams can be used to send data that is too large to be passed in parameters between the client and the executing stored process. Definitions for data sources and data targets can also include an XML schema specification or a data table.

Authorization

specifies access controls for the stored process. Currently only the ReadMetadata and WriteMetadata permissions are honored. A user must have ReadMetadata permission to execute the stored process. WriteMetadata permission is required to modify the stored process definition.

You cannot specify authorization information from the New Stored Process wizard. To specify authorization information, you must open the Stored Process Properties dialog box for an existing stored process.

This metadata is stored on the SAS Metadata Server so that it can be accessed by client applications. For more information about using the New Stored Process wizard or the Stored Process Properties dialog box to create and maintain the metadata defining a stored process, see the Help in SAS Management Console.

Note: Starting with SAS 9.2, you can register and modify the metadata for stored processes programmatically by using a Java API.