Skip to Content
Jul 12, 2019 at 10:33 AM

How to capture delete records in real time replication in HANA tables using Smart Data integration

182 Views Last edit Jul 12, 2019 at 10:36 AM 2 rev

Hi All,

I am facing an issue while using SDI in HANA.

Source : SAP BW 7.4(on traditional database)

DP: Smart data integration->Remote source->ABAP ADAPTER->Extractors->SAPI-> Generic Datasource exposed as ODP in real time.

I have created a ODP(Generic Real Time DS) on DSO active table and top of that, I have created Virtual table in hana. Then I initialised realtime delta for ODP which can be monitored in ODQMON.

Using flowgraphs I am able to capture new records/update records in real time into hana tables.

ISSUE: Issue is if I deleted records from DSO, It should reflect same in HANA as well. I need to capture that deleted records and update in HANA.

Suppose, I have two materials M1, M2 in HANA and later If I deleted M1 from DSO, then only M2 should available in HANA.

Can someone please guide me how can I achive this? It's bit urgent

Anyhelp would be appreciated!!

You can share your thoughts at sharmasunil532@gmail if possible