SLT replication for non-SAP oracle db

[Former Member]

Hello Experts,

I was reading many documents but I am still not sure how the SLT replication with non SAP system (oracle) could work.

One thing is clear that I can use only DB connection.

Can I have real time replication? If I understood right I can trigger only initial load, but I do not get how to work with the delta/changes after the initial load. Or if I trigger replication for that table then initial load is performed and after that the replication will start like for normal SAP tables?

One other question would be that how to deal with cases where we truncate the table every 30mins and put new data into it?

Thanks for any help, advice in advance.

BR
Tamas

[FCI]

SLT connect to non-SAP source with a db connection. It creates DB triggers on the replicated tables that replicates (after the initial load) all operations on the sources tables (modifications/creation/tuncate etc.).

A truncate on the source table will generate a truncate on the target Hana table. There is no replication issue though there may be on the consumer side (SQL accessing the truncated table or virual views built on top of it may return data or not depending on the time).

Regards,

Frederic

[prashb]

Hello Tamas,

yes, you can have real-time replication.  SLT can be used for non-sap source like oracle DB.  replication works in the same way as SAP source system - but table structure changes (like adding or removing table/column)  also known metadata stored in DD02L & DD02T will be loaded as initial load and will not be replicated, below OSS note as report which will allow you to update the tables.

1751323 - Hana LTR : Non Sap Replication-Update DD02L and DD02T tables

All the table content changes (even table truncate and inserts) will be logged in the logging table and can be replicated to target system in real-time or scheduled by time . There are many guides and scn docs on this subject, here are some:

1768805 - SAP LT Replication Server: Collective Note - non-SAP Sources

http://help.sap.com/hana/SAP_Landscape_Transformation_for_SAP_HANA_Operations_Guide_en.pdf

http://events.asug.com/2013AC/Business%20Integration%20Technology%20&%20%20Infrastructure/0603%20Imp...

All the Best !

-Prashanth