Connect to Azure SQL DB using AAD/MS Entra user

Riz5Aces

Hello,

I've looked through all the discussions in the Connectors forum, but was not able to find any topic related to allowing users to connect to an Azure SQL DB with their Azure Active Directory (aka MS Entra) username. The Azure Synapse SQL Connector seems to only support SQL Authentication.

In my searches, I came across a mention of Azure Synapse Active Directory Service Principal, but there doesn't seem to be such a connector available in DOMO.

Is it possible to connect to an Azure SQL stand-alone database using AAD (aka MS Entra)?

Many thanks,
Riz

MarkSnodgrass

One way you can connect your Azure SQL database to Domo is through Domo Workbench. You can create an ODBC connection to your database and then use that connection in Workbench. Workbench allows for a lot of scheduling options and transfers the data securely.

https://domo-support.domo.com/s/article/360056669354?language=en_US

Riz5Aces

Hi Mark! That's great, I'll check it out! Much appreciate the quick tip!