Skip to Content
avatar image
Former Member

How to perform HANA queries via service layer

In all versions of the SBO SDK to date you had the ability to perform queries against the database and return a recordset. It appears this functionality is no longer possible with the service layer. I am looking for some guidance as to how to accomplish this using the service layer or any other "web" tools currently available. I have looked into using the XS engine, but it doesnt appear that there is any way to pass AUTH from the service layer to XS so users would have to login twice.

Am I looking at this wrong? Do any users have any suggestions as to hwo to make this work?

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    Sep 01, 2017 at 01:56 PM

    Hi Thomas,

    It is not possible, there is a workaround though

    This should help you.

    https://answers.sap.com/questions/272549/service-layer-call-procedure-or-view-from-database.html

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Thanks Danilo! I have posted some additional questions which I feel are relevant on that thread.

  • Sep 06, 2017 at 09:57 AM

    That answer was applied to a particular Stored Procedure case.

    If you want to only expose data from queries (with no aditional logic after it) It's much simpler to create a Odata Service.

    Please check my answer in here

    Add comment
    10|10000 characters needed characters exceeded