topic Re: Gallery Data connections not visible to the users in Alteryx Server Discussions

Gallery Data connections not visible to the users

saiarunbandhakavi — Thu, 24 May 2018 01:16:05 GMT

Recently we have set up Alteryx Server. The requirement is to create a data connection on gallery and share the connection to different users, so that they can use same connection on designer and publish it to gallery (so there is no need to change the data connections every time they want to publish).
On Admin gallery I have created a data connection (Oracle) and shared the data connection to different users. But the issue is they are not able to view any connections on Saved data connection, but i can view the data connection if i am trying to connect through my Designer. I am the curator on gallery and other users are Artisans.

Could you please suggest if I am missing something or if there is any other way to achieve the above requirement.

Thanks,

Arun

Re: Gallery Data connections not visible to the users

patrick_digan — Thu, 26 Apr 2018 14:27:00 GMT

@saiarunbandhakavi Have the users added the gallery in their designers (Open Workflow >> add a Gallery)? If they've added a gallery, do they have they have a galleryalias.xml file on their machines?

%APPDATA%\Alteryx\Engine

Those would be the first 2 things I would check. Hopefully #1 solves it.

Re: Gallery Data connections not visible to the users

saiarunbandhakavi — Thu, 26 Apr 2018 15:47:19 GMT

The users have added the gallery in their designer. But the user does not have galleryalias.xml on their machine

Re: Gallery Data connections not visible to the users

patrick_digan — Thu, 26 Apr 2018 15:55:44 GMT

@saiarunbandhakavi So that file gets generated/refreshed everytime someone opens a new instance of alteryx. You can manually generate/refresh the file by going to options >> advanced >> manage data connections; however, It looks like something funny might be going on. It seems odd that they would be able to add the gallery and open a workflow from the gallery, but the data for the data connections isn't properly being passed to their machines. You may have to reach out to support@alteryx.com if that's the case.

The only other thing I can think of is to make sure that you see some sort of symbol (like the curator or artisan symbol) at the far right on your data connections screen where you can add users. I've accidentally added permissions to the studio (no symbol) instead of the users (symbol like below):

Re: Gallery Data connections not visible to the users

davidhenington — Tue, 27 Aug 2019 17:36:51 GMT

@saiarunbandhakavi did you solve this?

@patrick_digan the user indicated they didn't see the XML? You don't address this in your response?

Re: Gallery Data connections not visible to the users

davidhenington — Tue, 27 Aug 2019 18:11:20 GMT

on my end this was solved by having our admin go in, remove and re-add the connections.

Re: Gallery Data connections not visible to the users

puja10 — Thu, 26 Aug 2021 08:34:41 GMT

Hi all,I am getting the same issue even after created a new connection and add the user's not able to see the connection and my company gallery is also add.Please help on this.

Re: Gallery Data connections not visible to the users

rojamahathi — Wed, 28 Jun 2023 16:19:44 GMT

I have the same issue.Is this resolved?

Re: Gallery Data connections not visible to the users

dataguyW — Fri, 11 Oct 2024 20:54:04 GMT

Was there ever a fix for this. I am seeing the same thing. Connections created and all looks good through the gallery web page, but after connecting, I can open workflows but have no access to the data connections.

Re: Gallery Data connections not visible to the users

niklas_greilinger — Fri, 15 Nov 2024 08:04:28 GMT

I face the same issue. But only for a particular user...

Re: Gallery Data connections not visible to the users

dataguyW — Mon, 18 Nov 2024 14:53:42 GMT

I am not sure if there is a good fix out there or automated. I ended up re-creating all my connections from scratch and that resolved the issue. Thankfully this was on our sandbox so there were less connections to deal with. I did open a ticket with Alteryx, but they never provided a good answer either. I sent them links of things I found and they basically just agreed with me to try re-creating them so it wasn't much help.

Re: Gallery Data connections not visible to the users

niklas_greilinger — Fri, 22 Nov 2024 12:24:05 GMT

@dataguyW same for us. At least we could figure out which connection made the problem. If there is a corrupted password in one data connection you cannot add or remove user from it. Any user that has this connection shared will not see any gallery connections as long as this data connection is either removed or the password renewed.