Partner App: SAP


SAP Lumira enables business users to analyze data and get unique insight in real time using the latest visualization technologies. Discover how the software quickly processes large volumes of data and reduce time to insight. Lumira helps you gather, analyze and present the facts to solve your most pressing business questions – for any line of business.

Application Description

Use SAP Lumira to tap into the power of big data and see patterns emerge in front of your eyes. Lumira allows you to visualize data with an intuitive drag-and-drop interface and uncovers outliers and trends with engaging visualizations and stories. Organizations can maximize business knowledge with big-picture insights and granular details. Lumira lets you quickly process large volumes of data and reduce time to insight.

This demo shows the power of business insights gained from SAP Lumira and Apache Drill on Hadoop by combining data from multiple sources without complex or time-consuming ETL. In this example, sensor data (JSON) is being gathered from a variety of sensors along with packet data. You can see how SAP Lumira in combination with Drill queries helps you easily identify failed sensors and the root cause of the problem.

Creating a Lumira and Drill Sandbox with Example Data

How about a test drive of Lumira with Apache Drill in your own environment, giving you the ability to query JSON files directly with SQL and do more, faster? With just a few steps you can connect Lumira to your Drill cluster and run example queries on our sandbox data shown in the below demo video.

SAP Lumira

These steps assume the following:

Complete these steps to connect Lumira to your Drill cluster:

  1. Download SAP Lumira Desktop and follow the instructions for installation on your laptop/workstation.
  2. Download the sample data from MapR into your Drill installation. To get started quickly you can extract them into ‘/tmp’, then decide on a permanent location later.
  3. Perform the following steps in Lumira to setup the JDBC connection. You may need to press the '30 Days Trial' button to begin using the software.
    • Create a new data connection by selecting, Select File -> New, then 'Query with SQL'.
    • In the 'New Dataset' window, select 'Show All', then select the 'Generic JDBC Datasource' option and click the 'Install' button in the lower right of the screen.
    • Obtain the file $DRILL_HOME/jars/jdbc-driver/*.jar file from your Drill installation and copy it to the machine running Lumira.
    • Select the 'Generic JDBC Datasource' option and click 'Install Drivers' at the top right of the screen. Browse to the .jar file you copied earlier.
  4. Select 'Done' and restart the application if prompted.
  5. Return to the same screen (File -> New, etc.) and select the Generic JDBC Datasource which should now be shown with a green icon.
  6. Enter anything for the username/password (i.e. none/none).
  7. For JDBC URL, type: jdbc:drill:zk=[host][port]/drill/[quorumname], where [host] is the hostname and port for the ZooKeeper connection.
  8. For JDBC Class, enter org.apache.drill.jdbc.Driver.

You should now be able to run example queries by browsing to the sample data (that you extacted in a previous step) and running SQL queries. For a few examples, consult the video above. Happy Drilling!

Component Version Connection Method
MapR Distribution 4.0+ NFS, HDFS API
Drill 0.6+ ODBC JDBC
Application Version: 1.20

Download App