AzureAD to Domo for User data

RK_CFL

As there is no direct connector in Domo for AzureAD, what methods are people using to import AzureAD user data to Domo?

The main goal is to import user data and pick up different attributes such as last sign-in, job title, department, groups etc.

We would prefer not to use Workbench, how are other companies doing this?

Thanks

ArborRose

I don't think there's a direct connector. You probably have to use a combination of Azure tools, export methods, etc. Workbench, Python or something to import into Domo.

You could try PowerShell scripting…

Install-Module AzureAD


Connect-AzureAD


#Use cmdlets like Get-AzureADUser and Get-AzureADUserLastSignInActivity to fetch user data and their attributes.


$users = Get-AzureADUser -All $true

$userDetails = $users | Select-Object ObjectId, DisplayName, UserPrincipalName, JobTitle, Department


# Example for exporting last sign-in details

$userSignIns = Get-AzureADUserLastSignInActivity -All $true

$userDetails | Export-Csv -Path "C:\AzureADUsers.csv" -NoTypeInformation

Then automate the script in task scheduler. But yeah, it probably involves Domo Workbench.

Or some kind of Azure App or Azure Data Factory (ADF) with Domo's Azure Blob Storage connector.

ArborRose

I don't think there's a direct connector. You probably have to use a combination of Azure tools, export methods, etc. Workbench, Python or something to import into Domo.

You could try PowerShell scripting…

Install-Module AzureAD


Connect-AzureAD


#Use cmdlets like Get-AzureADUser and Get-AzureADUserLastSignInActivity to fetch user data and their attributes.


$users = Get-AzureADUser -All $true

$userDetails = $users | Select-Object ObjectId, DisplayName, UserPrincipalName, JobTitle, Department


# Example for exporting last sign-in details

$userSignIns = Get-AzureADUserLastSignInActivity -All $true

$userDetails | Export-Csv -Path "C:\AzureADUsers.csv" -NoTypeInformation

Then automate the script in task scheduler. But yeah, it probably involves Domo Workbench.

Or some kind of Azure App or Azure Data Factory (ADF) with Domo's Azure Blob Storage connector.