Skip to content

Update Mode

The DeltaQ extraction type is primarily used for delta extractions. This means that only recently added or changed data is extracted, instead of a full load. The data that is extracted is defined by the Update Mode setting in the main window of the extraction type.

Update-Mode2

Update Modes

The DeltaQ extraction type offers the following update modes:

Mode Parameter Value Description
Full Full Extracts all data that match the set selection criteria.
Delta Update Delta Only extracts data added or changed on the SAP system since the last delta request. Initialize a delta process before running a delta update. To prevent errors, aborts and gaps in your data during a delta run, run the next extraction in the update mode Repeat.
Delta Initialization Init Extracts all data as full load and initializes the delta process. When re-initializing a delta process, first delete any existing Inits using the [Maintenance] button in the extraction settings menu.
Repeat Repeat Repeats the last delta run and updates and any delta data accumulated since the last run. Deletes any data from the last (unsuccessful) delta update before running a repeat. You can run a repeat multiple times.
Delta Init (without data) InitNoData Initializes the delta process without extracting any data from the SAP DataSources. The result of the Delta Init on the SAP side. When re-initializing a delta process, first delete any existing Inits using the [Maintenance] button in the extraction settings menu.
Non-cumulative init InitNoncumulative Relevant for DataSources like 2LIS_03_BX.
Activate (don't extract) Activate Activates a DataSource similar to the [Activate] button, but it is more practical when activating DataSources in a batch. No data is extracted.

Tip

Update mode can be set dynamically at runtime using the parameters values to overwrite the extraction parameter updateType, see Run an Extraction.

For more information about when to use which update mode, see Initialize a Delta Process

Initialize a Delta Process

To start a delta process with the DeltaQ extraction type, the delta must be initialized first. The following delta process shows when to use which Update Modes.

Step 1: Delta Initialization [C]

This mode requests all data that meets the selection criteria.

Set Update Mode to Delta Initialization and run the extraction.
The initialization selections are copied to load the delta records. You can now use Delta Update.

Note

When re-initializing a delta process, first delete any existing Inits (initialization requests) by clicking [Maintenance] in the extraction settings.

Alternative Step 1: Delta Init (without data) [S]

This mode is similar to Delta Initialization, but no data is extracted from the SAP DataSource.

Set Update Mode to Delta Init (without data) and run the extraction.
You can now use Delta Update.

Note

When re-initializing a delta process, first delete any existing Inits (initialization requests) by clicking [Maintenance] in the extraction settings.

Step 2: Delta Update [D]

Delta Update only extracts data added or changed on the SAP system since the last delta request.

Run the extraction with Delta Initialization or Delta Init (without data) once before setting the Update Mode to Delta Update.

Note

To prevent errors, aborts and gaps run the next extraction in the update mode Repeat.

Optional: Repeat [R]

This mode repeats the last delta run and updates all data accumulated since the last run. If the last run was unsuccessful, all data from the last delta update are deleted before a new run is started.
A Repeat can be started several times.

Many DataSources have the field ROCANCEL. This field defines if records are added or overwritten depending on the delta process type of the DataSource. It defines how a record is updated in the delta process.
In an ABR mode:

  • blank returns an after image
  • 'X' returns a before image
  • 'D' deletes the record
  • 'R' returns a reverse image

Optional: Delta Queue - RSA7

Once delta is activated, you can view the queued datasets in the Delta queue in SAP transaction RSA7.
If there is no new data to be transferred, a corresponding protocol message is displayed and the data pipeline is empty.

Note

Before initiating the next update, make sure that a delta update has been executed successfully. Running a new delta update removes the last one.



Last update: June 30, 2024