Hello,
I'm hoping someone can help me. I need to connect QlikView (Nov 2017 Update 3) to an Azure DW db using SQL Auth. How would I go about doing that?
I have a test Qlik Sense environment (April 2018) set up and I could connect to the Azure DW db from there using the Microsoft SQL Server connector that comes with Sense. We aren't anywhere close to having Sense set up for production so I need to use QlikView to do this.
I successfully used ODBC Driver 17 for SQL Server in QlikView, but I have to enter the Password manually every time the data needs to refresh. this won't work when we try to run the reload through QMC.
Is there a driver I can download and install for this to work in QlikView?
Any help would be greatly appreciated!
And if I should update where this question is posted, please tell me how!
Thank you,
Liz