Qlik Community

Ask a Question

Connectivity & Data Prep

Discussion board where members can learn more about Qlik Sense Data Connectivity.

Announcements
Our May 2021 end-to-end product release from Data Integration to Data Analytics is out! READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
walkasia
Contributor III
Contributor III

MySQL connection from Qlik Sense Business Cloud

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!

1 Solution

Accepted Solutions
walkasia
Contributor III
Contributor III
Author

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!

 

 

View solution in original post

4 Replies
rbfxKirychenka
Contributor
Contributor

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
Contributor III
Contributor III
Author

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!

 

 

View solution in original post

rbfxKirychenka
Contributor
Contributor

We use MySQL Percona server 5.6.x

How can we connect this data source from the cloud?

Please assist.

Anonymous
Not applicable

Same problem with MySQL, can't connect.