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