Question Re: SAP Hana query data from MS SQL server in Technology Q&A

SAP Hana query data from MS SQL server

former_member230931 — Fri, 28 Oct 2016 18:40:51 GMT

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

Re: SAP Hana query data from MS SQL server

former_member182967 — Sun, 30 Oct 2016 02:34:54 GMT

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.

Re: SAP Hana query data from MS SQL server

Former Member — Fri, 04 Nov 2016 10:29:42 GMT

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