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!
Solved! Go to Solution.
Hey @craigja ,
You have to synchronize the Designer`s DCM with your Servers` DCM.
File > Manage Data Connections.
Best,
Fernando Vizcaino
So you do! Brilliant, although I have another strange error that Im going to open another request for help with!