Skip to content

Xtract DeltaQ

This page shows how to use the Xtract DeltaQ component.
The Xtract DeltaQ component 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.

Prerequisites

Warning

Missing Authorization.
To use the Xtract DeltaQ component, 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

Add an Xtract DeltaQ Component

Follow the steps below to add an Xtract Table component to your SSIS package:

  1. Drag&drop the Xtract DeltaQ component from the SSIS toolbox into your data flow task.
    New

  2. Double-click the component. A connection manager is automatically assigned to the component and the main window of the component opens.

    Note

    If there are multiple connection managers, the window "Select Connection Manager" opens, see SAP Connection. Once a connection manager is selected, the main window of the component opens.

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

Look Up Extractors or Hierarchies

  1. In the main window of the component, 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 component, 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 component.

Define the Xtract DeltaQ Component

The Xtract DeltaQ component 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 [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.

  8. Check the Settings before running the SSIS package.

  9. Click [OK] to save the component.
  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 Settings to set the language and output format of the Hierarchy, see settings.

  8. Click [OK] to save the component.

Tip

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

You can now run the SSIS package.

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: November 18, 2024