Skip to Content

Non SAP DB

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    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.
    Add comment
    10|10000 characters needed characters exceeded