topic Re: Connect with mysql database in localhost & remote webhosting in Connectivity & Data Prep

Connect with mysql database in localhost & remote webhosting

Thu, 16 Apr 2015 10:23:28 GMT

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

Re: Connect with mysql database in localhost & remote webhosting

Anonymous — Thu, 16 Apr 2015 16:08:34 GMT

you will need to install MySQL driver (connector) first

MySQL :: Download Connector/ODBC

then follow this for ODBC

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

Re: Connect with mysql database in localhost & remote webhosting

Fri, 17 Apr 2015 08:59:07 GMT

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>

Re: Connect with mysql database in localhost & remote webhosting

Anonymous — Fri, 17 Apr 2015 14:41:46 GMT

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

Re: Connect with mysql database in localhost & remote webhosting

Sat, 18 Apr 2015 01:02:09 GMT

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>

Re: Connect with mysql database in localhost & remote webhosting

Anonymous — Sat, 18 Apr 2015 01:08:57 GMT

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

Re: Connect with mysql database in localhost & remote webhosting

Sat, 18 Apr 2015 01:28:33 GMT

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>

Re: Connect with mysql database in localhost & remote webhosting

Anonymous — Sat, 18 Apr 2015 01:31:11 GMT

great!

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

Re: Connect with mysql database in localhost & remote webhosting

Sat, 18 Apr 2015 02:41:46 GMT

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>

Re: Connect with mysql database in localhost & remote webhosting

ChandrashekharB — Mon, 23 Sep 2019 05:13:43 GMT

Your link is not available.

Please provide new link