SAP Hana query data from MS SQL server

[former_member230931]

Hi All,

We are using SAP Hana database and for warehousing (WMS), we use a 3P application that runs on a MS SQL server. We have a requirement that SAP users want to see the sales order pick status in the WMS application. What's the best way to setup a link from Hana to MS SQL server and query data and show on SAP screen directly?

Thanks

[Former Member]

Hello,

don't know how much data this contains and the structure of your environment but you could also share this information via SAP SLT

Which means a real time replication from one system to another

Short explanation can be found in:

https://www.youtube.com/watch?v=J-N7hfVNKCs

Regards,
David

[former_member182967]

Consider to use SAP HANA Smart Data Access for your purpose.

To show on SAP Screen directly -> Maybe you need to let your ABAP consultants to write some z-programs.