In this tutorial, we will learn "How to configure connections with MS EXCEL " to connect with Azure SQL database or Azure SQL data warehouse from Azure SQL Server.
Note: If you don't have an Azure subscription, then create a free account before you begin.
Note: If you don't have an Azure subscription, then create a free account before you begin.
You have to do followings-
1. Configure Client IP - We have to Add to the Allowed IP Addresses in set server firewall settings and where we can also add a range of IP addresses to allow.
2. Configure Connection String with access credentials - get the connection string to connect with.
3. Connect DbVisualizer with credentials with Azure
4. Pull your data from database or data warehouse
1. Configure Client IP - We have to Add to the Allowed IP Addresses in set server firewall settings and where we can also add a range of IP addresses to allow.
2. Configure Connection String with access credentials - get the connection string to connect with.
3. Connect DbVisualizer with credentials with Azure
4. Pull your data from database or data warehouse
Note: You don't use your Azure login ID to connect to the SQL service. You use the new credentials that are specific to the SQL database you've created via the Azure SQL Data Service console. Also, you must specify "encryptionMethod=SSL". Required for all communications with SQL Azure.
To Learn more, please visit us at YouTube -
No comments:
Post a Comment