Skip to Content
Author's profile photo sasitharan ravindar

SAP Lumira on Big Data

In my previous post, we have covered on how to setup & analyse in big date in Hadoop environment via Hortonworks Apache Ambari portal: Big Data Sample Setup & Visualization in Ambari.

The data is already in Hortonworks hadoop big date environment. Let’s try to incorporate the data into SAP environment. Choosing SAP Lumira in this case. Why choosing SAP Lumira out of other SAP BI Portfolios?

SAP Lumira Server is a native SAP HANA application that is deployed directly on the appliance and therefore has a natural ability to work on complex or large data and leverage the full power of SAP HANA.” By Product Manager of SAP Lumira Server 

Useful blog to understand : future roadmap of SAP Lumira.

Create Connection in SAP Lumira to Hadoop Big Data

Open SAP Lumira, navigate to Datasets. Click on “New Document”

In Add new dataset, we have few options to connection with Hadoop environment. Using “Query with SQL” connection option to connect with. ORC(HIVE) tables directly to retrieve data from Hadoop.

Choose the Apache connection driver

Key in Ambari login credentials and port details

From the above screen, click “Advance” button to specify driver properties.

Connected to Hortonworks hadoop Hive tables. All the available table setup in my previous post now reflecting in SAP Lumira.


Analyse Big Data in SAP Lumira

Data from .ORC(HIVE) now available in SAP Lumira via Hadoop connection. Remember the Truck data we have loaded in HIVE? Going to use that data to create a LUMIRA story Board.

Choose all the data from “truck_mileage” table

Choose the relevant dimension and measures for visualization

Create Visualization

SAP Lumira storyboard, showing “Top 10 Trucks with Best MPG” & “Top 10 Trucks with Worst MPG”. Which purely derived from big data source. *Mileage per gallon(MPG). With such information, the transportation company know which are the truck needs more attention for service & maintenance. Which can reduce cost of operation & improve income per truck in long run. And the information is readily available for business users in an intuitive display, SAP LUMIRA.

SAP’s Big Data partnership which discussed in my previous post, now clearly proven theoretically & technically. Proof Of Concept(POC), Done.

Bravo, SAP & Hortonworks.

Assigned Tags

      You must be Logged on to comment or reply to a post.
      Author's profile photo Blair Wheadon
      Blair Wheadon

      Lumira Server for HANA is end-of-life. Suggest you edit your opening paragraph.



      Author's profile photo sasitharan ravindar
      sasitharan ravindar
      Blog Post Author

      Hi Blair, thank you for the insight. Included the the link as additional information to provide accurate future roadmap of SAP Lumira for readers.

      Author's profile photo Leonard Tan
      Leonard Tan

      Hey Sasi,

      Nice Blog Series! Straight forward, easy to understand and follow 🙂


      Author's profile photo Ravi Kalidindi
      Ravi Kalidindi

      Hi Sasi,

      Thank you for the blog. Can you please help me on the configuration of Lumira connectivity with hive when we have a kerberos enabled on hive and we use windows authentication to log into hive.



      Author's profile photo sasitharan ravindar
      sasitharan ravindar
      Blog Post Author

      Hi Ravi, can you drop me screen capture or some simple step on where you are stuck at the moment? my email