Data Transfer Using Web Services 

Purpose

You can generate Web services to load data based on function modules for XML DataSources. In this way, you can send data to the delta queue of SAP BW using the Web service. The Web services provide you with WSDL descriptions that can be used technologically independently of the push of data to SAP BW.

The BW server SOAP interface can ensure guaranteed delivery, since an XML message is returned to the client whether successful or not. If the client has an error or no message (for example, update termination when sending a success message), the client can send the data again.

However, it can then ensure the no guaranteed delivery only once function, since there is no reconciliation on a transaction-ID level. On this basis you can determine that a data package was sent again “in error” and cannot be posted again. The update to an ODS object can, if the deltas with after-images (delta process AIM) are created, consistently deal with the data that is sent too often, as long as the serialization is secured.  The serialization is the task of the client.

Prerequisites

You are familiar with the Web service standards and technology.

Process

...

       1.      Create a DataSource based on a file-data source. When you generate the DataSource, an RFC-capable function module is generated for data transfer. You can find more information under XML DataSource and Creating XML DataSources.

       2.      Activate the data transfer to the delta queue of SAP BW by initializing the delta process. You can find more information under Activating Data Transfer to the Delta Queue.

       3.      You create an (ABAP) Web service for the previously generated function module and release it for SOAP runtime. You can find more information under Creating Web Services for Loading Data

Result

You can now use the Web service to send data to the delta queue of SAP BW. From there, you can collect the data using the usual staging methods for deltas in SAP BW and then post it to the data targets.

A WSDL description of the Web service, along with a test function to call the Web service is available in the Administration for SOAP Runtime (transaction WSADMIN).