Do you use Alteryx in a language other than English? If so, we want to hear from you! Please help us improve the international experience of our products by participating in this 5 minute survey.

We are updating the requirements for Community registration. As of 7/21/21 all users will be required to register a phone number with their My Alteryx accounts. If you have already registered, you will be prompted on your next login to add your phone number.

Alteryx Designer Ideas

Share your Designer product ideas - we're listening!
Submitting an Idea?

Be sure to review our Idea Submission Guidelines for more information!

Submission Guidelines

Active Directory AD Data Connector Needed

It would be great if we could have a Windows Active Directory data connector tool added to the standard Alteryx toolset.

 

MS Excel Power Query and PowerBI both can connect to Active Directory for use as a data source, but are both very cumbersome to use.  Having a connector in Alteryx that can read AD data into a workflow would be super helpful for a long list of use cases.  A couple that are top of mind for me are:

 

-Leveraging group membership info for dynamic distribution of reports or datasets

-Being able to build reporting and dashboards about the organization (useful for Tech audit, HR, etc.) 

 

I've seen links to an old project on GitHub of someone that started development on this, but the method (just copy these random .dlls into your program directory) is seriously frowned upon by any enterpise IT.  Would be great if Alteryx could pick up that work, polish it a bit and add it to the actual Alteryx Designer toolset.

30 Comments
Aguisande
13 - Pulsar
13 - Pulsar

 Hi @sanyajaleel

Have you tried to Unblock the DLLs and restart Alteryx? This should enable the tool for you.

OldDogNewTricks
10 - Fireball

Agreed.  Any update on getting this into a release?

tmschbgr1
5 - Atom

+1

ArtA
5 - Atom

Our company has a need to connect to our Active Directory information.  It holds our user reporting structures and is integral to be being able to secure historical transaction information.  Please raise this up in the engineering review and development process.  I do not mean to devalue the work of the 3rd party open source community, however using an open source solution for an enterprise is not good practice. 

DanHare
10 - Fireball

Nudge...currently have to use a 3rd party sync tool to do this.

jason_scarlett
9 - Comet

Double nudge... 

MonBrazier
8 - Asteroid

Triple nudge...

egrepps
5 - Atom

Nudge.

Howdy, folks and @dataMack  I developed and then put together step-by-step instructions on "Using Alteryx to query Active Directory" last year whenever after I realized there were not any formal solutions. It can be found here:

https://community.alteryx.com/pvsmt99345/board/message?board.id=designer-discussions&message.id=9075...

 

I also created a few macros that do this via AD Web Services and the download tool. These work much better than the method in my write-up. One of these is even able to get AD Group information as well. I was hoping to create a similar write-up for those macros but never managed to find the time.

 

Is there a process for submitting these macros to Alteryx so that they could be "productionized"?

 

If anyone has any thoughts on this, feel free to reach out.

 

Thank you.

OldDogNewTricks
10 - Fireball

@Data_is_mymiddlename - Just curious if anyone ever reached out to you about the macro you created?  I'd be interested in seeing what you have if you don't mind sharing?  Does it also pull from Azure AD or only an on-prem AD install?