Skip to Content

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

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