AzureAD to Domo for User data

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
Best 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" -NoTypeInformationThen 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! **0
Answers
-
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" -NoTypeInformationThen 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! **0
Categories
- All Categories
- 1.9K Product Ideas
- 1.9K Ideas Exchange
- 1.6K Connect
- 1.3K Connectors
- 305 Workbench
- 6 Cloud Amplifier
- 9 Federated
- 3K Transform
- 106 SQL DataFlows
- 646 Datasets
- 2.2K Magic ETL
- 4K Visualize
- 2.5K Charting
- 774 Beast Mode
- 75 App Studio
- 43 Variables
- 728 Automate
- 186 Apps
- 467 APIs & Domo Developer
- 61 Workflows
- 14 DomoAI
- 40 Predict
- 17 Jupyter Workspaces
- 23 R & Python Tiles
- 403 Distribute
- 117 Domo Everywhere
- 277 Scheduled Reports
- 9 Software Integrations
- 136 Manage
- 133 Governance & Security
- 8 Domo Community Gallery
- 44 Product Releases
- 12 Domo University
- 5.4K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 112 Community Announcements
- 4.8K Archive