Skip to main content

Change Data Capture (CDC) and SAP OData Integration in dab Nexus

Overview​

Change Data Capture (CDC) transfers only records that have changed since the last extraction (inserts, updates, and deletes) instead of reloading the entire dataset. After an initial full load, SAP CDC tracks database-level changes and reconstructs affected CDS View records, reducing extraction time, system load, and network traffic for large transactional datasets.

Full Load → Track Changes → Transfer Only Changes

Changed records include:

  • Inserts
  • Updates
  • Deletes

CDC in Nexus​

Nexus supports CDC-enabled SAP OData V4 services and leverages SAP delta tracking to perform incremental extractions. For CDC-enabled extraction packages, Nexus:

  1. Performs an initial full extraction.
  2. Stores the delta link returned by SAP.
  3. Uses the stored delta link for subsequent extractions.
  4. Retrieves only records that have changed since the previous extraction.
  5. Updates the stored delta link after every successful execution.

CDC Package Configuration in Nexus​

CDC functionality is available for extraction packages that expose CDC-enabled CDS Views through SAP OData V4.

Requirements:

  • The package uses an SAP OData V4 endpoint.
  • The underlying CDS View supports delta tracking.
  • SAP returns a valid @odata.deltaLink.
  • The SAP user has authorization to access the OData service.

If delta tracking is not supported by the CDS View, Nexus performs a standard extraction and no delta link is stored.

References​