Start of Content Area

Procedure documentation Creating InfoPackages for Real-Time Data Acquisition  Locate the document in its SAP Library structure

Use

You use (standard) InfoPackages to determine the parameters for data request and data transfer from a source to the inbound layer of BI, the Persistent Staging Area (PSA).

For real-time data acquisition (SAPI and Web service) and when using Web services without real-time data acquisition or standard update (with a standard data transfer process), you use a special type of InfoPackage which allows you to specify the required parameters for these transfer types. This InfoPackage type is called InfoPackage for Real-Time Data Acquisition.

Requests that are instantiated using an InfoPackage for real-time data acquisition remain open across several load processes. In the InfoPackage for real-time data acquisition, you specify the size and time limits for requests. The system closes a request when one on the defined threshold values is reached.

Prerequisites

●      The DataSource for which you want to create an InfoPackage supports real-time data acquisition.

●      If you are transferring data into BI using the service API, you have already created an InfoPackage for initializing the delta process for this DataSource, and have completed the initialization.

Procedure

You can only create one InfoPackage for a DataSource for real-time data acquisition.

...

       1.      In the modeling view of the Data Warehousing Workbench, navigate to the DataSource tree of the required source system, select the DataSource, and in the context menu, choose Create InfoPackage.

       2.      In the following dialog box, enter a description for the InfoPackage. In the DataSource table, select the required DataSource.

○       If you are transferring the data using the service API:

Select the Real-Time Data Acquisition InfoPackage indicator. This field is only input ready if the DataSource supports real-time data acquisition, an InfoPackage for real-time data acquisition has not yet been created for this DataSource, and the delta initialization is complete.

○       If you are transferring the data using the Web API:

The Real-Time Data Acquisition InfoPackage indicated is already set.

       3.      Choose This graphic is explained in the accompanying text Save.

The scheduler appears; you can now maintain InfoPackages.

       4.      Define the parameters on the Data Selection tab page:

○       If you are transferring data using the service API, the selections from the delta initialization are displayed.

○       If you are transferring data using the Web service, you can specify the selection values for the data transfer.

Note

If selectable fields are defined in the Web service DataSource and you have specified corresponding selections in the InfoPackage, before writing to the PSA, the system filters out all data records that do not fulfill the selection conditions. In this case, the number of records available in the PSA is less than the number of records sent by the source.

       5.      Define the parameters on the Extraction tab page:

○       If you are transferring the data using the service API, Real-Time Extraction from SAP Source System is displayed as the adapter.

○       If you are transferring the data using the Web API:

Web Service (Push)is displayed as the adapter.

Change the security profile for the data transfer, as required.

If the name of the Web service or dependent objects needs to be predefined in the target system of a transport, enter a fixed name for the Web service. The Web service and any dependent objects, such as the corresponding function module, are then created using this name and the relevant generation prefix.

       6.      Define the parameters on the Processing tab page:

○       Set the threshold values for closing a request.

■       Specify the maximum number of days or hours after which the system closes a request. The default setting is one day.

Irrespective of the number of records loaded, the system closes the request as soon as this threshold value is reached and the data transfer continues in a new request.

■       Specify the maximum number of data records that is permitted for each request before a new request is opened. The default setting is 100,000 records.

The system checks the threshold values before it uses the request to update data. When a threshold value is exceeded, the daemon closes the request, and the data transfer is continued using a new one.

If you are using a Web service, the web service caller is also used to close the request. Whether the Web service caller or daemon closes the request depends on whether you are using the Web service for standard updating without RDA, i.e. without daemon assignment, or are using the Web service with RDA. The Web service caller multiplies the defined threshold values (time and number of records) by two. If you are using the Web service with RDA, this ensures that the daemon will close the request. If you are using the Web service without RDA, this ensures that the request will be closed after a given time and with a given size even if the daemon is not being used. If you are using the Web service without RDA, the request should not normally be closed using threshold values. Process type Close Real-Time InfoPackage Request should be used instead. Bear this in mind when the setting the threshold values in the InfoPackage.

○       For Real-Time Data Acquisition (SAPI und Web Service): Specify how many failed attempts are permitted when the daemon is accessing the data before a request is given error status.

○       The maximum size a data package for the data transfer can reach before a new package is opened is predefined. The default setting is 10,000 records. This setting can only be changed by the debug user. This setting may affect performance if you are updating data to the PSA using parallel processing (see Tasks on Demand → Change System Parameters).

       7.      Save the InfoPackage.

The InfoPackage and its DataSources now appear in the monitor for real-time data acquisition under Unassigned Objects.

       8.      For real-time data acquisition (SAPI and Web service): On the Schedule tab page, press This graphic is explained in the accompanying text Assign Daemon or Call RDA Monitor.

If you are working in Data Warehousing Workbench, you can also call to the monitor for real-time data acquisition from the context menu entry Assign RDA Daemon of the InfoPackage.

In the monitor for real-time data acquisition, the system now displays the InfoPackage in the Unassigned Objects area, under the DataSource for which the InfoPackage was created. By choosing Assign Daemon in the context menu for the DataSource, assign the DataSource, the InfoPackage and any associated data transfer processes are assigned to the specified daemon. The daemon now takes over processing the InfoPackage.

 

 

End of Content Area