Can QuickSight connect to Azure SQL Database?

Question

This question was asked in AWS Forums.

> I want to use Azure SQL Database as a data source - I have the connection credentials, and I can even Validate the connection in QuickSight; but once it connects, it says there are no tables in the database. I thought it might be a firewall issue, and I've created a firewall rule for the Northern Virginia data center, but it had no affect. Has anyone tried this?

Answer

I am answering this question by myself as I was asked by a customer and found a definitive answer for it.

While Azure SQL is not explicitly listed as one of the [QuickSight data sources][1], you can still use it as a data source. TLS/SSL is also supported now, and I have tested it personally.

Example of JDBC connection parameters:

Server: "servername".database.windows.net 
Port: 1433 Database 
Name: "databasename" 
Username: "username"@"servername" 
Password: "password"

Make sure to use the "username"@"servername" format for the Username.

[1]: https://docs.aws.amazon.com/quicksight/latest/user/supported-data-sources.html
  [2]: https://stackoverflow.com/a/67612495/1453190

Answer

Since you are able to connect but observe "no tables in the database", can you check what permissions are set for the user on Azure SQL side?

Can QuickSight connect to Azure SQL Database?

Relevanter Inhalt