Oracle connection that can be run by multiple users

[badgeras]

Hello,

We set up Oracle connections on a 2023 version of Alteryx a long time ago that work fine.  If we all created a connection and named it the same, we could all run the workflow.  We have a new person starting and went to get all of their connections made, but with the 2024 version things seem to have changed.  We don't see the same windows when creating a connection.  Even if we name the connection the same, it seems to be tied to the credentials of the person that made the input tool.  If someone else opens the workflow it doesn't work, and if you change the connection to match your credentials it deletes the query.

I tried searching forums and couldn't find anything, all the results show screen shots from an older version of Alteryx.  We have tried creating an OCI connection and using the Quick Connect.

What's the proper way to set up an Oracle connection so that everyone on the team can run a workflow?

[Vinod28]

Hi @badgeras 

In Alteryx Designer 2024, Oracle connections behave differently than they did in earlier versions. Even if we use the same connection name, it now ties the connection to the user who created it. That’s why SQL queries sometimes disappear or stop working when someone else opens the workflow.

To fix this, we’ll use Gallery Data Connections. These allow everyone to use the same secure Oracle connection without breaking the workflow.

---

What You Need To Do

For Admins:

1. Sign in to your Alteryx Gallery Admin interface.

2. Go to Data Connections:

3. Click Add Data Connection.

4. Choose Oracle and enter the connection details (host, port, service name, etc.).

5. Name it something like ORDS_PROD_SHARED.

6. Share it with your team (individual users or an AD group).

---

For Everyone Else:

1. Open Alteryx Designer.

2. Go to Options → Advanced Options → Manage Data Connections.

3. Sign in to Gallery if prompted.

4. Select the shared connection (e.g., ORDS_PROD_SHARED) under Saved Connections.

5. Use it in your Input Data tool and paste your SQL query. It will remain intact for all users.

---

Extra Reference

There’s also a useful Alteryx Community discussion on Oracle Gallery Connections and related behaviour in Designer 2024:
Oracle Gallery Data Connection – Alteryx Community Thread