Using WorkBench to Connect Azure AD to DOMO?

JoeR_PSIT

Hi!

I am relatively new to creating connections in DOMO, but one thing I would love to be able to do is make a report of all computers that are showing in our Azure AD so that we can see information on our users and what computers they have joined to Azure AD. This would also help us see non-compliant assets or unencrypted assets at a glance.

It doesn't seem that there is a simple connector for Azure AD into DOMO (there are other Azure connectors, but those seem to be for datalakes and the like, which doesn't seem to be the same sort of thing). Is Workbench the best way to go about this? And are there any tips on the best way to use Workbench to get such a connection set up?

Again, I'm admittedly a total novice, but any guidance is appreciated.

Thanks everyone!

-Joe

GrantSmith

Hi @JoeR_PSIT

It doesn't appear there's currently an Azure AD connector that's been written. There is an API that Azure AD offers for some reporting on sign-ins and audit logs which is outlined on Microsoft's website: https://docs.microsoft.com/en-us/azure/active-directory/reports-monitoring/concept-reporting-api

You have a few options to get this information into your environment however it will require some technical expertise. You can attempt to write you own custom connector (https://developer.domo.com/docs/custom-connectors/connector-dev-studio) or you can utilize python and write your own script to pull the data and then ingest it into your instance using the pydomo package (https://github.com/domoinc/domo-python-sdk)

JoeR_PSIT

Thank you @GrantSmith ! You've given me a couple good paths to look into. It all may be a bit over my head but I am going to speak with my team and see what we can figure out.