The DeltaQ component 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 of the DeltaQ component.
Update Modes #
In the main window of the component select an Update Mode from the drop-down menu.
Update Mode offers the following options:
| Mode | Description |
|---|---|
| Full | Extracts all data that match the set selection criteria. |
| Delta (Delta Update) | Only extracts data added or changed on the SAP system since the last delta request. Initialize the 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. |
| Init (Delta Initialization) | Extracts all data as full load and initializes the delta process. When re-initializing a delta process, first delete any existing Inits by clicking [Maintenance] in the extraction settings. |
| 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. |
| InitNoData (Delta Init without data) | Initializes the delta process without extracting any data from the SAP DataSources. The result of the Delta Init is a [Maintenance] on the SAP side. When re-initializing a delta process, first delete any existing Inits by clicking [Maintenance] in the extraction settings. |
| InitNoncumulative (Non-cumulative init) | Relevant for DataSources like 2LIS_03_BX. |
| Activate (Activate don’t extract) | Activates a DataSource similar to clicking [Activate], but it is more practical when activating DataSources in a batch. No data is extracted. |
For more information about when to use which update mode, see Initializing a Delta Process
Initializing a Delta Process #
To start a delta process, 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 Initialisation, 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.