How can we use a odata connection of datasphere to create datasets or models on sac?

[Henry_Lee]

How can we use a odata connection of datasphere to create datasets or models on sac?

fristly, we create a dataset with odata connection of datasphere but it only can choose a table or view of datasphere.   As below: 

secondly, if we use the api_url <https://.../api/v1/dwc/catalog/assets>, I suer that can't be connected on sac.

and we can get connection with <https://.../api/v1/dwc/catalog>, but we can't choose tables and views of datasphere, and we only can see space&assets

if we wanna use a odata connection to choose tables&views of datasphere, So how can we do for this?

Based lins:  https://help.sap.com/docs/SAP_DATASPHERE/43509d67b8b84e66a30851e832f66911/7a453609c8694b029493e7d87e...

https://community.sap.com/t5/technology-blogs-by-sap/sap-datasphere-analytical-and-relational-odata-...

https://api.sap.com/api/DatasphereCatalog/resource/

[cardoso]

Hi @Henry_Lee,

Consider checking out:

• Introducing the Bi-Directional Integration of SAP Data Warehouse Cloud and SAP Analytics Cloud for P...
• Consume Data via the OData API

Note: Currently, on SAP Analytics Cloud side, one OData Service connection needs to be set up for each SAP DWC (now SAP Datasphere) view that you want to connect to.

BR.
Ismael

[Henry_Lee]

Hi cardoso, Thank you so much , I Knew it , I just wanna know "do we hava any solutions for using one odata service connection to visit all views"

[Henry_Lee]

@TuncayKaraca 

As you can see, only a table that i can choose. 

[TuncayKaraca]

Hi @Henry_Lee,

First of all, your screenshots are so small that nothing is readable! You could stretch them out and make them bigger. 🙂

Your question & objective is very interesting indeed! -> "using a odata connection of datasphere to create datasets or models on sac" What is the use case here?

If you need to consume Datasphere data in SAC please check out Consume Data in SAP Analytics Cloud via a Live Connection 

Basically you need to create live connection from SAP Analytics Cloud to SAP Datasphere then you can data exposed as analytic models and perspectives to create stories and analytic applications in SAC. You don't need to create datasets or models explicitly for Datasphere data objects in SAC. 

Regards,
Tuncay

[Henry_Lee]

Cool , Thanks for your response！ In this case, I'm using the ODATA API to connecting datasphere in SAC. Fristly I use the API_URL[https://<tenant_url>/api/v1/dwc/catalog] to create ODATA connection in SAC. Then it was successfuly,But I can't choose any tables, views and analytic models when I create dataset in SAC. I only can see two tables which is space&assets. That means I can't choose any tables, views and analytic models. But If I use the API_URL[https://<tenant_url>/api/v1/dwc/consumption/analytical/<space_id>/<asset_id>] to create connection in sac that I can only create a dataset with this connection. that means, every connection only can choose a [table/view/analytic model] when i create dataset in sac So Do we have any other solution to solve this situation. May you can browse this website: https://help.sap.com/docs/SAP_DATASPHERE/43509d67b8b84e66a30851e832f66911/7a453609c8694b029493e7d87e...

[TuncayKaraca]

@Henry_LeeThanks for more details.

I see you are using SAP Datasphere OData with OData connection in SAC. If your intention is purely able to use & consume data from Datasphere. You need to create a Datasphere live in SAC, check out Live Data Connections to SAP Datasphere and Procedure Then you can use this Datasphere Live Connection in SAC directly while you create stories in SAC.