Skip to Content
0

Call External REST API from HANA models via XS Engine

Oct 05, 2017 at 03:37 AM

424

avatar image
Former Member

Dear expert , In need of your advise on how to call external REST API in SAP HANA model . I am aware that it is possible to call outbound REST API from XS layer and then it can be updated in to a table using XSJS . But i would like to access this external data in real time inside HANA model ( say calculation view ) to mashup with other existing data . Then this model is being consumed in a reporting tool for analytics in real time.

Please share your thoughts

Thanks

Siva

10 |10000 characters needed characters left characters exceeded

Hi Siva

Did you find a solution for this requirement?

Regards

Giri

0
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Florian Pfeffer
Oct 05, 2017 at 09:12 AM
0

It is not possible to use an XSJS service which calls an outbound REST API within a calculation view. One way to integrate your data is using SAP HANA Smart Data Integration. You can check if already a fitting adapter exists for your source or if you have to write your own adapter. Details can be found (as always) in the official documentation: SAP HANA Smart Data Integration

Regards,
Florian

Show 2 Share
10 |10000 characters needed characters left characters exceeded
Former Member

Thanks Florian, We do have SDI setup for other use cases but the problem we have there is handling volume of data. Most of the time DP agent gets break and so it is required for us to create virtual table manually , also it seems there is no artifacts or SQL way to create virtual table for SDI. This made us to think off with REST API call inside HANA in real time and moreover micro service options looks better going forward.

Regards

Siva

0

Hi Siva,

I do have the same requirement.but my requirement is to get the REST API web pages forms data into SAP HANA. If it's possible to call the REST API through the smart data access then Which adapter do we need to enable in SDI to access the REST API.

Aslo,can you please guide me on how we can configure REST API in HANA.

Regards,

VaraPrasad.

0