2024.1.1.17 Input tool - saved connections removed?

[Phil_P]

Hi all,

We have just installed the latest update, it seems to have removed saved connections from the input tool, was this planned or a bug?

Whats the best way now to set up common database connections so that anyone in the team can run the workflow?

Edit, we have tried to set up new connections under File - Manage Connections but my colleagues get "Invalid connection" if they open a workflow I create even though they are using the same DSN and connection name.

[cjaneczko]

Set the connection up as an Alias. Its saving your credentials in the connection string so they are unable to connect. The driver and name may be the same but the login credentials are different for the two of you. 

[Phil_P]

Hi, can you advise on how to do that? Is there a guide online?

We have selected no credentials in the connection manager which allows us to connect individually but breaks for anyone else.

[cjaneczko]

Take a look at this article.

https://knowledge.alteryx.com/index/s/article/Database-Connections-Creating-an-alias-and-the-advanta...

[Phil_P]

I did look at that but :

"Next, let’s go to the Manage Database Connections window (or Manage In-DB Connections window for In-DB aliases). This will be under Options> Advanced Options > Manage Data Connections. Here we can add new aliases, and edit or delete, any existing ones"

Doesn't seem to be an option any more, I can only find the connection manager under the file menu.

[cjaneczko]

I believe it was added to the System Settings section. I havent upgraded to the newest version yet but it still should be available to create Aliases. 

[Phil_P · Accepted solution]

Alteryx support helped me out, for anyone getting the same issue:

The latest update seems to default the DCM setttings to "DCM Only".

To change it go into Options --> User Settings --> Edit User Settings
Tick "Override DCM Settings"
Then select "DCM as Default"

You should then have the option to use saved connections and also be able to use Alias's to share workflows with outher team members