SAP Analytics Cloud connection to Thing Model

[bonnkp]

After attempting to implement the following solution

https://blogs.sap.com/2018/01/24/how-to-connect-sap-analytics-cloud-to-sap-cloud-platform-iot-applic...

we came to realize that the proxy application might no longer be necessary due to SAP including the OAuth2.0 functionality into the Analytics Cloud. However, for this purpose we need to specify the data service URL, supposedly from the Thing Model in our Application Enablement service. We would appreciate if someone could pinpoint where to find this URL or if there is another way to connect our Thing Model to the SAC.

[marcus_behrens · Accepted solution]

Hi, even if you get across the OAuth authentication hurdle there are still other issues (e.g. thing model does not support odata $inline_count and more) that will make this an uphill battle. But there is good news - we _plan_ to provide a more direct integration possibility, that will allow you do live data access and that works out of the box in the next weeks like we offered in some of the iot applications. Not the improved features but the new name "Leonardo IoT" was announced at MWC last week.

If you have to prototype something now I in SAC I suggest you do an extract via the odata api and upload that for prototyping into SAC and hold off on doing a "real" integration until the above mentioned improvements makes its way to you.

If you have built your thing model with the rest-based thing modeler please consider migrating to the odata-based thing model. This is a pre-requisite for the above and many other new features. To migrate your meta-model while keeping all things and time series intact open a ticket on IOT-BSV-TS component. Regards, Marcus

[former_member608040 · Accepted solution]

Hi Marcus,

I'm currenty in the same position. But I can't seem to find the correct OData URLs. I have found a couple of different ones for the Things, and for the measurements. (both 2 different urls, root URL returns "Not Found")
I did found the following for measurements (is this still relevant?):

https://help.sap.com/viewer/350cb3262cb8496b9f5e9e8b039b52db/1.57.0.0/en-US/7b25683251434599b83ff934...

But I can't find more documentation about it.

Where can I find a useful URL to enter and start testing in SAP Analytics Cloud?

Btw I've made everything in the OData Modeler

[former_member86450]

Hi Marcus,

I would be happy if you can give some guidance on Query Modeler in SAP Leonardo IoT instance to assign authorized role collection. i am trying to give QueryModeler_Admin but it is not accepting.After then I will be able to use ODATA in SAC. I am looking forward.

Regards

Sandeep

[marcus_behrens]

Hi, by now all tenants have been upgraded and after a quick migration of your meta data you should now be in a position to use the better integration to SAP analytics cloud provided.

The odata service you mention is not well suited as it provides the raw data only and probably this will overwhelm analytics cloud.

[mynynachau]

I've removed the link as it was incorrect (amazon link) please add the correct link.

thanks and best

Mynyna

[IG1]

Hi Marcus,

do we have any blog or documentation for live connection with IOT AE for SAC.

[former_member611699]

Hello marcus.behrens ,

I am using Leonardo IoT and am trying to connect SAP analytics cloud to it. I could achieve the connection using the mentioned odata service, but as you say, it seems there are limitations (Above 1000 rows, I have an error message).

So I created a query model in the new Leonardo IoT. But I did not find how to consume that query from SAP analytics cloud. Could you please advise on what kind of connection I must create in SAC and which url to use to consume my Leonardo IoT query model?

Thank you very much!!

Jonathan