Share via

Azure Active Directory user details to Azure SQL table by ADF

Abhishek Jaiswal 51 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.
11,624 questions
Microsoft Security Microsoft Entra Microsoft Entra ID

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Nandan Hegde 36,146 Reputation points MVP Volunteer Moderator
    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

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.