Skip to Content
Author's profile photo Mathieu GRAVIL

SAP LUMIRA with MYSQL connector

First you need to download connector on http://dev.mysql.com/downloads/connector/j/downloads.

/wp-content/uploads/2013/09/1_275976.png

untar/ unzip  it.

And after launch Lumira and click on new document  with Freehand SQL:

/wp-content/uploads/2013/09/2_275977.png

If connector is not install, you will have some red light on driver :

/wp-content/uploads/2013/09/3_276113.png

Click on MySQL 5 – JDBC Drivers and click on Add:

you need to restart :

/wp-content/uploads/2013/09/5_276115.png

/wp-content/uploads/2013/09/2_275977.png

And now you have green icon and you can enter connection information and click on validate connection:

/wp-content/uploads/2013/09/7_276117.png

/wp-content/uploads/2013/09/9_276123.png

if it is ok, you can click on Acquire:

(It seems lumira didn’t understans time format (it convert everything in 01/01/1970 🙁 . Thats why i use sql function to convert it in second).

Then you can acquire and make some reports:

/wp-content/uploads/2013/09/10_276122.png

Assigned tags

      2 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Former Member
      Former Member

      Hi Mathieu,

      Nice Blog, Thanks.

      Using SAP Lumira and Excel Data sources, I have generated some of the Graphically represented figures.

      Data Geek Challenge: Rajinikanth: Great Living Indian in India Cinema :

      http://scn.sap.com/community/lumira/blog/2013/09/09/super-star-rajinikanth

      Data Geek Challenge - Sachin Tendulkar Using SAP Lumira:

      http://scn.sap.com/community/lumira/blog/2013/09/01/data-geek-challenge--sachin-tendulkar-using-sap-lumira

      Regards,
      Hari Suseelan

      Author's profile photo Mathieu GRAVIL
      Mathieu GRAVIL
      Blog Post Author

      Yours are more interesting to know indian culture 😉 !!