DCM/SharePoint questions

[craigja]

Hi,

Im tyring to figure out how our users should connect to SharePoint (as well as Snowflake and a few other DB's) anyway, initially I said use DCM.  We tested everything and it seemed to work but then when we went live, we discovered that only the designer who created the DCM connection can maintain it - if that person leaves, there is no way to add/remove users or change things like the connection string etc.  So we had an idea, create the connection on the server and connect to the server as a shared service account.  This has allowed us to create a DCM connection to Snowflake and share it out.  The issue now is SharePoint, I cant seem to create a connection to SharePoint on the server as there is no connect button, and the only options for authentication are Username and Password, I dont understand this as if you then share that back to a designer, username and password is not available as a way to authenticate on local Designer installs to SharePoint!

I then thought, lets dump DCM for SharePoint, but if I setup a non-DCM SharePoint connection, I get authentication failed when trying to run it on the server...

Am I missing something?   All we want to do is connect to SharePoint Online with Alteryx and have workflows run on the server - it seems the only option is to use DCM but then you cant share that connection with another designer, which is pretty much a showstopper - any help/advice/comments would be greatly received on this issue

[abacon]

I believe the only way to connect using the sharepoint tool itself is to use DCM, and i don't know of a way to share credentials in DCM. Would it work to give the server box itself access to the sharepoint location through file explorer, then you can just define the sharepoint file paths in the workflows? I confess I haven't done this, but that would be my next text to try. Just like connecting to sharepoint from file explorer on your personal machine, but doing it from the box.

[craigja]

Hi - thats pretty much what I thought, thanks for confirming - as for connecting the server to the SharePoint location, thats not really an option as there will be lots of connections depending on what team is building the workflow and we dont give users access to the server.