Acquiring / writing files to UNC paths - username & password

Hi all,

After some assistance please - I can't see that this issue has come up before, although if I'm honest, I find that hard to believe.

I have an Alteryx workflow - I need the workflow to acquire data from a server share that is on a different domain than the Alteryx server. The workflow will also write to a server on a different domain.

While I can see where to enter the UNC path of the source and destination folders, I'm unable to work out where I can enter the username and password. I would expect to be able to enter something along the lines of:

\\10.10.10.10\sourcedata\file.txt

Username: <domain>\<username>

Password: <password.

Any ideas from anyone? Appreciate the feedback.

Cheers,

John.

Input

Output

Accepted answers

adm510

I would use the run command and execute a "net use" command to map a drive with your credentials before attempting to access it in Alteryx. This will map the folder to the drive W: of course you can change it to something else. The second command allows you to delete the drive mapping, it doesn't actually delete the folder.

net use w: \\10.10.10.10\sourcedata /user:<username>@&lt;domain> <password>

net use w: /delete

All comments

adm510

net use w: \\10.10.10.10\sourcedata /user:<username>@&lt;domain> <password>

net use w: /delete

johnyd01

Hey Fireball...

It's when I see such simple solutions, I'm reminded of how inadequate I am.

Thank you for your feedback. So simple.

Cheers,

John.

annamalaimoorthy

Hi @adm510 - This approach works only in designer. When I publish it to the Alteryx server, it does not work. Any leads on how to make this work when publishing to server.

Thanks

Annamalai

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15878

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703