Sharing a Wokflow with ODBC Dynamic Input

[S2N]

Hey all,

My desktop version is Version: 2024.1.1.93 Patch: 3.

I have workflows that other team members need to be able to run.  They have dynamic input tools with connections to an Oracle ODBC.  Each time someone opens the workflow the connection errors and they have to reconfigure the query and connection again.  How do I change the connection name from "dcm:XXXX - XXXX" to "aka:Oracle" so everyone can share the same query?  Thanks.

[apathetichell]

Dynamic Input In-DB requires that the other user has the DB set up in ODBC 64 (you can script this in Powershell/CMD if you know what you are doing) -> and have it set up in Alteryx under manage In-DB with the same name. One advantage of Dynamic Input-In DB is that you can easily change the connection name to whatever you have on your system if it's different.

[S2N]

The other users all have ODBC 64-bit connections setup and we're all using the same username and password to connect.  I never had this problem until I updated to version 2024.1.  At this point I think going back to 2022.1 maybe the best solution.  Thanks for the reply.

[apathetichell]

Hey -> this could be a 2024.X issue. I haven't used it.

[S2N]

OK thanks.  I can't revert back to 2022.1 until later next week, but I'll let you know if it solves my problem.

[cjaneczko]

If you are in the Connections Manager within Alteryx do each of the users have their Database and Credential names the same as the workflow?

dcm:XXXX - XXXX

Where the first XXXX would be the Data Source name and the second XXXX is the Credential name?