SAP LUMIRA with MYSQL connector
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: