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.