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!
