Create DB trigger for SLT replication

[Madhu-Teklink]

Hi

Looks like we deleted DB triggers in ECC source system.

Now when we add tables for SLT replication, we see the message - Table was not yet processed; trigger should be created during first processing.

How do manually create DB triggers in ECC source system?

Regards

Madhu Bommala

[SridharKarra]

Madhu,

I don't think you can create DB triggers in ECC source system manually. The DB trigger and the logging tables are created only from the SAP Hana Studio depending on which option you choose for loading data (LOAD/REPLICATE etc...).

Load: Starts an initial load of replication data from the source system. For the initial load procedure, neither database triggers nor logging tables are created in the source system

Replicate: Combines an initial load procedure and the subsequent replication procedure (real-time or scheduled).

Before the initial load procedure will start, database trigger and related logging table are created for each table in the source system (as well as additional replication-related objects in the SAP LT Replication Server).

Please go throught the Trigger-Based Data Replication Using SAP LT (Landscape Transformation) Replication Server for SAP HA... document. Page 14.

Thanks,

Sri.

[Former Member]

This message was moderated.