Mapping Your Web Service Operations

The wizard that creates a Web service from relational sources understands the business logic used and is able to build the entire SQL transformation. Mapping a Web service operation to an XML document, however, involves some knowledge—and work—on the part of the user to complete the transformation. In particular, the SQL transformations for Web service operations generated via the "Create Web Service Model from WSDL" scenerio are incomplete. The generated SQL template does contains a placeholder which you can modify to represent actual data.

Below is an example of a generated SQL transformation template:

SELECT * FROM CheckOrderSvcResponses.Service1Soap_CheckOrder_OCout WHERE (CheckOrderSvcResponses.Service1Soap_CheckOrder_OCout.REPLACE_WITH_ELEMENT_OR_ATTRIBUTE = VARIABLES.ORDERDATE)

To complete the transformation, replace the "REPLACE_WITH_ELEMENT_OR_ATTRIBUTE" string with full XML Document path name to desired element or attribute (see below)

SELECT * FROM CheckOrderSvcResponses.Service1Soap_CheckOrder_OCout WHERE (CheckOrderSvcResponses.Service1Soap_CheckOrder_OCout.OC_Output.CONTAINER.ORDER_DATE = VARIABLES.ORDERDATE)

Related Topics

> Creating Web Service Models

> Creating Web Service from XML Schema

> Getting Started with MetaMatrix Dimension

(c) Copyright © 2000-2006 MetaMatrix, Inc. All rights reserved.
Visit http://www.metamatrix.com