SAP LUMIRA with MYSQL connector

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

untar/ unzip  it.

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

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

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

you need to restart :

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

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: