Processed Data from SAP HCP HANA DB and SAP On-premise OData service for SAP UI5 application

[himanshu_gupta13]

Hello Gurus,

We have a scenario in which our existing SAP UI5 application taking lot of time to show the results:-

As-is: Currently what we are doing, calling the SAP On-Premise Odata Service in UI5 application and then using the XSOData fetching the records from SAP HCP HANA DB. Using both the records, preparing the final table to display on the SAP UI5 application.

Issue: Due to large volume of records processing on front end layer, it is taking lot of time to process.

May you all please suggest a best way to move the code from front end processing to back end processing. Problem is we need data from both the On-Premise and HANA Cloud DB.

Many Thanks / Himanshu Gupta

[junwu]

you can move data to cloud or onpremise, you need provide more information to determine which way is better/preferable.

[himanshu_gupta13]

Hello Jun,

Thanks!! for reply 🙂

We have large volume of records on SAP HCP HANA DB and small volume of records on premise, approx 200 times lower than SAP HCP HANA DB records. In correspond of those small number of records from on premise need to check records in SAP HCP HANA DB and some calculations need to be done. We are planning to move this processing to XSJS code.

Any more suggestion from your side, will be welcome...

Many Thanks / Himanshu Gupta