Skip to Content
Author's profile photo Tom Flanagan

SAP Lumira: Connecting to MySQL as a Data Source

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

Assigned Tags

      You must be Logged on to comment or reply to a post.
      Author's profile photo Former Member
      Former Member


      Can the video not be available here?


      Author's profile photo Tom Flanagan
      Tom Flanagan
      Blog 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.



      Author's profile photo Former Member
      Former Member

      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

      Author's profile photo Henry Banks
      Henry Banks

      Hi Angela,

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


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