SAP Hana query data from MS SQL server

[#1]

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]

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.