Skip to Content
avatar image
Former Member

Is bulk import from a .csv to source HDB replicated through SLT Replication?

Hi All,

We have data replication in place from a source HANA DB to a target HANA DB through SLT Replication.

If we perform an import from a csv file replacing data in the source table, will the same be replicated in the target database as well?

I understand that SLT replication creates DML triggers in the source database, so do these triggers interpret "import" as sequence of "insert/update/delete" ?

Thanks in advance.

Regards,

Sarim

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Jan 05, 2015 at 03:39 PM

    Hi Sarim,

    SLT replication is create DB triggers automatically in the source database.



    A technique for replicating data where an initial load is first performed that loads data from the source to the target system, and a replication phase begins whereby only changes to the source database (recorded by databases triggers) are replicated to the target database, thereby facilitating data replication in real-time.

    Read the Chapter 2.1 Basic Concepts of Trigger-based data Replication using SAP

    LT Replication Server for SAP HANA

    from 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…

    For more reference

    http://scn.sap.com/docs/DOC-60357

    https://www.experiencesaphana.com/videos/1373

    Regards,

    V Srinivasan

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi Srinivasan,

      Thanks for the reply, I've been through the Hana operations guide and have set up SLT replication as well.

      The documents you mentioned though helpful, still doesn't answer the question that if the DML triggers on source table consider 'Import' as DML statement.

      Regards,

      Sarim

  • avatar image
    Former Member
    Jan 06, 2015 at 08:56 AM

    Hi Mohammad,

    Logically, SLT triggers keep a watch on the 'change in data records' for any values or any activity like insert, update, delete. Hence, I believe the changes to the data in the source (irrespective of how it gets changed) will get reflected in the target HANA database table in your case.

    I haven't tried this and hence a quick test by you can make this certain.

    Let me know.

    Regards,

    kG

    Add comment
    10|10000 characters needed characters exceeded