I would say that Realtime ingestion with Realtime Cockpit. It will send you all changes detected on the triggers you deploy. And, in theory, that will include those "old prior data"

Also, if you have some "updated timestamp" in the HANA Schema that will solve your problem, using that field for the delta loads.

HTH

Thanks Guillermo, will need more info. Is there any link I can refer to?

Replication Cockpit - https://docs.celonis.com/en/replication-cockpit.html

Realtime for SAP/HANA -

• Log Tables - https://docs.celonis.com/en/replication-cockpit.html#UUID-4002a57d-061c-53cf-e602-14c69df156ad_id_SetupSAPRealTimeExtension-logtablesaCreatingLogTables
• Triggers - https://docs.celonis.com/en/replication-cockpit.html#UUID-4002a57d-061c-53cf-e602-14c69df156ad_id_SetupSAPRealTimeExtension-triggercCreatingTriggers

In short you define triggers and log tables in SAP so any change is replicated there. Then Celonis picks that info and via Replication Cockpit you get a near-realtime upload of the changes.

Regarding delta dataloads, for example in our current customer we have modifyts (when has been changed the record). Also our CASE_ID is composed of the timestamp when that case was created, plus some additional codes.

HTH

Hi!

I liked the use of Data Integration to replicate the data, but it makes me understand the difficulty that SAP/HANA has today in having a column for the date of change in the record with a timestamp. This would solve the problem of delta loads; whenever this record was included, the change date would be the same too, and then it would be incremented with each change.