Qlik Community

Qlik Sense Data Connectivity

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

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.

Tags (2)
1 Reply
Highlighted
aritting
New Contributor III

Re: How to connect to SQL Azure?

Azure SQL databases currently support

  • ADO.NET
  • JDBC
  • ODBC
  • PHP

I think ODBC is your best option