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.