Wanted to grab some attention here regarding the Alteryx gallery search engine (which also bleeds over into searching for schedules and jobs when troubleshooting).
Since a picture is worth a thousand words, I'm pasting two pictures (one attachment) of searching our gallery for the word "Contour" and the word "Signal". Both of these words are in the title of a single workflow - when I search for the word "Contour", the workflow pops up. When I use the first word in the workflow, which is "Signal", it doesn't pop up.
I appreciate all that Alteryx does, but I wouldn't think this should be a difficult issue to fix, and I would imagine there are other frustrations with the functionality here.
There is no good way to get server user credentials into a workflow without asking them for it in an App interface. It would be great if we could have a built in Constant that could be used to silently pass user credentials into a workflow for things like API's or logging user information.
Right now, if you are using Windows Authentication, you can map AD group and users on the Permissions and Collections tab. But for some reason, you can't use AD groups on the Data Connections tab. Most of our databases are already secured by in-house AD groups in which you have to be a member in order to access that database. Instead of managing a 2nd, most likely duplicate, list of users in the Data Connections tab I would like to be able to map the pre-existing AD group to that data connection. That also means I don't have to service access requests. If someone wants access to a database, they talk to the database owners, get added to the group and then they automatically can pull that data into Alteryx.
I love the gallery data connection feature - we're going through some big systems architecture changes, resulting in new locations for many datasets. Having a single place in the Gallery Admin area to update connection information works beautifully.
We're running into issues with the gallery-hosted data connections when trying to run some apps on our private gallery though. The trouble comes up when the gallery-hosted data connection appears inside a macro that's part of an app. We get an "Unable to translate alias" error when trying to run these types of apps.
If we have an app using gallery-hosted data connections that are outside of a macro, the gallery is able to resolve the connection alias fine and work properly. The issue only appears when the gallery data connection is part of a macro used inside an app.
We use macros a lot in our app development because it allows us to use standard methods for accomplishing common tasks. Using macros also enables us to set up automated testing workflows to make sure our processes produce expected results. As it is, we're unable to take full advantage of the gallery-hosted data connections because they don't work within macros, and instead have to continue using hardcoded connection strings. These are a bigger maintenance burden as our underlying systems evolve and are updated.
Today, if I want to save a job onto the Alteryx Gallery, I need full permissions to do so and it is a manual process. For some organizations, this level of access is deemed excessive, which can make properly leveraging the Alteryx Gallery difficult. Having the ability to write a "deployment" script that could publish a workflow to the Gallery, and potentially add a new workflow to a Collection would be incredibly helpful in these cases.
Please support GZIP files in input tool in Server. This is related to https://community.alteryx.com/t5/Alteryx-Product-Ideas/Support-for-GZIP-gz-compressed-files-in-input..., but logged in a separate Idea because the staff indicated in the thread that they are planning support for GZIP in Designer only in 2018.2. We need it in Server as well.
The ability to select a workflow or app within the Gallery web interface and change its name. This would maintain its historical run data, version control revisions, placement in collections, etc.
Use case: As a workflow or app continues to be developed over time, the name may need a revision to continue reflecting the workflow's function.
On the workflow results window, I'd like to see a column for "Start Time". If I have a workflow that is running, I'd like to know what time it started running so I have an idea on when it might finish.
Currently, if you want to change from Built-in to Windows Authentication, you have to:
To switch authentication types, you'll need to start from scratch.
1. Stop the AlteryxService
2. Open a Windows Folder Explorer and go to the directory you have MongoDB loaded (System Settings->Controller->Persistence->Data Folder
3. Rename or delete that folder (a simple backup would be to rename the folder, you can move it to another directory as well)
4. Open the Alteryx Server System Settings and click next to Gallery->General.
5. Select the new Authentication process you would like to use.
6. Finish the System Settings and the new database will be created.
The Gallery and Scheduler databases are closely tied. Workflows that are uploaded, results created, and schedules created from the Gallery are stored in the Scheduler database. So you will need to start from scratch on both the Gallery and in the Scheduler.
This is a non-starter for any company that has any amount of time invested in establishing the use of the Gallery. Starting over is not an option, but improving security, streamlining access protocols as a part of overall data governance is a must. Please consider fixing the authentication protocol to make it so we don't have to start over.
When posting an app to the Gallery, if the app has, say, one PCXML output for the user to see, and one Excel file for the user to download, it would be helpful for to be able to specify which shows first to the user. For example, I have a PCXML that gives the user summary tables, and instructions on how to go to the drop down above and select the second report, click on the Excel icon, and download it. But if the Excel report shows up first, then there is no ability to give them instructions and many simply won't be savy enough to go find the PCXML in the drop down.
I work at a large organization where Security and Privacy are of utmost importance. The ideology that we need to follow is Least Privilege and Need to Know.
We (Curators) do not want all the Artisans to publish workflows to Home Page, either knowingly or unknowingly. We however do want to allow a few power users to publish their work in Home Page, but currently the Gallery does not provide the ability to pick and choose who can share workflows publicly. We are educating users to not share any contents publicly, but as we scale up, it will be difficult to manage and govern this.
I'm suggesting to implement a global Yes/No feature that will Enable/Disable Artisans to publish contents in Home Page (just like the way we have for Jobs/Scheduling feature). Further, in Users section, Edit User setting needs to have a Yes/No button that will allow Curators to let certain Artisans place workflows in My Company's Gallery.
Organizations that never want any workflow to be shared publicly can disable this feature using global Yes/No button. Organizations (like the one I work at) that want to enable this only for certain Artisans, can set the Global Yes/No to No, and then in Users tab, they can pick and choose the Users that need this functionality (which will override the global default). Finally Organizations that do not really care about this functionality can just set the global setting to Yes.
Hoping other organizations find value in this functionality as well. Thanks.
From a security standpoint, it is important that all users are authenticated when accesing the Gallery on Alteryx Server and using local accounts. There shgould be an option available to force user to the login page rather than the public Gallery. Users going to the Alteryx server URL should be presented with the login page by default before being taken to the Gallery, rather than seeing the public Gallery and needing to click Sign-in in the upper right corner.
The Alteryx Server Usage Monitoring & Reporting reports are very useful. In order to automate the distribution and leverage our Tableau Server we have modified one of the macros within to publish the TDE to the Server and reworked the workbook to point to it. This is a fairly time consuming process to do, so the idea is to introduce a version of the workflow which pushes the datasource, producing a version of the workbook pointing to it.
It would be nice to have an inbuilt function(s) that return an identifier (NTLogin for instance when the gallery is setup with windows auth) of the user running the app on the gallery.
Functions like - USERNAME(), DOMAINNAME() etc., helps.
I know that it can be achieved via the "__cloud:UserId" call , which is not officially supported by alteryx. It adds value if it is inbuilt within the product itself.
The current setup of Data Connections, as of v11.3, relies on users to have the same aliases or connection strings available to easily share Workflows and publish them to a Gallery. In order to solve this, I propose that a system be created that allows users to establish "Local" and "Remote" connections. The Local connections will be used anytime the developer is creating a Workflow on his own computer, but will be automatically substituted with the Remote connection information once the Workflow is published. Remote connections may be filled with an Alias to a connection from the Gallery.
The primary benefit of this is that an organization will not need all of their developers to standardize their aliases and/or connections strings per connection. Instead, they will create one connection within the Gallery that will be distributed to developers and applied to the Remote column. This will generally reduce difficulties regarding the expansion of an Alteryx user base within an organization. Below I will outline two possible implementations of this:
1) Add a Remote Connection String field when adding a connection in the Data Connection Manager. This optional field will allow the user to set only one connection to an IO transaction, but maintain the Local-Remote functionality described above. Here is a mockup of how that might look within Alteryx Designer.
2) Add a Remote Connection String field on each IO action within Alteryx. This will give the developers more flexibility in which connections are used where, but will also require more setup and maintenance time. Below is a mockup of how that might look.
I have described my issue in the Community post here:
Is there a way to retrieve an exact date when new version of a workflow was uploaded to Gallery? I know it works when it is today, yesterday or couple days ago but after that you can only see "2 months ago" etc. in Creation Date, which is not sufficient for any version management.
I was looking in the notifications part of the Gallery Admin and saw a glaring ommission: The validation email was something about a code, but nothing about a workflow. "What?!" I interrogo-banged.
I would like to move that Gallery include an option (at the workflow level and globally within a studio (perhaps beyond, I'm a newb to Gallery)) that a user can subscribe to an email notification if the workflow completes (or errors out).
Where I'm currently working, we have some workflows that take, literally, in the twenty-plus hour range. Instead of having to check when it is complete, it would be really nice to get an email from Gallery saying: "Hi guys! [Workflow X] is done! YAY!"
I realise there's an email tool in the rendering, but that is... shall we say, complicated. In this case, we're using an R-tool, so all the downstream tools are blind to the metadata. Filtering records down to one so that only one email is sent at the end of the chain is... challenging (remember that 20-hour thing? Try developing on a 20+ hour cycle. It's like 1970 up in here!). And totally counterintuitive. I also feel new users will have issues configuring an email tool; it took me 3 months to get ours to work and it only works from our server. Plus, it's a kludgy workaround.
I feel that this would probably be easy to implement and fits the sensibilities of Gallery.
Vote this up, folks!
On Success --> Do This
On Fail --> Do that
The lack of control and flexibility around the scheduler seems to cause people to bury the logid down in runner macros or unnessarily poll custom log tables to see if a status has changed.
I am aware of a couple of clients calling for this functionality. This can be performed via command line but it realy needs to be in the scheduler options.
As an enhancement to the gallery, I'd like to be able to save my application parameters in the gallery in a similar fashion to when I run an app locally. Users can view the results of an application run, but can't save the parameters that created the run. I'll go a step further than this and ask for another enhancement. I'd like to be able to access the questions & responses within the execution of the app to display them during reporting.t
For a list generation application, I need to present to the user the criteria applied during the selection process.
Input Address: 49015
Type of Vehicle: Chevy
Minimum Year: 2010
Maximum Year: 2015
I've got a working solution that is okay, but not very "Alteryx-easy". I need to have a second update attached to the interface tool to update the user response.
Thanks for your consideration,