Synapse notebook connect to Azure SQL Database

Raj D 586 Reputation points
2021-10-04T23:25:02.367+00:00

Greetings!!!

I am working on connecting to Azure SQL Database from an Azure Synapse analytics notebook using Azure Active Directory Integrated authentication using code below.

Code:

import requests
import com.microsoft.aad.ActiveDirectoryIntegrated

#Azure SQL Database Azure Active Directory Integrated
print("Use MSSQL connector to write to master SQL instance ")
servername = "jdbc:sqlserver://sql-server.database.windows.net:1433"
dbname = "
Azure Synapse Analytics
Azure Synapse Analytics
An Azure analytics service that brings together data integration, enterprise data warehousing, and big data analytics. Previously known as Azure SQL Data Warehouse.
4,666 questions
{count} vote