It would be very useful to have a standardized method to set up notifications to the server admins and to the job owner themselves if an alteryx canvas fails (error).
My understanding is that currently the only way to do notifications on failure for every canvas is for every canvas to individually set up events. On a large implementation, this becomes very difficult to manage.
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.
As Alteryx leans more into the Data Science space - it becomes more important to be able to keep rich documentation of the project along with the Alteryx Asset. This does also require the concept of a "project" on the alteryx server, which would allow for meta-tags; and various different documents to be added with the project.
This would include things like Requirement documents; test evidence; test data sets etc.
This would extend Alteryx from a data prep engine to more of a data-science workbench as different user groups can participate in a specific project.
So, .YXI files are great, they allow a much simpler installation process of macros from the Gallery to your local machine and server.
However one problem; they are not supported to be hosted on the Alteryx Gallery. This means that in order to share .yxi files they have to be hosted on some other drive and then you have to have a workflow in the alteryx gallery which provides users with the download link.
This makes that clean process a bit less clean, and it also causes problems with big customers who cannot whitelist these share drives for which the .yxi files are hosted. I myself have had about 20 emails from one global consulting firm in the US requesting access to a macro, I can't link them to the content as they are blocked, and therefor I have to email them individually.
It's a tad tedious and ruins the 'install experience'.
If you don't know what I'm talking about you can follow my colleagues (Peter Gamble-Beresfords) blog here:
What I'm asking for is simple, support for .yxi files in the Alteryx gallery, in the same way you do with macros.
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.
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.
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.
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.
As users change roles; or possibly even leave the firm - we need to automatically manage the ownership of their and their permission.
- We need to be able to export all permissions and ownership of assets by user using an API
- We then need to be able to revoke permissions using an API (we have a central entitlement management process that this can be tied into)
- we also need to trigger a revoke on all licenses via API.
If done within Alteryx server:
- When a dept code on a user changes; or user leaves - trigger an invalidate on all assets.
- Workflow to both the primary and secondary owner to ask for a new owner
- Also automatically trigger a revoke on all licenses
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.
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.
Big time user of the Gallery API. In fact, I wrote an R package for it (shameless plug: https://cran.r-project.org/package=alterryx).
It is great that you can queue a job for an application using the Gallery API but it would be great if I could also cancel a running job.
I would like to set a retry count when scheduling a job, and also to specify to duration in between retries, e.g. job fails, but then will retry to run 3 times with a 5 minute wait in between each retry.
Also would like a radio button next to all workflow results, so when you get a list of failed jobs you can click all the jobs and then hit rerun. This should be complimented with select all functionality. This will prevent me from having to go into each job and rerunning, i.e. save me loadsa clicks!
Although the connectivity to the eMail infrastructure is set up on the controller and worker nodes - there is no ability to set up automated alerting for errors on workflows from the server.
We would like to be able to set up the gallery as follows:
- Every job is owned by a user or a distribution list
- If that workflow throws an error or warning (this should be configurable on the server, whether warnings are included), then the author should be e-mailed with a link to the specific workflow and the error log.
This can be done in a round-about way, by running an error-reporting alteryx job after the fact - but this kind of alert needs to go out almost immediately given our dependance on Alteryx for specific SLAs.
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.