Update Extractions to Use Manageable Triggers

This article shows how to update Xtract TableCDC SSIS packages that were created before Xtract IS version 2025.12.15.32 to use manageable triggers. This enables users to make changes to the SAP source table while tracking changes in Xtract TableCDC.

About Manageable Triggers

As of version 2025.12.15.32, Xtract IS supports manageable triggers.

Before that, the Xtract TableCDC component created non-manageable DB triggers for its source table upon initialization. As a result, the structure of the source table could not be changed as long as the triggers were active. To change the structure of the source table, the CDC resources in SAP had to be deleted first.

The new manageable DB triggers allow users to delete and change table columns that are not part of the primary key. For more information about manageable triggers, refer to SAP Note 2814740.

Update Existing Xtract TableCDC Components

To update existing Xtract TableCDC extractions:

1. Download the latest version of Xtract IS from the Customer Portal.
2. Install the latest version of the custom function module THEO_CDC_ECC or THEO_CDC_S4 in SAP.
3. In Xtract IS, open a Xtract TableCDC component.
   • In the main window of the component, click [Delete CDC resources] to delete the DB triggers of the extraction.
   • In the menu Active CDC Watches, click [ ] to delete DB triggers of other extractions.
4. Run the SSIS package(s) to reinitialize tracking.

The SSIS package now uses the new manageable DB triggers.