Skip to Content

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

To report this post you need to login first.

2 Comments

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

  1. Suseelan Hari

    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

    (0) 

Leave a Reply