Skip to main content
Announcements
Qlik Connect 2025: 3 days of full immersion in data, analytics, and AI. May 13-15 | Orlando, FL: Learn More
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Connect with mysql database in localhost & remote webhosting

Hi,

How to connect Qlik Sense with mysql database which is in localhost ? remote ?


I tried to do that using 'Data Connections' -> 'Create new connections'.


But I couldn't find correct steps for it.


Please support me.


Bye

9 Replies
Anonymous
Not applicable
Author

Not applicable
Author

Dear ,

Thanks for your support. But I couldn't solve the problem. I downloaded &

installed the Mysql_windows connector. Then followed the instruction

given (https://help.qlik.com/sense/en-us/online/#../Subsystems/Hub/Content/LoadData/ODBCDataConnection.htm

)

<https://help.qlik.com/sense/en-us/online/#../Subsystems/Hub/Content/LoadData/ODBCDataConnection.htm>

given by you. But I can view only these database connecting sources only;

Please support me on this matter to connect with MySql database.

Thank you

<https://help.qlik.com/sense/en-us/online/#../Subsystems/Hub/Content/LoadData/ODBCDataConnection.htm>

*Have a Nice Day...>>Best Regards From Lt Udara Pathirage Master of

IT, UCSC, Colombo | BSc in ENCM, Kelaniya | Dip. IT, NIBM

Software Engineer (IT OFFICER)*

  • Directorate of Information Technology*

  • SRI LANKA ARMY*

*Email: udara86@gmail.com <udara86@gmail.com>

udara@army.lk <udara@army.lk>*

*Web: http://udara.umpwebsolutions.com

<http://udara.umpwebsolutions.com/>SkypeID: udara1986Phone: 094 71 8110497*

On Thu, Apr 16, 2015 at 9:53 PM, Boris Tyukin <qcwebmaster@qlikview.com>

Anonymous
Not applicable
Author

it shoud show up under System DSN and you have to create that DSN first using Windows ODBC Admin tool.

Also pay attention to your windows system version (64 bit or 32) and a driver version you downloaded (64 vs. 32).

They should match.

If your windows is 64 bit but driver is 32, it is a bit more difficult to setup so check on that

Not applicable
Author

Thanks, From where can I find "Windows ODBC tool" ?

Bye

*Have a Nice Day...>>Best Regards From Lt Udara Pathirage Master of

IT, UCSC, Colombo | BSc in ENCM, Kelaniya | Dip. IT, NIBM

Software Engineer (IT OFFICER)*

  • Directorate of Information Technology*

  • SRI LANKA ARMY*

*Email: udara86@gmail.com <udara86@gmail.com>

udara@army.lk <udara@army.lk>*

*Web: http://udara.umpwebsolutions.com

<http://udara.umpwebsolutions.com/>SkypeID: udara1986Phone: 094 71 8110497*

On Fri, Apr 17, 2015 at 8:11 PM, Boris Tyukin <qcwebmaster@qlikview.com>

Anonymous
Not applicable
Author

in control panel, type "odbc" in search box. make sure again your windows os version and driver version "bitness" is the same

Not applicable
Author

Thanks lot, I could connect with my loalhost mysql DB, Then what about if I

will going to connect my remote mysql database which is hosted in other

location ?

Am I need to adhere same steps and procedures to connect with it? But its

and public vbs cloud mysql db..

Thanks

*Have a Nice Day...>>Best Regards From Lt Udara Pathirage Master of

IT, UCSC, Colombo | BSc in ENCM, Kelaniya | Dip. IT, NIBM

Software Engineer (IT OFFICER)*

  • Directorate of Information Technology*

  • SRI LANKA ARMY*

*Email: udara86@gmail.com <udara86@gmail.com>

udara@army.lk <udara@army.lk>*

*Web: http://udara.umpwebsolutions.com

<http://udara.umpwebsolutions.com/>SkypeID: udara1986Phone: 094 71 8110497*

On Sat, Apr 18, 2015 at 6:39 AM, Boris Tyukin <qcwebmaster@qlikview.com>

Anonymous
Not applicable
Author

great!

same idea but you will need a hostname / port for that remote database. Talk to the person who maintains that database

Not applicable
Author

Yea, I will get those from our DB admin and have a try. Then let you know

any issues may encounter me.

Thanks

bye

*Have a Nice Day...>>Best Regards From Lt Udara Pathirage Master of

IT, UCSC, Colombo | BSc in ENCM, Kelaniya | Dip. IT, NIBM

Software Engineer (IT OFFICER)*

  • Directorate of Information Technology*

  • SRI LANKA ARMY*

*Email: udara86@gmail.com <udara86@gmail.com>

udara@army.lk <udara@army.lk>*

*Web: http://udara.umpwebsolutions.com

<http://udara.umpwebsolutions.com/>SkypeID: udara1986Phone: 094 71 8110497*

On Sat, Apr 18, 2015 at 7:01 AM, Boris Tyukin <qcwebmaster@qlikview.com>

ChandrashekharB
Contributor II
Contributor II

Your link is not available.

Please provide new link