SAP ODATA Service as Dataset at Lumira

Requirement

SAP Lumira is having the native integration capability to connect with multiple data sources Viz. Hana Database tables, Hana database views, Analytical views etc. This is now enabling the customers to visualize data from all sources irrespective of relational or non-relational data.  However, there is another possibility for data source as a service from SAP – ODATA .  This document indicates the steps to create this OData service at SAP back end and using the same service to fetch data from Lumira and visualize/present the same as charts.

Pre-Requisite

We need to have following components in place in order to achieve this connectivity between SAP OData service and Lumira Story visualization.

• Data Model ( Table structure that provides data through OData service ) –  T-Code SE11
• Odata service and method created and activated – T-Code – SEGW
• Odata Connector
• Lumira 1.25.1

How to Implement

       Step 1 – Create Odata Service

       Create ODATA service in SAP using SEGW. 

       Step 2 – Activate the Service

       Activate the service in SAP using SPRO

      Step 3 – Test the Service

       Test the Service and make sure that it fetches and displays the data in xml or json format.

      Step 4 – Create Data Set at Lumira

       Create a Lumira document using new data set connection. Open Lumira,  File –>New . 

       You will be finding an option called Query with SQL.  Please refer to the image below.

• Step 5 – Select the option Query with SQL and press Next.  It will show you all the Data Connectors that are enabled in the Lumira installation.

• Step 6 – Select the Generic OData 2.0 Data connector.  This will enable us to connect to the OData service

                   that we enabled at SAP side. Then press Next

                   You will find a screen that ask for the URL , UserIDs and Password to connect to the Service.

Step 7 – Enter the Details of service url

Step 8 – You will get the catalog information.  Select them and Preview it.

Step 9 – Preview the Data and Press Create

Step 10 – There you are.. You are getting the model.  Now you can start creating your charts. You can see the measures and dimensions created

               in the left panel, thereby you can drag and create your charts.

I will be updating this document to further enhance all micro level steps/issues I faced during  these steps.  I hope this will help you.  kindly update your feedback  and comments and any issues you face as well.