Skip to content

Table CDC Services

This page shows how to use the Table CDC service type.
The Table CDC service type loads incremental data from SAP Tables. Unlike a full data load that transfers all records, CDC captures only data that has changed since the last load.

About Table CDC

Change Data Capture (CDC) is a method to keep track of data changes such as insert, update and delete in SAP tables. The Table CDC service type creates a log table in SAP that records any changes made to a selected table. The content of the log table is cleared after every successful service run. Data that was not extracted is not cleared from the log table.

For a detailed overview of this process, refer to the Knowledge Base Article: Delta Mechanism of TableCDC.

General workflow for setting up Table CDC services:

  1. Define a Table CDC service type that contains the following:
    • The SAP Table you want to track.
    • Filters (optional), e.g., a column selection and/or WHERE Clause.
  2. Run the Table CDC service once to initialize tracking:
    • Creates a log table and DB triggers in SAP.
    • Loads the initial data of the SAP Table (optional).
  3. Run the Table CDC service regularly to load data changes.

System Requirements

  • The Table CDC service type is compatible with SAP ECC 5.0 and higher
  • Supported databases:
    • HANA
    • SQL Server
    • ASE (SAP Adaptive Server Enterprise, formerly Sybase)
    • Oracle
    • Db6 - Db2 on Linux, Unix, Windows.
    • Db2 - Db2 for IBM z/O (Db2 LUW in SAP)
    • MaxDB

Unsupported SAP Objects

  • Clusters, pool tables and views.
  • BW objects that use activation requests, e.g., DSO and ADSO tables. SAP BW/4HANA may restrict or block trigger-based mechanisms on these objects, which can prevent CDC functionality from working correctly. For more information, see SAP Note 2583731.

Prerequisites

Create a Table CDC Service

To create a new Table CDC web service in Xtract Universal.iQ:

  1. Open the Services menu.
  2. Click [Add Service].
  3. Enter a unique name and a description.
  4. Optional: Activate the checkbox Enable MCP Access and add an MCP description to expose the service via the Xtract Universal.iQ MCP Server.
  5. Select an existing SAP connection from the Connection dropdown. If no connection is available, create a connection, see Connect to SAP.
  6. Select Table CDC from the Type dropdown.
  7. Select a target environment from the Destination dropdown. By default, Xtract Universal.iQ services return SAP data in HTTP response of the service (HTTP destination).
  8. Click [Save].

The service is now listed in the Services menu.

Next, select the SAP object you want to extract.

Look Up an SAP Table

To select an SAP Table or View from your SAP source system:

  1. Create a new service of service type Table CDC or edit an existing service.
  2. In the Table section of the Table CDC service, click [Select Table]. The "Search SAP tables and views" menu opens.
  3. Enter the technical name or description of an SAP Table or View. To look up CDS Views, enter the SQL name of the CDS View. Use wildcards ( * ) if needed.
  4. Click [Search] to display the search results.
  5. Select a table or view from the list of search results. The "Search SAP tables and views" menu closes.

Xtract Universal.iQ loads and displays the metadata of the table or view in the service.

Next, configure the remaining service settings.

Configure the Table CDC Service

After creating the service, configure the service using the following workflow:

  1. Go to the output columns section and select the table columns you want to extract. By default all columns are selected.
  2. Optional: Define a WHERE clause to filter table records. By default all data is extracted.
  3. Optional: Edit the Service Settings to define how the data is extracted from SAP.
  4. Optional: Edit the Destination Settings to define the output of the service.
  5. Click [Save].
  6. Run the Table CDC service once to initialize tracking.

For more information, see Table CDC Settings.

Note

If the option Extract table on first run in the Service Settings was active, the output table contains the content of the original SAP table. If the option was not active, the output table is empty.

Tip

To check if the log table was initialized successfully in SAP, open the Table CDC service settings and check the Log Table State in the CDC Resources section, see CDC Resources.

Note

When running the service regularly the content of the log table in SAP is extracted and written to the destination. The content of the log table in SAP is cleared after every successful service run. Data that was not extracted is not cleared.

Source Table Changes

After initializing the log table, you can make the following changes to the SAP source table:

  • add new columns
  • delete existing columns that are not part of the primary key (as of SAP Basis 7.76, S4H 1905)
  • change columns that are not part of the primary key (as of SAP Basis 7.76, S4H 1905)

For more information, see SAP Note 2814740.

After changing a source table, open the corresponding Table CDC service and click [Refresh Metadata] to update the service.

Delete Log Table and Triggers

When a Table CDC service is no longer in use, simply deleting the service is not enough.

To delete the log table that is used by the service:

  1. Open the Table CDC settings.
  2. Go to Table > CDC Resources.
  3. Click next to the Log Table State field. The log table state changes from Initialized to Not initialized.

The log table and all associated triggers used by the service are deleted from your SAP system.

To delete the log table of multiple services or services that are already deleted:

  1. Open the Table CDC settings.
  2. Go to Table > CDC Resources.
  3. Click [Manage all CDC Resources]. The "Manage CDC Resources" menu opens.
  4. Select the resources you want to delete and click .

The log table and all associated triggers are deleted from your SAP system.

Run and Automate the Service

Last update: July 8, 2026