Qlik Community

Ask a Question

Qlik Sense Data Connectivity

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

Announcements
Talk to Experts Tuesday, January 26th at 10AM EST: Qlik Sense. REGISTER NOW
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
Creator III
Creator III

Not applicable

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>

Creator III
Creator III

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

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>

Creator III
Creator III

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

Not applicable

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>

Creator III
Creator III

great!

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

Not applicable

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>

Contributor II
Contributor II

Your link is not available.

Please provide new link