By using AWS re:Post, you agree to the Terms of Use

Can QuickSight connect to Azure SQL Database?

0

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?

EXPERT
asked 9 months ago207 views
2 Answers
1

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, 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.

EXPERT
answered 9 months ago
0

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?

answered 9 months ago

You are not logged in. Log in to post an answer.

A good answer clearly answers the question and provides constructive feedback and encourages professional growth in the question asker.

Guidelines for Answering Questions