2024.1.1.17 Input tool - saved connections removed?

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.

Input

Accepted answers

Phil_P

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

All comments

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.
Screenshot 2024-05-09 151319.png

cjaneczko

Take a look at this article.

https://knowledge.alteryx.com/index/s/article/Database-Connections-Creating-an-alias-and-the-advantages-of-using-an-alias-1583459842881

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.

Screenshot 2024-05-09 171059.png

Screenshot 2024-05-09 171301.png

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

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15878

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703