Access HANA Odata APIs

[fralarsen]

Hi HANA experts,

How to access the HANA predefined OData services ? Does they have any generic endpoints ?

What are the available APIs and how to get access to them on a system registered on cal.sap.com

Regards,

Naresh

[fralarsen · Accepted solution]

Any comments from the experts ? I'll still trying to figure out how to access HANA Odata APIs, if at all any exist ?

Regards,

Naresh

[thomas_jung · Accepted solution]

I think you aren't being specific enough.  What OData APIs are you expecting/looking for? 

[fralarsen · Accepted solution]

Hi Thomas,

Thanks for the response. I'm working on an IDM tool to integrate applications and databases. In this context, we have provided integration to SuccessFactors system using the standard available API's. Similarly, I would like to know if there are any standalone API's to connect HANA DB ?  I'm looking for information like the HANA DB Users and assigned Roles to the Users.

Are there any standard API's to access this data or do we need to develop a data-model to fulfill such a requirement.

Regards,

Naresh

[thomas_jung · Accepted solution]

There are not OData APIs for these things.  There are SQL APIs and views.  And HANA contains a generic OData framework which allows any table or view to be the source of an OData service.  So if you really want an OData service to expose Roles or Users, the you will have to create it upon the SYS.ROLES and SYS.USERS views.

[fralarsen · Accepted solution]

Hi Thomas,

Is it advised to expose the contents of these system tables/views as Odata Services ?  will CRUD operations be directly applied on views  as we would also enable Creation / Modification of the Users and Roles using the services or do we need to use some built-in functions or procedures for Create, Modify and Update functionalities?

[thomas_jung · Accepted solution]

>Is it advised to expose the contents of these system tables/views as Odata Services ?

Create an OData service for what amounts to a public API view is really no different than accessing it via SQL

>will CRUD operations be directly applied on views  as we would also enable Creation / Modification of the Users and Roles using the services or do we need to use some built-in functions or procedures for Create, Modify and Update functionalities?

No CUD is never enabled for any view. That wouldn't make sense.  If you want create/modification of users and roles you would have to use OData exits and call the corresponding SQL syntax for these operations.

[fralarsen · Accepted solution]

Hi Thomas,

Thanks for the guidance and answering my questions.

Regards,

Naresh

[jadhvaryu · Accepted solution]

Hi Thomas,

Sorry to piggyback on an existing thread. And my question is not limited to HANA.

I am independent developer and need to build a mashup in few business areas using SAP as one of the system.

I am looking for a way to know the APIs, web services, BAPIs etc that SAP products already have and documented to help me with understanding the scope of the services and way to consume.

Many years ago, SAP used to publicly publish BAPI directory and then ES Directory so any one with ideas can browse, learn and develop.

It is bit urgent and hence would appreciate quick guidance.

Thanks!

Jaideep