Skip to content

DeltaQ

This page shows how to use the DeltaQ extraction type.
The DeltaQ extraction type can be used to extract delta data from SAP DataSources. This means that only recently added or changed data is extracted, instead of a full load. For more information on the delta process, see Initialize a Delta Process.

Warning

Newer component available.
DeltaQ is an old extraction type. If possible, use the newer extraction type ODP.

Prerequisites

  • A connection to an SAP system is available, see SAP Connection.
  • The SAP user has sufficient user rights, see SAP Authority Objects.
  • Configure your SAP system to make DataSources accessible, see SAP Customization for DeltaQ.
  • To use DataSources in Xtract Universal, make sure that the DataSources are activated in SAP.

Warning

Missing Authorization.
To use the DeltaQ extraction type, access to the designated authority objects (RFC) in SAP must be available. Adjust SAP Authority Objects: DeltaQ accordingly.

SAP Transactions for Working with DeltaQ

The following SAP transaction can support you when working with DataSources:

  • SBIW - SAP DataSources start page
  • RSA3 - Extractor Checker
  • RSA5 - Install DataSources and Hierarchies from Business Content
  • RSA6 - Postprocess DataSources and Hierarchies
  • SM59 - Configuration of RFC Connections
  • SMQS - qRFC Monitor (QOUT Scheduler): Number of Max.Conn. should be at least 10
  • SM37 - Background jobs
  • SM58 - Transactional RFC
  • SM50 - Process overview
  • SMGW - Gateway Monitor
  • RSA7 - Delta Queue Maintenance
  • SMQ1 - qRFC Monitor (outbound queue)
  • WE02 - IDoc list
  • WE20 - Partner profiles

Create a DeltaQ Extraction

  1. In the main window of the Designer, click [New] to create a new extraction. The window "Create Extraction" opens.
    New
  2. Select an SAP Connection from the drop-down menu in Source and enter a unique name for your extraction.
  3. Select the extraction type DeltaQ and click [OK]. The main window of the extraction type opens automatically.

The majority of the functions of the extraction type can be accessed in the main window.

Look Up Extractors or Hierarchies

  1. In the main window of the extraction type, click [ ]. The window “Look Up OLTP Source” opens.
    DeltaQ
  2. In the field Name, enter the name of a DataSource . Use wildcards ( * ), if needed.
    search-ds-mat-attr
  3. Click [ ]. Search results are displayed.
  4. Select an extractor and click [OK] to confirm.
  1. In the main window of the extraction type, click [ ]. The window “Look Up OLTP Source” opens
    DeltaQ
  2. In the field Name, enter the name of a Hierarchy . Use wildcards ( * ), if needed. Alternatively, enter the description of a Hierarchy in the field Description.
    search-ds-mat-attr
  3. Click [ ]. Search results are displayed.
  4. Select an extractor of type HIER and click [OK] to confirm. All available Hierarchies are fetched and the window "Look Up DeltaQ Hierarchies" opens.
  5. Select a Hierarchy and click [OK] to confirm.
    search-ds-mat-attr

The application now returns to the main window of the extraction type.

Define the DeltaQ Extraction Type

The DeltaQ extraction type offers the following options for DataSource extractions:

  1. Navigate to Gateway and click [ ] to look up an RFC destination. For more information, see DeltaQ Customizing: Gateway.
    DeltaQ2
  2. Navigate to Logical Destination and click [ ] to look up a logical RFC target system. For more information, see DeltaQ Customizing: Logical Destination.
  3. Click Customizing Check to validate the DeltaQ Customizing on the SAP system. Make sure that all check marks are green. For more information, see DeltaQ Customizing: Customizing Check.
    customizing-check-successful
  4. Select an Update Mode, e.g., to initialize delta extractions.
  5. Select the items you want to extract.
    DeltaQ-output
  6. Optional: click the Edit option next to an item to filter the data.
  7. Click [Run] to testrun the extraction and validate your settings.

  8. Click [Activate] to activate the extraction in SAP. After a successful activation, a corresponding status message opens:
    Deltaq-System-Parameters-Info

    Note

    The activation is only required for the update modes Delta, Full or Init. Do not activate the extraction for the Delta Update mode.

  9. Check the Extraction Settings and the General Settings before running the extraction.

  10. Click [OK] to save the extraction type.
  1. Navigate to Gateway and click [ ] to look up an RFC destination. For more information, see DeltaQ Customizing: Gateway.
    DeltaQ2
  2. Navigate to Logical Destination and click [ ] to look up a logical RFC target system. For more information, see DeltaQ Customizing: Logical Destination.
  3. Click Customizing Check to validate the DeltaQ Customizing on the SAP system. Make sure that all check marks are green. For more information, see DeltaQ Customizing: Customizing Check.
    customizing-check-successful
  4. Select an Update Mode, e.g., to initialize delta extractions.
  5. Select the items you want to extract.
    DeltaQ-output
  6. Optional: click the Edit option next to an item to filter the data.
  7. Optional: click Extraction Settings to set the language and output format of the Hierarchy, see extraction settings.
  8. Check the Extraction Settings and the General Settings before running the extraction.
  9. Click [Run] to testrun the extraction and validate your settings.
  10. Click [OK] to save the extraction type.

Tip

Unlike attributes and transactions, Hierarchies do not have to be activated.

You can now run the extraction, see Execute and Automate Extractions.

Execute DeltaQ in Parallel

When extracting multiple DataSources in parallel, it is recommended to use separate RFC destinations, e.g., XTRACT01, XTRACT02, etc.
Parallel execution of DataSources with an identical RFC destination is possible, but not recommended.

Last update: July 25, 2024