topic Re: Connecting to mySQL DB over SSh in QlikView

Connecting to mySQL DB over SSh

gsbeaton — Wed, 29 Aug 2012 16:12:19 GMT

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

Re: Connecting to mySQL DB over SSh

CamilleA — Mon, 25 Oct 2021 14:30:36 GMT

Hi,

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

Thank you !

Re: Connecting to mySQL DB over SSh

George_FTI — Wed, 27 Oct 2021 10:03:22 GMT

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

Re: Connecting to mySQL DB over SSh

CamilleA — Wed, 27 Oct 2021 10:30:56 GMT

Hi George,

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

I hope it will suit them.

Camille

Re: Connecting to mySQL DB over SSh

timotheechalamet — Fri, 13 Oct 2023 12:10:36 GMT

es ist so ein erstaunlicher und informativer Beitrag und bietet eine Menge Informationen, aber für die aktuellen Elektronikschrottpreise können Sie auch dies heraus überprüfen Mehr lesen