The following section shows how to use the Table CDC component.

Look Up a Table #

Look up the SAP table you want to track.

  1. In the main window of the component click magnifying-glass. The window “Table Lookup” opens.
    Table-CDC
  2. In the field Table Name (1) enter the name of the SAP table you want to track. Use wildcards (*) if needed.
    Look-Up-Report
  3. Click magnifying-glass (2).
  4. Select the desired table (3) and click [OK] (4).

The application now returns to the main window of the component. All relevant metadata information of the table is retrieved from SAP.

Define a Table CDC Extraction #

Set up the Table CDC component to extract data:

  1. Select the columns you want to extract.
    Table-CDC-Setup
  2. Optional: If you do not want to extract the whole table when first running the extraction, deactivate [Extract table on first run].
  3. Set a maximum number of rows that can be tracked. The default is 10000 rows.
    If the row limit is reached, the extraction fails with an exception. The maximum row limit of a log table is 500000. Note that once a log table is initialized, you cannot change the size limit anymore.
  4. Optional: Define a WHERE Clause to filter table records.
  5. Click [Load Preview] to load 1000 records for the preview.
    The column TS_OPERATION indicates if a row was inserted (I), updated (U) or deleted (D).
  6. Click [OK] to confirm your settings.
  7. Run the extraction to create a log table in SAP that records any changes made to a selected table, see Run the Extraction for the First Time.

Run the Extraction for the First Time #

Run the extraction for the first time to create a log table in SAP that records any changes made to a selected table or view.

  • If the option [Extract table on first run] in the Xtract Table CDC component is active, the extracted table contains the original SAP table.
  • If the option [Extract table on first run] in the Xtract Table CDC component is not active, the extracted table is empty.

Note: When running the extraction regularly the content of the SAP log table is extracted. The content of the SAP log table is cleared after every successful run of the extraction. Data that was not extracted is not cleared.

Delete Log Table and DB Triggers #

When a Table CDC extraction is no longer in use or if you need to change the structure of the source table, simply deleting the extraction is not enough.
To delete the log table and all associated triggers from your SAP system, open the Table CDC extraction and click [Delete CDC resources].

To delete the SAP resources of multiple extractions or extractions that are already deleted, see Active CDC Watches.

Warning! Table change not possible
The source table structures can be changed only after clearing the CDC-related resources connected to that table in SAP, see SAP Note 2284776