Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
gengisKwan
Contributor
Contributor

Data Manager ODBC not showing SQL server data warehouse views

Hi All,

I have confirgured Qlik Sense data manager to connect to a source Azure  data wearhouse correctly through ODBC drivers 17 and ADALSQL. But I only have access to this source through SQL views only (no SQL tables).

Because of this, the data manager does not show any tables available. Is there any way to get Qlik Sense to show the SQL views?

 

Thank you,

Labels (2)
1 Solution

Accepted Solutions
gengisKwan
Contributor
Contributor
Author

Solved issue myself.

when configuring the ODBC DNS, ensure you tick the "Change the default database to:" and target the database/datawarehouse. leaving it blank, will cause an issue.

View solution in original post

1 Reply
gengisKwan
Contributor
Contributor
Author

Solved issue myself.

when configuring the ODBC DNS, ensure you tick the "Change the default database to:" and target the database/datawarehouse. leaving it blank, will cause an issue.