Sharepoint and OneDrive DCM connections are broken on gallery

Question

Hello all,

Here the situation :
-created OneDrive and Sharepoint DCM connections with oAuth Session (token).
-the two workflows of test work fine on the Designer
-I have synced the connections, I can see it on the gallery
-however, the connections are broken and I can't use it. This is specific to OneDrive and Sharepoint, it works fine with a postgresql.

The error message in the tooltip is :

Connection is broken. Edit Data Source to fix connection.

Any idea?

Best regards,

Simon

fmvizcaino · Answer

Hi @simonaubert_bd ,

Thanks for sharing the solution.

Good to know that it doesn`t work if you only install the connector in your service account user. Conceptually, I assumed it would work as well.

Best,

Fernando Vizcaino

simonaubert_bd · Answer

I will test more but what worked :
-install the connectors as admin  (I had installed it with my service account, it's not enough) on Designer located on the server
-restart the services.

simonaubert_bd · Answer

Basically I followed this procedure https://knowledge.alteryx.com/index/s/article/How-to-SharePoint-Workflows-in-Gallery-with-DCM