Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Customer & Partners, DEC. 9, 11 AM ET: Qlik Product & Strategy Roadmap Session: Data Analytics REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
gsbeaton
Luminary Alumni
Luminary Alumni

Connecting to mySQL DB over SSh

Hi folks,

has anyone tried connecting to a mySQL db over SSH?  I haven't found a connector that can do that easily.  I can create a tunnel using Putty, but ideally, I'd like to find a connector that does the whole thing in one go.

Any ideas?

many thanks

George

4 Replies
CamilleA
Contributor II
Contributor II

Hi,

I know this post is long time ago but did you find a solution for the problem?

Thank you !

Bernie89
Contributor
Contributor

Hello @gsbeaton,

Sorry I don't have any idea about it. many thanks for sharing!

George_FTI
Luminary Alumni
Luminary Alumni

Hi Camille,

Wow, yes that was a long time ago - almost 10 years!

I haven't had to do this for a while, but my vague memory was that rather than rely on an SSH connection sitting between QlikView and the mySQL server, I installed a certificate directly into mySQL and connected directly this way. This method is just as secure and means you don't need to worry about the extra layer of starting Putty every time you want to load new data.

I hope that helps.

George

CamilleA
Contributor II
Contributor II

Hi George,

Thank you very much, I will suggest this option to the dev team !

I hope it will suit them.

Camille