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.
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.