topic Connecting with LocalDB in Qlik Sense Business in Connectivity & Data Prep

Connecting with LocalDB in Qlik Sense Business

AG — Thu, 23 Dec 2021 14:42:03 GMT

I am not able to create a connection to database sitting in SQL Express Server Local DB in Cloud (Qlik Sense Business). In Qlik Sense Desktop version , this connection could be created by connecting through 'OLE DB' connector, then selecting SQL server Native Client 11.0 and then putting the server name directly in format '(LocalDB)\instancename'and using Windows authentication for UserName & Password

It is mentioned in support documentation that 'OLE DB' connector is not available for Qlik Sense Business.

Is there a way to connect to Local DB using 'SQL Server' connector or any other connector? Also 'SQL Server' connector require lots of input eg. port name etc. which I am not able to figure out.

PS: I am not from a Network(IT admin) background, so please elaborate if any technical steps involved.

Re: Connecting with LocalDB in Qlik Sense Business

Roger1 — Tue, 28 Apr 2020 14:23:38 GMT

Hello,

We have the same issue.

We can't get the connection from Qlik Sense Business to a SQL Express server working. When we try to connect using an ODBC connection from a windows 10 PC it's working fine, but when we use the same settings in Qlik Sense Business we get the following error using the "Test Connection" button: "ERROR[08001][unixODBC][MySQL](1001) Error occurred while creating socket with message :Name or service not known."

Re: Connecting with LocalDB in Qlik Sense Business

Roger1 — Wed, 29 Apr 2020 05:44:50 GMT

Hello,

We’ve found a solution to make the connection. It seems that Qlik Sense Business must be able to connect over the internet towards the local SQL server. For that we'd set a fixed TCP port on the SQL server and a NAT rule in the firewall. It’s not the most secure way to make a connection. The description can be found on https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/LoadData/connect-data-sources.htm?_ga=2.230074907.660668870.1588056888-49129292.1552895514&_gac=1.207962406.1588056888.EAIaIQobChMI-sSb88SK6QIVUed3Ch2MYA1aEAAYASAAEgLWAvD_BwE