Transferring Transaction Data Using Web Services (RDA) 

Use

If you want to use data that is not available in SAP source systems for operational reporting, use a Web service to transfer the data into the BI system.

Procedure

The procedure describes the data transfer to a standard DataStore object. There are no activation steps or activation requests for write-optimized DataStore objects.

...

       1.      Create a Web service DataSource.

See Creating DataSources for Web Services.

       2.      Implement the Web service in your application.

       3.      Create a DataStore object.

See Creating DataStore Objects.

       4.      Create a transformation with the DataSource as the source and the DataStore object as the target.

See Creating Transformations.

       5.      If you still want to process the data and write it to other InfoProviders after the real-time data acquisition process has finished, create the relevant InfoProviders and transformations.

       6.      Create and save an InfoPackage for the DataSource for real-time data acquisition..

PSA requests for Web services remain open across several load processes. When you transfer data using Web services, you use this type of InfoPackage to define the size of the request or the time lapsed before the request is closed.

Once you have saved it, the InfoPackage and its DataSources appear in the monitor for real-time data acquisition (transaction RSRDA) under Unassigned Objects.

See Creating InfoPackages for Real-Time Data Acquisition.

       7.      If you want to connect processing and updating steps with real-time data acquisition and have created the relevant objects in step 5, create a process chain for this purpose here. In the start process for the chain, select the scheduling option By Metachain or API, activate the chain and schedule it.

See Creating Process Chain.

       8.      Create a data transfer process (DTP) for real-time data acquisition with the DataSource as the source and the DataStore object as the target.

See Creating Data Transfer Processes for Real-Time Data Acquisition.

       9.      Switch from the DTP to the monitor for real-time data acquisition.

To do this, choose  Assign Daemon in the Execute tab page on the DTP maintenance screen.

The Monitor for Real-Time Data Acquisition appears. The DTP is displayed under Non-Assigned Objects under the DataSource that you created the InfoPackage for. The DataSource is thus assigned.

You can update the data from the DataSource into multiple DataStore objects. In this case, assign the corresponding data transfer process to the daemon that has  been created (using the DataSource). To do this, choose Assign DTP in the context menu for the DataSource,

   10.      If required, create a new daemon by pressing  Create Daemon.

   11.      Assign the DataSource (and thus the InfoPackage and the DTP) to the daemon.

To do this, select the DataSource in Non-Assigned Nodes, choose Assign Daemon in the context menu for the DataSource and enter the daemon number. The InfoPackage and the DTP can now be processed by the daemon.

   12.      If you have created a process chain, assign this to the data transfer process.

To do this, choose Assign Subsequent Process Chain in the context menu for the DTP.

You can assign more than one subsequent process chain to a data transfer process.

   13.      In the monitor for real-time data acquisition, start the daemon.

In the context menu for the daemon, choose Start Daemon with All InfoPackages.

The daemon waits for a free background job.

Result

When the Web service returns data to the BI system, it is updated into the PSA table.

While the background job is running, the daemon checks the PSA at regular intervals.

When the data has been successfully updated into the PSA table, the daemon starts the data transfer process(es) for real-time data acquisition. This updates the data from the PSA table into the DataStore object. Changes are recorded in the appropriate change log request. The request that transfers the data to the PSA table (PSA request), the data transfer process request, and the change log request for each DataStore object have a 1:1 ratio. The data is activated automatically and written to the change log. This allows you to skip an additional activation step in the DataStore object; data is not written to the activation queue of the DataStore object.

The data is now available for reporting.

If you have assigned a subsequent process chain to the data transfer process, this process chain will start when the daemon closes a request.

Note

You can also use data transfer via Web service from without a daemon and use a standard DTP to update data from the PSA. You can also transfer master data to the BI system with a Web service in this way. More information: Transferring Data Using Web Services (Standard).