Sharepoint Sync (Input Data tool) Run on Server

[bertal34]

Has anyone gotten the Sharepoint Sync method to run successfully on Alteryx Server?  The sync method I followed is in the link below and uses the regular Input Data tool (not the Sharepoint Connector tools).  This method works great in Designer, however I wish I could get it working on Server.  I have found the Sharepoint connector tools to be inefficient and I cannot satisfy all my uses cases with these tools.  Using performance profiler, the SP connector takes 99% of processing time while the sync input is much more efficient.  Anyways, if someone could share in detail if they know how to use the Sync on Server, I would appreciate it.

https://knowledge.alteryx.com/index/s/article/How-To-Connect-to-Sharepoint-with-Alteryx

[bertal34]

@abroscow 

I did not find a way to use the Input Data tool on a Server workflow (to reference a Sharepoint file).  My guidance to other users is: If the workflow needs to run on Server and the dependent file is saved on Sharepoint then you must use Sharepoint Connector Tools with DCM connection (following instruction @NaiLo provided).

Side Note: I have gotten the Input Data tool to work on Server for a file saved to OneDrive.  OneDrive can sync Sharepoint folders/files.  This worked by referencing the local folder on server (D:\Users\svcalteryx\OneDrive\FolderName\).  However, this was not a permanent solution because OneDrive does not consistently run (in the background) on our Server.  OneDrive only runs when a person is remoted into the Server.

On another note, We recently acquired Azure Files cloud storage space.  Dependent files saved here can be referenced through a UNC address making it a seamless experience on both Designer & Server.

Let me know if questions or thoughts.