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/

[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.