AzureAD to Domo for User data

RK_CFL
RK_CFL Member
in Connectors

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

Tagged:

Best Answer

  • ArborRose
    ArborRose Coach
    Answer ✓

    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.

    ** Was this post helpful? Click Agree or Like below. **
    ** Did this solve your problem? Accept it as a solution! **

Answers

  • ArborRose
    ArborRose Coach
    Answer ✓

    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.

    ** Was this post helpful? Click Agree or Like below. **
    ** Did this solve your problem? Accept it as a solution! **

Categories