topic Re: Sql Server Connection in Connectivity & Data Prep

Sql Server Connection

aghabdurauf — Thu, 23 Dec 2021 19:48:54 GMT

Hi All,

I am using Qlik Sense Cloud and I want to extract data using SQL Server, hence Qlik Cloud cant support ODBC and OLEDB connectors for SQL Server.

I use SQL Server Connector which is available in Qlik Sense Cloud when I create a connection it generates the error of username password and host.

My SQL Server is log in with windows authentication.

Kindly help me out.

Kindly Regards

Agha

Re: Sql Server Connection

stevedark — Fri, 28 Aug 2020 13:17:06 GMT

Hi @aghabdurauf

I don't think you will be able to use a Windows login to your SQL Server, as the Qlik Cloud instance is not on the domain of your SQL Server.

Suggest setting up a new user, with username and password access, and giving that uesr very limited access to the database - just to the area you want to load into Sense.

You will need to put your SQL Server into mixed mode authentication to do this. This may cause issues for your DBAs. If this is the case you may need to find another route for getting the data into Qlik Cloud.

Hope that helps.

Steve

Sql Server Connection

Benito_Sanchez — Wed, 02 Sep 2020 14:21:33 GMT

Hi @aghabdurauf

I' m not an exprert but i think u need to use Qlik Data Transfer, install on ur SQL Server and make the connection and set wich app on Cloud to be refresh after extracction.

0 ) Install Qlik Data Transfer

1) You can create ODBC to ur SQL Server

2) You can create Qvf app using ODBC to extract all tables u need

3) Config into Qlik Data Transfer to execute Qvf app, ather this you can set witch app in the Qilk Sense Business (SaaS) want to update and this data will be upload to this app into Data "Files Folder" like qvd's files

4) now you need to update the sources into your app.( to use this qvd's)

I hope this info can help you

https://www.qlik.com/us/products/qlik-data-transfer

Re: Sql Server Connection

stevedark — Fri, 04 Sep 2020 10:02:00 GMT

This looks quite neat. I need to give it a try. Thanks for sharing @Benito_Sanchez