Skip to Content

During the past month, i’ve been testing the connectivity of SAP Lumira with Spark on Azure was able to create great analytics.


here are the steps you need to follow :

1. Download and install Simba ODBC with SQL connector

2 .Configure the Simba ODBC with SQL connector

Guide: Spark ODBC Driver Quickstart



/wp-content/uploads/2015/07/1_745313.png



Configuration used in our testing:


/wp-content/uploads/2015/07/2_745314.png




3. Download and install SAP Lumira Spark extension


4. Launch SAP Lumira


/wp-content/uploads/2015/07/3_745315.png



5. Acquire Data:

/wp-content/uploads/2015/07/4_745316.png

/wp-content/uploads/2015/07/5_745317.png

6. Datasource selection:

Hint: it might be hidden behind the “add new dataset screen”

/wp-content/uploads/2015/07/6_745318.png

/wp-content/uploads/2015/07/7_745319.png

6. Press OK

7. Enter the password

/wp-content/uploads/2015/07/8_745320.png

  • Optional : Test the connection

/wp-content/uploads/2015/07/9_745322.png

/wp-content/uploads/2015/07/10_745321.png

8. Press Ok, then ok

9. You can either select an entire table as the data set

/wp-content/uploads/2015/07/11_745323.png

/wp-content/uploads/2015/07/12_745324.png

10. Or fitter the data with SQL statements

/wp-content/uploads/2015/07/13_745328.png

Hint: if you face issue here, you may wanna try the query within beeline to make sure the syntax is ok and nothing is wrong with the cluster

/wp-content/uploads/2015/07/14_745329.png

/wp-content/uploads/2015/07/15_745330.png

/wp-content/uploads/2015/07/16_745331.png

/wp-content/uploads/2015/07/17_745332.png

11. Re-enter the password.

Hint: it might be hidden behind the “add new dataset screen”

/wp-content/uploads/2015/07/18_745333.png

/wp-content/uploads/2015/07/19_745337.png

/wp-content/uploads/2015/07/20_745338.png

/wp-content/uploads/2015/07/21_745339.png

enjoy 🙂























































To report this post you need to login first.

Be the first to leave a comment

You must be Logged on to comment or reply to a post.

Leave a Reply