I could not find an answer to my specific question in the existing posts... can someone tell me how to resolve this?
This is in Alteryx 11.0.
I have a workflow that uses a SQL Server data source, defined with alias name "Emcompass DW"
And in the Gallery I have created a data connection with the same name:
And I shared it to myself.
But when I try to upload my workflow to the gallery, I get the "unable to translate alias" error:
Solved! Go to Solution.
Sorry, I don't fully understand your reply.
To add more context, the same workflow also uses an Oracle alias which had the same issue at first when I saved it to the gallery.
I checked the existing data connections and found one in the list that matched the server\database my locally created alias was using, so I changed my workflow to use that already existing data connection. This resolved the "unable to translate alias" issue for the Oracle alias.
Even though my SQL Server data connection has been shared with my user id, I think your reply is saying that I need to share it with the Alteryx user account ("...but instead the Alteryx server run as user") - is my understanding correct?
FYI, the Oracle alias that works in my workflow is only shared with one person: another user\employee.
Can you provide some additional clarification?
Thanks
Unfortunately I was just hoping to give you some direction, i'm definitely no expert with this subject though i'm slowly getting more exposure to it.
I'll point you at a few posts that may clear things up for you:
If you don't get more traction with your community post i'd suggest pushing it to Alteryx's more formal support channel: support@alteryx.com
Ben
Will do. Thanks!
Hi @JDelgado,
The 2 Alias' that you are talking about are different. This is a slight bit of confusion as we added in extra functionality to allow connections to be managed from the Gallery. I'll try to separate the 2 different methods to explain (Sorry about the length if you just want the answer):
These 2 methods are not interchangeable for one main reason. As you can see in my screenshot there, I have 2 Galleries that I connect to, I just cleaned it up from 6. So, If I had an Alias called 'Teradata' in 2 of those galleries (remember they don't know about each other) then Alteryx wouldn't know which one to use. Hence, in the underlying workflow, that connection is stored as 'aka:593f76fe596b370bb0aabea8' using a unique Id for each alias rather than the short viewable name.
Extra info: So if you are trying to promote workflows from a Dev Server to Prod Server using Alias', then you need to use Option 1.
So, with your issue here, you can either:
Please let me know if this is still confusing.
Kane
Great Info, thanks!
It explains my resolution, I think: I ended up deleting the existing data input tool which had created with a local data connection alias, and creating a new data input tool that used the Gallery Data connection after I created it (the data connection on the Gallery).
Hi @KaneG,
1)
I'm still confused. I do not have admin rights on the server, so I'm going with the first route. When I add a connection to the serve, via Saved Data Connections > My Company's Gallery > Manage, I add a connection but it doesn't appear in the available connections on the server. Rather, it is stored under My Computer. See screenshot below.
I'm a little frustrated, as I think this should be an easy process, but our IT department doesn't know how to support this and I've tried just about everything with no success. Is there a step-by-step guide, with screenshots, available that walks through this process in detail? Every post I've seen on this assumes a lot about the user and level of support.
2)
When I (unsuccessfully) add to the Gallery, the resolution and proportions of the App change. See the Results window in the screenshot above. Is this a known bug?
Thanks
Don't we have any answers for this post from rerwin21. I am also facing the same difficulty and am at same point. Any expert please reply to the post
Sorry, I hadn't seen these replies. When adding Data Connections via Manage in that screenshot, the connections will always be added as "User". This just takes you to the Data Connection Manager, not a specific one for the Gallery.
In order to add them as Gallery Connections, they would need to be added under the "Data Connections" section in the Gallery Admin and then shared with users. There is no way to add connections to the settings of the gallery from the designer, that would be extremely hard to get good governance on.
As for the resolution change, I'm not sure, but guessing it may have been fixed in an update.