Can I use DCM for Excel files on a network drive

Question

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

craigja · Answer

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

Aaron_Foster · Answer

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).

Directory to dynamic input.png