Skip to Content
0

Non SAP DB

Apr 18 at 10:20 AM

29

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.

Regards

Ramesh

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
0

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.
Share
10 |10000 characters needed characters left characters exceeded