Automate-Azure Active Directory Group Export to Azure Data Lake

Question

I have a simple manual task that I need to automate in a sensible way.

I need to export the users and AD Object ID's of a specific group out of Azure Active Directory and drop a file off in Azure Data Lake or integrate directly in Azure SQL DB.

Powershell is not an option. I am curious if there is anyone out there who has dealt this. It sounds like Flow or Power Automate might allow for something like this but I am not sure where to start. I am using Data Factory as well and was wondering if there was a quick way to leverage that.

Any input would be much appreciated.

No. I will have to do research into your links. I appreciate the feedback. Using Graph API is what I preferred from the beginning so that is good at least haha. — SQLcommando
– SQLcommando, Commented May 5, 2021 at 15:35
@SQLcommando : Did you find any solution using ADF/Databricks for this task ? — Antony
– Antony, Commented Jul 17, 2024 at 5:43

Nandan · Accepted Answer · 2021-05-11 11:33:03Z

0

You can use the O365 linked service and dataset in Azure data factory which contains a feature of users extraction from the tenant. So your source dataset can be O365 with users property and destination can be data lake with file type as Binary( a requirement for O365)

The below MSFT link explains the same: https://learn.microsoft.com/en-us/azure/data-factory/connector-office-365

answered May 11, 2021 at 11:33

Nandan

5,2252 gold badges12 silver badges28 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

SQLcommando · Accepted Answer · 2024-07-18 12:22:36Z

0

Graph API call, get AD info needed, copy into a SQL Table and map to other security focused data used downstream.

answered Jul 18, 2024 at 12:22

SQLcommando

235 bronze badges

1 Comment

Community Over a year ago

As it’s currently written, your answer is unclear. Please edit to add additional details that will help others understand how this addresses the question asked. You can find more information on how to write good answers in the help center.

Collectives™ on Stack Overflow

Automate-Azure Active Directory Group Export to Azure Data Lake

2 Answers 2

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related