SAS 9.1.3 Integration Technologies » Administrator's Guide (LDAP Version)


Stored Processes
Creating a Stored Process Path
Creating a Stored Process Object
Stored Processes

Creating a Stored Process Object

To enable a stored process to be invoked in an application, you can use IT Administrator to create metadata that defines the name of the stored process and provides information about associated parameters. For general instructions on using IT Administrator, see Using IT Administrator.

To create a new stored process object using IT Administrator:

  1. Open IT Administrator.

  2. Select Applications in the Manager Bar.

  3. Select the Stored Process Paths folder in the tree view.

  4. Select the node representing the stored process path for the new stored process. If the path is a folder, open the folder and select any stored process node beneath the folder.

  5. If you are creating the first stored process under the selected stored process path, you must select File arrow New arrow Stored Process in order to create the process. Otherwise, click the New button (New). The New Stored Process window appears requesting property information for the new stored process.

  6. Enter the name and description of the process. This information identifies the process in the directory. In the SAS Stored Process section, enter the following

    Descriptive Label
    A short label for the stored process. If you specify a value for this field, you must also specify a value for the File field.
    File
    The name of the stored SAS program. If you specify a value for this field, you must also specify a value for the Descriptive Label field.
    Portal JSP
    The java server page used to access the program

    In the Parameters field, enter the parameters that are passed to the SAS program upon execution. You can have more than one parameter set.

    Valid parameters are:

    DATA_SOURCE
    Specifies the distinguished name of a data source used to generate a list of valid values for the parameter. Used together with the REPORT_QUERY parameter.
    DEFAULT_VALUE
    Specifies the default value for the parameter.
    DESCRIPTION
    Provides a description of the parameter.
    LABEL
    Specifies the label to display when the user sees the parameter.
    NAME
    Specifies the name of the parameter.
    REPORT_QUERY
    An SQL statement used together with DATA_SOURCE to generate a list of valid values for the parameter.
    REQUIRED
    Specifies whether the parameter is required (value is true) or not required (value is false).
    VALUES
    List the possible values for the parameter. If VALUES is not specified, DATA_SOURCE and REPORT_QUERY are used to generate the list.

  7. When you are finished entering information in the fields, click OK. The new stored process appears in the tree view.

    If the OK button remains gray, check the Descriptive Label and File fields. You must either enter values in both fields or neither field. If you enter a value in one field but not the other, the OK button will remain grayed.

To modify or view details about a stored process using IT Administrator:

  1. Open IT Administrator.

  2. Select Applications in the Manager Bar.

  3. Expand the Stored Process Paths folder, then select the stored process whose details you want to modify or view. The properties appear in the properties area.

    The properties area displays these fields

    Description
    A description of the stored process
    File
    The name of the stored SAS program
    Portal JSP
    The java stored page used to access the program
    Descriptive Label
    A short description of the process
    Parameters
    The parameters that are passed to the SAS program upon execution. You may have more than one set of parameters for each stored process. To add a parameter set, select the Add button. The Add Value dialog box appears, in which you can add the new parameter set. Select a parameter set and select the Edit button to change the parameter values, or Remove to remove the set.

  4. When you are finished, select the Save button (Save) to save the changes to the server. If you attempt to navigate to another object, the administrator application will prompt you to save any changes you made to the process.