Transferring Transaction Data from SAP Source Systems (RDA) 

Use

If you want to use data for operational reporting that is available in SAP source systems, use the real-time data acquisition scenario.

Prerequisites

The DataSource is delta enabled and supports real-time data acquisition. For your source system, you have installed BI Service API Status SAP NetWeaver 7.0 (Plug-In-Basis 2005.1) or higher, or for release 4.6C, Plug-In 2004.1 SP10.

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.      Activate the DataSource from BI Content and replicate the DataSource in the BI system, if necessary.

See Installing BI Content DataSources in Active Version.

If no BI Content DataSource is available for your use case, you can create a generic DataSource and replicate it in the BI system. Set up the generic delta for the DataSource and set the real-time enabled indicator for the DataSource.

See Maintaining Generic DataSources.

       2.      Create a DataStore object.

See Creating DataStore Objects.

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

See Creating Transformations.

       4.      Create a data transfer process 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.

       5.      Create an InfoPackage for the DataSource for simulating the delta initialization and perform delta initialization.

See Creating InfoPackages.

       6.      Perform delta initialization.

If you have transferred data during delta initialization, execute the following steps. Otherwise, proceed to step 9.

       7.      Update the data from the PSA into the DataStore object.

                            a.      Go to the maintenance screen for the data transfer process that you created in step 4.

                            b.      Choose Change to Standard DTP.

                            c.      On the Execute tab page, start the data transfer process.

                            d.      When the data has been successfully loaded into the DataStore object, activate the DTP request in the DataStore object.

       8.      Change the type of the data transfer process again.

In the toolbar for data transfer process maintenance, choose Change to Real-Time DTP.

       9.      Create an InfoPackage for the DataSource for real-time data acquisition.

See Creating InfoPackages for Real-Time Data Acquisition.

   10.      Switch from the InfoPackage to the monitor for real-time data acquisition.

In InfoPackage maintenance, on the Schedule tab page, choose Assign.

The Monitor for Real-Time Data Acquisition appears (transaction RSRDA).

   11.      Define a daemon (using  Create Daemon) or select an existing daemon.

   12.      Assign the DataSource (and the InfoPackage) to the daemon.

The InfoPackage appears in the monitor for real-time data acquisition; the system displays the InfoPackage in the Unassigned Nodesarea, under the DataSource for which the InfoPackage was created. In the context menu of the DataSource, choose Assign Daemon to assign the InfoPackage to a daemon. The daemon can now use the InfoPackage for data extraction.

   13.      Assign the data transfer process to the daemon.

In the context menu of the DataSource, choose Assign DTP. The daemon uses the data transfer process to process data.

You can update the data from the DataSource into multiple DataStore objects. In this case, assign the corresponding data transfer process to the daemon (using the DataSource).

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

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

The daemon waits for a free background job.

Result

While the background job is running, the daemon starts the delta transfer using the InfoPackage for real-time data acquisition. The daemon executes three steps:

...

       1.      In the first step, the daemon calls the service API in the source system. The service API transfers the data records into BI (into the delta queue, where necessary) and passes them to the daemon. The data is updated into the PSA table.

       2.      In the second step, when the data has been successfully updated to the PSA table, the daemon confirms the transfer, and the service API changes the status of the records in the delta queue.

Once the request has been successfully closed and the next request is open, the records are deleted from the delta queue.

       3.      In the third step, 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 and analysis purposes.