MySQL connection from Qlik Sense Business Cloud

[walkasia]

All -

We are a non-profit that has been happily using Qlik Sense Desktop for a number of years.  We connect to our MySQL database with many many robust SQL statements.  Now that Desktop will no longer be available except to Enterprise users, we are trying to transition to Business Cloud, as Enterprise is too expensive and complicated for our use.

I am trying to connect to our MySQL database from the Business Cloud apps.  I am able to get a successful connection, but when I send even the simplest query, I receive the error: "Connector error: Could not parse SELECT statement".     

I have read comments from the 2018s that indicate that MySQL connectivitiy is not possible from Business Cloud.  Is that indeed true?  That is a show-stopper for us. 

Really hoping I am just missing something obvious here.

Thanks in advance!

[rbfxKirychenka]

Hi, 
I can confirm that this is critical issue for us as well.

- I am using Qlik for 3 years.

- We have 5 users and 600 Mb of data: MySQL, Google BigQuery, excel files.

- Qlik pushed us to migrate from “Qlik Sense Desktop“ to “Qlik Cloud”.

- We paid for 5 users and Qlik Sense Business International till 2021

As the result, we don’t know how to connect MySQL to Cloud version. There is no such option. In Qlik Sense Desktop we used ODBC driver. 

Is there any third party options to connect MySQL to Qlik Cloud?

[walkasia · Accepted solution]

Okay... Success!

For me, there was one fundamental and simple problem.  In Desktop, we had just one data connection that we issued a "LIB CONNECT" statement for at the top of the script.  Our other data connections were referenced in the FROM statements when selecting the data.   In the Cloud, we are also connecting to these other data connections with "LIB CONNECT" statements.  What I have learned is that when a LOAD and SELECT statement runs, it is using the MOST RECENT data connection that has been connected to.  So I can't just LIB CONNECT to all of them at the top.  I have to intersperse the CONNECT statements at the appropriate places in the script.  Once I figured that out, my parse error went away.

In figuring that out, though, I found things that may be helpful to others that are encountering problems with connecting from the cloud to an on-premise MySQL database.  So here are some helpful resources:

To pull data through a firewall:  https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/LoadData/connect-data-so...

Qlik Sense Cloud Business - MS SQL Connector video:  https://community.qlik.com/t5/Qlik-Sense-Documents-Videos/Qlik-Sense-Cloud-Business-MS-SQL-Connector...

Hope this helps someone!

[rbfxKirychenka]

We use MySQL Percona server 5.6.x

How can we connect this data source from the cloud?

Please assist.

[Anonymous]

Same problem with MySQL, can't connect.

[Ken_T]

whereever your database resides, who ever manages that network will have to set up security to allow incoming network traffic from the qlik cloud system to be able to access the database.   qlik support might be able to help. also, once you get a paid qlik cloud account, you should be able to authenticate qlik sense desktop from your SaaS tenant. couple community posts on that topic, too.