Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to connect to SQL Azure?

I'm new to Qlik Sense and wanted to connect to some of my data, all of which is in SQL Azure.

The SQL Server data provider refuses to connect to SQL Azure although I can connect via SSMS. I get "Client unable to establish connection" and that I should check my credentials. I'm pretty sure they are correct though.

I also can't connect via ODBC and I don't really understand the ODBC dialog that pops up when I choose this kind of data source (shouldn't I be able to enter a connection string?).

What's the preferred way to connect to SQL Azure? It's not listed as a separate data source option.

1 Reply
aritting
Creator
Creator

Azure SQL databases currently support

  • ADO.NET
  • JDBC
  • ODBC
  • PHP

I think ODBC is your best option