Non SAP DB

[former_member557515]

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

[jeffrey_kresse · Accepted solution]

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.