Please note, this is a STATIC archive of website www.tutorialspoint.com from 11 May 2019, cach3.com does not collect or store any user information, there is no "phishing" involved.
Tutorialspoint

Replicating data from HANA db to other HANA system in real time

I have to replicate data from source HANA db to target HANA database in real time- trigger based replication. I got to know about SAP LT Replication however I want a custom implementation to put trigger request in a queue. 

Any idea how to handle this?


1 Answer
SAP Expert

You can also try using SAP Smart data access feature to transfer data in real time. In SAP HANA system, you can use Smart Data Access (SDA) option to replicate data to HANA database from other data sources where you create virtual tables, which are linked to tables in the remote system. You can perform read/write operations on these virtual tables - SELECT, Insert, and Update.

Different types of remote systems can be used under Smart Data Access −

  • SAP HANA
  • Sybase
  • Teradata
  • Apache Hadoop
  • Oracle

To know more about SAP HANA Smart data access replication, you can refer below SAP documentation:

SAP Smart Data Access


 SAPSAPdocumentation

Advertisements

We use cookies to provide and improve our services. By using our site, you consent to our Cookies Policy.