Azure Active Directory user details to Azure SQL table by ADF

Abhishek Jaiswal 41 Reputation points
2022-02-09T10:28:55.067+00:00

Dear All,

I need your help and guidance.
I would like to fetch user deatils like email address, groups user part of, guid from Azure active directory to Azure SQL database table using Azure Data Factory or SSIS.

Can someone guide me how can I achieve it?

Looking forward for your guidance.

Thanks in advance.

Regards,
Abhishek

Azure SQL Database
Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
9,539 questions
Microsoft Entra ID
Microsoft Entra ID
A Microsoft Entra identity service that provides identity management and access control capabilities. Replaces Azure Active Directory.
19,470 questions

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Nandan Hegde 29,886 Reputation points MVP
    2022-02-09T10:58:59.583+00:00

    Hey,
    The below links might help:
    https://stackoverflow.com/questions/62682926/possible-to-use-data-factory-to-extract-all-azure-active-directory-users

    sharepointpals.com/post/how-to-use-microsoft-graph-data-connect-to-extract-data-using-azure-data-factory-from-office-365-and-push-to-azure-blob-storage-part-2/

    You can build up on to of that to copy that into Azure SQL database

    0 comments