Update Extractions to Use Manageable Triggers
This article shows how to update Table CDC extractions that were created before Board Connector version 2025.12.15.36 to use manageable triggers. This enables users to make changes to the SAP source table while tracking changes in Table CDC.
About Manageable Triggers
As of version 2025.12.15.36, Board Connector supports manageable triggers.
Before that, the Table CDC extraction type 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 Table CDC Extraction Types
To update existing Table CDC extractions:
- Download the latest version of Board Connector from the Customer Portal.
- Install the latest version of the custom function module THEO_CDC_ECC or THEO_CDC_S4 in SAP.
- In Board Connector, open a Table CDC extraction type.
- In the main window of the extraction type, 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.
- Run the extraction(s) to reinitialize tracking.
The extraction now uses the new manageable DB triggers.
Note
Whenever you make changes to the SAP source table, open the Table CDC extraction type and click [Refresh Metadata] to update the extraction type.
Written by: Valerie Schipka