topic Re: Microsoft SQL connector in Connectivity & Data Prep

Microsoft SQL connector

abongwa — Tue, 02 Nov 2021 17:48:38 GMT

I have an active database on my desktop computer in Microsoft SQL 2019 Express. I am using the Microsoft SQl connector to QLIk to try to export my data into QLIK sense cloud version, but it continues to fail. I am not sure, I do not think its firewalls related considering I can already export a CSV file. I follow all the procedures, credentials etc. Please advice if any other options. I am wondering if the suggested port might be blocked?

thanks

Re: Microsoft SQL connector

Vinay_B — Thu, 04 Nov 2021 06:51:32 GMT

Hi @abongwa,

If you're not using the IP address, try that and make sure it's the external IP address as the internal one will not work. Also, check out this video. It will walk you through the prerequisites for connecting to a local database from the cloud and gives open SQL credentials that you can use to test and ensure there is nothing happening with the tenant.

https://www.youtube.com/watch?v=RjdQu5ZjuRY&list=PLdnQXZq2xRoA7CBXn8wiYB184rP1HzRKe&index=5

Any further issues, error and configuration screenshots will be helpful in investigating.Thanks!

Re: Microsoft SQL connector

abongwa — Fri, 05 Nov 2021 21:23:09 GMT

Vinay, thanks, I will work on this tmr and let you know. I expected this to be a firewall issue

Re: Microsoft SQL connector

Vinay_B — Fri, 19 Nov 2021 13:38:15 GMT

Hi @abongwa,

Let us know if you were able to connect to your SQL database.

Thanks!

Re: Microsoft SQL connector

abongwa — Thu, 23 Dec 2021 20:07:05 GMT

Not really, there is a suggestion from Qlik that I need a <tenantname> which they say I should have gotten when I paid for my account. I did not get one and so I am wondering if there is another way to get <tenenatname> . I am assuming its not my email.

For a system which relies on data import, I am still not sure why making this connection is soo complicated for the cloud version.