Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

Can I use DCM for Excel files on a network drive

craigja
10 - Fireball

Hi folks - I want to enable DCM for all connections in my company, we are slowly moving over to SharePoint and that works fine for both files and lists but we still have a large number of files on network drives.  If I check the Use Data Connection Manger (DCM) checkbox and then select a file on a network drive, it seems to then automatically just uncheck it again.  I assume this means its not currently supported but I just wanted to check in case I was missing something

2 REPLIES 2
Aaron_Foster
6 - Meteoroid

I haven’t used DCM for this scenario before, but here's an alternative approach that’s worked for me. I’ve used a Directory tool along with a Dynamic Input tool, where the Directory tool is used afterwards (see picture).  If you're saving to the Alteryx server, you should configure the flow so that the user runs it with their credentials (or it's tied to set credentials of your choosing). 

craigja
10 - Fireball

I dont want to have users inputting their credentials, but I see what you mean

Labels
Top Solution Authors