MMHeader

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