Is it possible to query Azure Active Directory from an on-premises SQL Server?

Question

Is there any possible way to query on-premises SQL server to Azure active directory?

Can anyone help me with this?

Answer 1

You can able to do it using Graph API which will helps you to get the user information from Azure active directory and put it into any staging table. Also, to optimize it you can prefer Differential Query.

I hope this will help.

Want to become an Azure Expert? join azure architect certification now!!