Creating a Data Transfer Process for Real-Time Data Acquisition 

Use

You use the data transfer process for real-time data acquisition to transfer data to the DataStore object from the PSA. In the DataStore object, the data is available for use in reporting.

Prerequisites

You have created the dataflow between the DataSource and the DataStore object using transformations.

The selections for the data transfer process do not overlap with selections in other data transfer processes.

Procedure

The starting point when creating a data transfer process is the DataStore object into which you want to transfer data. In the Data Warehousing Workbench, an object tree is displayed and you have highlighted the DataStore object.

...

       1.      In the context menu, choose Create Data Transfer Process.

The dialog box for creating a data transfer process appears.

       2.      Choose DTP for Real-Time Data Acquisition as the DTP Type.

       3.      As the source object, select the DataSource from which you want to transfer data to the DataStore object. If only one source object exists, this is selected by default.

       4.      Choose Continue.

The data transfer process maintenance screen appears.

The header data for the data transfer process shows the description, ID, version, and status of the data transfer process, along with the delta status.

       5.      On the Extraction tab page, determine the parameters:

Delta is chosen as the extraction mode for real-time data acquisition

                            a.      If necessary, determine filter criteria for the delta transfer.

This means that you can use multiple data transfer processes with disjunctive selection conditions to transfer small sets of data from a source efficiently into one or more targets, instead of transferring large volumes of data. You can specify individual selections, multiple selections, intervals, selections based on variables, or routines. Choose Change Selection to change the list of InfoObjects that can be selected.

       6.      On the Update tab page, determine the parameters:

                            a.      Apply settings for error handling: Determine how the system updates the valid records when errors occur, the number of errors allowed before the load process terminates, whether the load process should be judged to contain errors if records are being aggregated, sorted, or added during the transformation.

                            b.      Under Semantic Groups, determine the key fields for the error stack. See Error Stack.

       7.      On the Execute tab page, determine the parameters:

On this tab page, the process flow of the program for the data transfer process is displayed in a tree structure.

                            a.      Specify the status that you want the system to adopt for the request if warnings are displayed in the log.

                            b.      Specify how you want the system to determine the overall status of the request.

       8.      Check, save and activate the data transfer process.

Result

Choose Real-Time Monitor to access the monitor for real-time data acquisition. In the monitor, you can assign the data transfer process to a DataSource and a daemon. You do this in the context menu of the DataSource. The daemon can use the data transfer process to process data.