topic Re: OCBC Connector MySQL in Qlik Sense HUB in Connectivity & Data Prep

OCBC Connector MySQL in Qlik Sense HUB

Rahell39 — Tue, 21 Dec 2021 20:32:44 GMT

Dear All,

Can you aid in a matter. I just recently started the Qlik Sense trial period, and need to connect to my data via a ODCB MySQL connector. I managed to this in the Desktop version, via installing the connector locally, but I am having issues with the HUB part due to the fact that I don't have the connector there. Is there any way I can install it in HUB or do I have to setup up a local Qlik Sense server?

Thx!

Re: OCBC Connector MySQL in Qlik Sense HUB

MayilVahanan — Wed, 09 Dec 2020 10:32:31 GMT

hi @Rahell39

You can use MYSQL connection directly instead of use ODBC.

Re: OCBC Connector MySQL in Qlik Sense HUB

AdamBSnotused — Wed, 09 Dec 2020 10:32:55 GMT

The way Qlik want you to manage this is to continue with Qlik Sense Desktop - authorized from your QS SaaS and download and use the Qlik DataTransfer - an on-prem utility that allows you to push data into the SaaS environment. From what I saw recently, this is the most secure way. Qlik DataTransfer is available from your account interface on SaaS. Go here for video and notes https://www.qlik.com/us/products/qlik-data-transfer

Re: OCBC Connector MySQL in Qlik Sense HUB

Rahell39 — Thu, 10 Dec 2020 21:11:19 GMT

Thx guys, both solutions work. @MayilVahanan I tried it initial but I was getting and error due to the fact the one of my IP was blacklisted. So after talking with the ADMIN, it worked. Sadly there is no way to have an ODCB connection in cloud version. Here @AdamBSnotused can be a work around.