Skip to Content

SAPUI5 with both backend (HANA xsodata and Gateway Services)

Hello, I have some doubts about my scenario.

Scenario:

We are running a few SAPUI5 apps just using Gateway Services, and connecting through oData to SAP ERP. Some of the queries started to run slowly and we decided to try to get the data from HANA DB (because it should be much faster).

So our need is transform all the GET requests from Gateway to HANA Views.


The question I'm asking is about the procedure for accessing HANA Views from SAP Gateway.


Our first thinking was about CDS Views, but we aren't sure if we later could include filters (necessary in our scenario), and the power and the ease of use of the HANA Modelling views is an advantage to point first on HANA views.



So which should be the best option (or which are the differences) between this three options?

Thanks in advance.
Regards

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    Feb 14 at 08:18 PM

    If you have already a calculation view on HANA, why you do not just expose it as OData service on HANA and consume it directly (you can configure your Web Dispatcher to do that). As the official documentation says ... with that you have not additional development overhead + no additional increased latency by routing the service through the NW stack.

    Regards,
    Florian

    Add comment
    10|10000 characters needed characters exceeded