SAP ODATA Service as Dataset at Lumira
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.
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.