How to save DCM connections to server?

[craigja]

We are running 2023.1 on our server and locally on laptops.  I want to connect to a Denodo database, in the input data tool, I click set up a connection after ticking the use data connection manager option.  I select Denodo quick connect and set up a Data Source and link a credential.  This all works fine, I can then run the workflow on my laptop.  If I try and save to the server however, I get 'Selected connection is not available, set one up to use the tool'.  I have went into the server and in DCM data sources I see nothing - so I thought I would add a data source and credential, mirroring what I have locally, but I still get the same error.  How do I resolve this error?  If I look at my DCM settings the DCM Mode is DCM Optional which says that connections including passwords are stored in the workflow by default, so im not sure why I get this error!

[fmvizcaino · Accepted solution]

Hey @craigja ,

You have to synchronize the Designer`s DCM with your Servers` DCM.

File > Manage Data Connections.

Best,

Fernando Vizcaino

[craigja]

So you do!  Brilliant, although I have another strange error that Im going to open another request for help with!

[HaroldR_9810]

This issue also happens when you create a DCM connection and connect it to an In-DB tool, for this case we were able to solve it by creating the DCM connection on Server Machines and share it through Gallery with the user that needs to run the workflow using this DCM connection. Even if the credentials are not the same, somehow Alteryx needs that this connection is created under server's account and share it with the user's.