Skip to Content
0

SAP Hana query data from MS SQL server

Oct 28, 2016 at 06:40 PM

76

avatar image

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

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

2 Answers

Tong Ning Oct 30, 2016 at 02:34 AM
1

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.

Share
10 |10000 characters needed characters left characters exceeded
avatar image
Former Member Nov 04, 2016 at 10:29 AM
1

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

Share
10 |10000 characters needed characters left characters exceeded