Workflow Ran on Multiple Desktops

Question

I'm connecting to input data though an ODBC connection. Screenshot shows a username/password, but I also tried this with a "No Authentication" connection and have the same issue.

Here's my ODBC Connection. Again, I have tried with the Authentication Method of "Not Authentication" as well:

However, when my colleague opens up the same workflow, this is what he sees.

Why would it show that his connection is invalid? I've confirmed that he has same ODBC connection access, it's just that it doesn't seem to connect when he opens up the workflow that I created on my desktop.

KGT · Answer

OK, I'm guessing that you don't have a server, so the centralised sharing of connections won't work and you need to handle the sharing of connections yourself. @apathetichell provided the right thing to look at above.

The error your co-worker is seeing is because they don't have the DCM connection set up. They need to set that up on their machine as you'll have trouble sharing that without a centralised location.

dreldrel · Answer

Agree with Gaurav's idea, also you can sync your connection to the server, then share connection with your users

Gaurav_Dhama_ · Answer

Ok, so they need to build the connection with server else designer wouldn’t know what that string means.

So you can go to manage connections and synchronise.

Preferably, upload this workflow and let people open it from there into their designer. That will take care of most of it.