Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Now Live: Qlik Sense SaaS Simplified Authoring – Analytics Creation for Everyone: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
mdmukramali
Specialist III
Specialist III

connecting MySql Database on linux platform

Dear Community,

I have Mysql database on linux server which is on public ip.

     Qlikview is running on my  windows machine.

please somebody guide me how to connect mysql database from qlikview.

(procedure for creating ODBC connection on linux server).

i highly appreciated your help.

Thanks,

Mukram.

5 Replies
datanibbler
Champion
Champion

Hi Mohammed,

well, there should be ODBC connectors available for Linux - depending on which distro you have... just have a look, there's plenty of sites around with OSS for Linux.

The procedure from QlikView then is the same as for a Windows-hosted SQL database, you can use SQL in QlikView - or there's even a Wizard to both connect (create a connect_string in the script) and select data.

Best regards,

DataNibbler

mdmukramali
Specialist III
Specialist III
Author

Dear ,

On Linux server mysql version:  MySQL 5.0.95.

so do i need to install the same mysql 5.0.95 connector on my machine?

Thanks,

Mukram.

mdmukramali
Specialist III
Specialist III
Author

Dear,

I try to connect it but I'm getting the below error.

somebody help me to solve the issue.

Thanks,

Mukram.

Not applicable

Hi Mukram,


'secure_auth' enable


Can you resolve the problem with the conection?

I´m getting the same issue.


Best regards,

Angel

nidhibatra10
Contributor
Contributor

Hey,

Did you get any solution to this?

Thanks,

Nidhi Batra