Expose data from Data Warehouse Cloud as OData service

[juanforero5]

Hello experts!.I am new to working with SAP Data Warehouse Cloud and would like to know if I can expose entities from my model as OData service to use in another application (for example, a mobile services application).I hope they can solve my doubt. Greetings from Colombia!!

[kpsauer]

Hi Juan,

you can expose the data via a SQL interface. To do that you enable the Exposing flag in your views.

After you have done that you can create the consumption interface in the space management by creating a database user for Data Consumption.

You get a SQL endpoint to connect external tooling to.

Best regards
KP

[YanGerzon]

Where do i see the SQL Endpoint?

[kpsauer]

You get the endpoint once you create the database user and the respective open SQL schema. If the user is already existing you can always come back to the endpoint details using the [i]

You will then get the connection details

Best regards
KP

[stefan_hoffmann2]

Hello Juan

this blog might be a possible solution to your question

https://blogs.sap.com/2021/03/18/expose-sap-data-warehouse-cloud-artefacts-as-odata-v4-service/

Best regards

Stefan