Tahir Hussain “Bob” Babar from the SAP HANA Academy details how to connect to MySQL as a data source for SAP Lumira.

First, in his MySQL workbench, Bob quickly examines the film database, Sakila, he will be connecting to. Bob highly encourages that access rights be given to a specific user in the MySQL database so the user can load the data into SAP Lumira. Next, Bob shows how to install the JDBC drivers using the SAP Lumira Preferences by simply selecting the appropriate java file.

After selecting Query with SQL as a data set type, Bob enters the credentials and advance parameters for connecting to the Sakila database. Bob chooses the data table that he wants to work with and selects the columns of table he wants to load before finally importing his data into SAP Lumira.

Finally, Bob shows how to save MySQL data in the SAP Lumira cloud.


Bob’s quick tutorial video demonstrates how to simply connect to MySQL to source data for SAP Lumira.

Screen Shot 2014-02-24 at 10.48.09 AM.png

View other tutorials on SAP Lumira at the SAP HANA Academy.


SAP HANA Academy – over 500 free tutorial technical videos on using SAP HANA.


-Tom Flanagan

SAP HANA Academy

Follow @saphanaacademy

To report this post you need to login first.

4 Comments

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

    1. Tom Flanagan Post author

      Hi Bijan,

      Thanks for your interest in the SAP Lumira videos from the SAP HANA Academy. We like to encourage our readers to visit the SAP HANA Academy so they can more easily access the hundreds of tutorial videos available.

      Best,

      Tom

      (0) 
  1. ANGELA NOTARISTEFANO

    Ciao Tom,

    Ho installato i driver JDBC utilizzando le Preferenze di SAP Lumira selezionando il file java appropriato.

    Ho riavviato l’applicazione, ma la query con opzione di sql non è attiva.

    qual è il problema?

    AngelaJDBC drivers.pngquery with sql.png

    (0) 
    1. Henry Banks

      Hi Angela,

      it seems to me you are using the free ‘personal edition’ (with less functionality)

      /wp-content/uploads/2014/03/more_less_402584.png

      for the additional connectivity options, you need to be using the premium ‘standard edition’.

      /wp-content/uploads/2014/03/more_options_402585.png

      regards,

      H

      (0) 

Leave a Reply