Qlik Community

Qlik Sense Data Connectivity

Discussion board where members can learn more about Qlik Sense Data Connectivity.

Announcements
Announcing the newest addition to the Qlik Community, Qlik Gallery! Learn More
Highlighted
gengisKwan
New 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 (5)
1 Solution

Accepted Solutions
gengisKwan
New Contributor

Re: Data Manager ODBC not showing SQL server data warehouse views

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.

1 Reply
gengisKwan
New Contributor

Re: Data Manager ODBC not showing SQL server data warehouse views

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.