Connect SAP Analytics Cloud to SAP IoT Application Enablement

Introduction

If you are a data analyst for sure you will need to load the timeseries history data for sensor reading or other kind of IoT AE related data into your own tools.

Because you will not have a link to the direct source of data then you’ll need to connect the OData services provided by IoT AE.

IoT AE services security is handled by SAML auth provider and it’s not compatible yet to be consumed by Sap Analytics Cloud. There is an workaround to use a OData “proxy” custom app that is secured with Basic Auth and handles the IoT SAML auth flow inside of it.

This blog post helps you jump start the connection and it’s covering the 2 steps for doing that :

Clone and deploy an OData “proxy” secured with Basic Auth on the SCP CF landscape (the data “proxy” is a workaround, the authentication will be probably address in the future by SAP Analytics Cloud)

Connect Data to SAP Analytics Cloud and analyse/display it

Get an SAP Analytics Cloud Tenant (SAC)

Login in to you SAC tenant

Go to Main Menu -> Connections and Create a new connection for OData Service (use and odata version 2.0 service)

Go to Main Menu -> Create -> Model and select “Get data from an app”. After that select “OData Services” as for “Connection Type”, your OData connection from “Connection Name” dropdown and “Create a new query” and click “OK” button

Select and Filter data from your model to be imported in SAC Model

Adjust your SAC Model, name it and after that click the “Create” button (down to the right)

Go to Main Menu -> Create -> Story to create a new dashboard, report or presentation

Start with “Add a canvas page” (you have defined your data model already) and select “Add Data” from the left side menu options. Of course “Existing model” will be present in the dropdown and please select it before pressing “OK” button