Skip to Content
avatar image
Former Member

SLT replication for non-SAP oracle db

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Oct 21, 2015 at 04:38 PM

    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%20Implementing%20SAP%20HA…

    All the Best !

    -Prashanth

    Add comment
    10|10000 characters needed characters exceeded

  • Oct 22, 2015 at 03:04 PM

    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

    Add comment
    10|10000 characters needed characters exceeded