Skip to main content

Qlik

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
elizabethward
Contributor III
Contributor III
‎2018-05-01 05:19 PM

QlikView support for connecting to Azure DW using SQL Auth

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

628 Views
0 Likes
0 Replies