Expose SAP DATASPHERE OData to Build Apps

[DKK]

Hello,

Is it possible to expose SAP DATASPHERE OData , using BTP Destination to SAP BUILD APPS?

Thank you.

[DKK · Accepted solution]

Hi, thank you for your reply. We have tried to implement this scenario but we did not succeed mainly due to Authorization issues. We have implement the OAuth Clients on SAP Datasphere part and add the details on the BPT Destination layer.Then we tried to consume this destination on the SAP Build Apps without success.

Thank you.

[DKK · Accepted solution]

Finally , there is a "detailed" solution on how we can achieve it.

https://community.sap.com/t5/technology-blogs-by-sap/using-sap-datasphere-consumption-apis-in-sap-bu...

Thanks @gustavokath !

[martinstenzig]

The only way I can see putting the pieces together is to

1. Build the data model in i.e. CAP which can expose your data model as OData services

2. Then change the deployment approach to deploy the HDI container to the DataSphere HANA instance.

3. In DataSphere you can then use access to the external HDI container and build your views on that.

The even easier alternative, but not as performant from a DataSphere viewpoint is to keep the CAP service decoupled from DataSphere and just use it as OData Source "underneath" Datasphere.

[DKK]

Hi,

You are correct, this is how we have done it , but since SAP Datasphere OData was introduced ,we were hoping to consume it directly to Build Apps,as it is possible to SAP SAC or PowerBI.

Thanks

[iwilson-nimbl1]

Hi Dimitrios,

Were you able to create a BTP destination direct to a Datasphere Odata URL? I also seem to have issues with authentication I believe due to the three legged authentication requirement. When I create a Destination in BTP, I tried with OAuth2ClientCredentials and entered the oauth client ID and Secret that we created in Datasphere -> Administration -> App Integration, but I haven't been able to successfully connect. Wondering if you were able to make progress?