Using Qlik Sense not possible to select database with SQL AzureArticle Number: 000031897 | Last Modified: 2019/10/22
If you use Qlik, you will be able to see non default databases, but you will not be able to select an owner or access the tables.
When you create a DSN, you can check "Change the default database to" and specify the SQL Azure database that you would like to connect. This should help you connect to SQL Azure using a System DSN in ODBC Administrator.
The connect string for ODBC should look like:
Notice the Database= can be set to any database you want to connect to.
You can also get information on the connect string in the "Server Administration" portal -- there is a button for "Connection Strings" that will display the different strings for you database.
You can download the latest drivers from Microsoft directly.
Have a Question?
Search Qlik's Support Knowledge database or request assisted support for highly complex issues.Submit a case
Experiencing a serious issue, please contact us by phone. View phone numbers and hours by region.