Skip to main content

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
QlikWorld 2023, a live, in-person thrill ride. Save $300 before February 6: REGISTER NOW!
cancel
Showing results for 
Search instead for 
Did you mean: 
uzername
Contributor III
Contributor III

Qliksense connector for Mysql Community Edition?

Qliksense server can't connect remotely to Mysql community edition.

I have tried a few suggestions on the forum regarding ODBC which didn't work.

Any clear instructions to fix this?

Thanks.

QS server : 10.3.5

Win: Windows Server 2012 R2

1 Solution

Accepted Solutions
uzername
Contributor III
Contributor III
Author

Solved:

1 - download and install MySQL ODBC connector (32 or 64)

2- if installation fails with error 126 you need to update MS Visual Studio libraries as below:

   - download latest VisualStudio redistributable file from Microsoft download centre (64 or 32)

   - remove old version first then install this file

3- Once Mysql ODBC driver is successfully installed open " setup ODBC data sources 64"

    by start typing ODBC in the windows interface

4- This opens "ODBC data administrator" window.

5- In the "system DSN" tab add a new data source by selecting the driver you just installed, username/pass,...

    test the connection and then save it.

6- in the Qliksense "add new connection" select ODBC, then select the connection you created in step 5.

7- Give it a proper name. Now you can connect to mysql, any version and extract data for Qlik sense.

I'm not sure why QS connection package only connects to MySQL Enterprise Version and not other versions.Considering that community version is the free one I'd expect the other way around.

End.

View solution in original post

1 Reply
uzername
Contributor III
Contributor III
Author

Solved:

1 - download and install MySQL ODBC connector (32 or 64)

2- if installation fails with error 126 you need to update MS Visual Studio libraries as below:

   - download latest VisualStudio redistributable file from Microsoft download centre (64 or 32)

   - remove old version first then install this file

3- Once Mysql ODBC driver is successfully installed open " setup ODBC data sources 64"

    by start typing ODBC in the windows interface

4- This opens "ODBC data administrator" window.

5- In the "system DSN" tab add a new data source by selecting the driver you just installed, username/pass,...

    test the connection and then save it.

6- in the Qliksense "add new connection" select ODBC, then select the connection you created in step 5.

7- Give it a proper name. Now you can connect to mysql, any version and extract data for Qlik sense.

I'm not sure why QS connection package only connects to MySQL Enterprise Version and not other versions.Considering that community version is the free one I'd expect the other way around.

End.