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

[Former Member]

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

[Former Member]

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

[srinivasan_vinayagam]

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%20Imp...

For more reference

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

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

Regards,

V Srinivasan

[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