Skip to Content


Apr 18 at 10:20 AM


avatar image

Hi Experts,

How to load data form HANA To Non SAP Databases(SQL) using SAP HANA SDI, it should be real time data replication. Please suggest me.



10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Best Answer
Jeff Kresse
Apr 23 at 04:27 PM

Hi Ramesh,

  1. Setup HANA adapter and remote source, pointing to the HANA running SDI
  2. Setup adapter and remote source pointing to your target system. Make sure the adapter is a supported Target in the PAM.
  3. Create your target table in the target database.
  4. Create a virtual table in HANA on that new target table. (HANA Catalog > Provisioning > Remote Sources > "Your Remote Source" > Schema > Right click object > Create new virtual table.
  5. Create a virtual table in HANA on the HANA source objects. This enables us to create triggers to track the changes. Same procedure as 4.
  6. Open HANA Editor and create a new flowgraph. Change replication type to real time.
  7. Add Data Source: Virtual table of the source HANA object
  8. Add Data Sink: Virtual table of the remote target table in the non-SAP DB
  9. Connect these nodes (and optionally other nodes to transform data) and save the flowgraph. It should now be activated and several objects created: tasks, subscription, etc.
  10. Execute the flowgraph.
10 |10000 characters needed characters left characters exceeded