Skip to Content

SAP Hana query data from MS SQL server

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Oct 30, 2016 at 02:34 AM

    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.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Nov 04, 2016 at 10:29 AM

    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

    Add comment
    10|10000 characters needed characters exceeded