If you want to invoke a stored
process using the XMLA Web service, you must use
XMLA
Web Service
as a keyword and
Stream
as the stored process output type when defining the stored process.
On the client side, perform the following steps to use XMLA Web services:
-
Locate the Web Service
Description Language (WSDL) file. You can access the WSDL for a SAS
BI Web Service by appending
'?WSDL'
onto
the service endpoint.
-
Write the code for the
client application that uses either the Discover method or the Execute
method to call the Web service.
-
For XMLA Web services, the SAS code that implements the
Web service, the metadata, and the client code that calls the Web
service must all be synchronized. The following table shows how to
synchronize these items:
Items to Synchronize
|
|
|
|
|
The name of the file
that contains the SAS code.
|
Associates a SAS Stored
Process with the name of the file containing the SAS program. Alternatively,
in SAS 9.3, the SAS program can be included directly in metadata.
|
<StoredProcess
name=
'MyStoredProcess'>
|
|
Reads XML from the fileref.
|
The name of the fileref,
which must match the name of the data source. In this case, the name
of the fileref is instream.
|
<Stream
name='instream'
XML input stream
provided by client...
</Stream>
|
|
|
The parameter name is
specified in the metadata. Parameters are validated for proper typing,
but they are treated as strings on the server regardless of the type
that is specified in the metadata.
|
<Parameter
name='tablename'>
value</Parameter>
|
|
Writes output to the
_WEBOUT fileref as XML.
libname _WEBOUT
xml xmlmeta=
&_XMLSCHEMA;
|
Designates the output
as 'Streaming'.
|
Uses the XML that is
returned.
|