Databases Reference
In-Depth Information
￿ SAS Enterprise Guide, an integrated solution for authoring, editing, and testing
stored processes.
￿ SAS Information Map Studio, an application that can be used to implement
information map data sources. Stored processes can use the full power of SAS
procedures and the DATA step to generate or update the data in an information
map.
￿ SAS Information Delivery Portal, a portal that provides integrated Web access to
SAS reports, stored processes, information maps, and channels.
￿ Stored Process Service, a Java API that enables you to execute stored processes
from a Java program.
￿ SAS Stored Process Web applications, Java Web applications that can execute
stored processes and return results to a Web browser.
￿ SAS BI Web Services, a Web service interface to SAS stored processes.
Prerequisites for Stored Processes
SAS Data Integration Studio enables administrators to generate a stored process for
a job. Code is generated for the stored process, and the generated code is saved to a file.
Metadata about the stored process is saved in the current metadata repository. The
stored process feature in SAS Data Integration Studio requires the following
components:
￿ A SAS Stored Process Server. For details about how this server is installed and
configured, see the SAS Intelligence Platform: Administration Guide .
￿ A source repository for the stored processes that are generated from SAS Data
Integration Studio jobs.
A source repository is a location, such as a directory, that contains stored processes.
Users who will execute stored processes must have the appropriate access rights to the
source repository, as defined by the operating system. The stored process feature in
SAS Data Integration Studio is typically used in conjunction with the Stored Process
Manager plug-in to SAS Management Console. The Stored Process Manager plug-in
can be installed with SAS Foundation Services.
To use the stored process feature to your best advantage, you should be familiar with
stored process parameters, input streams, and result types. For a detailed discussion of
stored processes, see the SAS stored processes section in the SAS Integration
Technologies: Developer's Guide .
Preparation
It is assumed that the prerequisites for stored processes have been met. You must
have write access to the source repository for the stored processes that are generated
from SAS Data Integration Studio jobs.
You cannot generate a stored process for a job unless your metadata profile enables
you to connect to SAS Data Integration Studio without change-management control.
For details about administrative profiles, see “Creating a Metadata Profile (for
Administrators)” on page 58.
Generate a Stored Process for a Job
Follow these steps to generate a stored process for a job:
1 Start SAS Data Integration Studio. A window displays that has various options
for maintaining a metadata profile.
 
Search WWH ::




Custom Search