Alteryx Server Ideas

Currently, this is completely manual with whoever is assuming the schedule creating it under their profile and then the old schedule being deleted.

This can happen often in organization where a user leaves the company or assumes a new role requiring some else to maintain those schedules. It would be convenient if there was an option to reassign the owner of a schedule to simply this process.

My company uses R Shiny and maybe in the future Python Dash to create multiple analytic apps, dashboards, etc for multiple people to run across our company. One thing that would be nice to to have these R Shiny workflows run off of the Alteryx Server as that would allow us to use Alteryx Server to keep permissions and ease of use.

I propose an update to the Alteryx Server that would allow for R Shiny apps to be run in the Alteryx Server with all functionality of custom R interactive plots, etc etc just like what you'd see in one hosted on a R Shiny Server.

The benefits of this would allow for my company to only have to manage one server instance (Alteryx) to run all of this. Since R/Python is allowed/used in Alteryx workflows already, can you add the ability to visualize R Shiny code/plots/interactions/etc within Alteryx Server itself?

Hey there,

Below you can see few of my suggestion to improve Alteryx Server. 

Idea for Alteryx Server monitoring:

• Increase data what could be seen on workflow results.
• Possibly create a report with filter option (to filter by user, gallery, workflow and etc.), which would at least contain data like:
  • Successfully ran workflows, count, percentage.
  • Failure rates, counts and etc.
  • Live data for monitoring purposes.
  • etc.
• Possibility to connect to workflow results data (live data) with other tools like Tableau or Power BI to create dashboards and etc. to monitor and act on the error as soon as possible.
• Give a chance for other users to check on the workflow statuses and etc same like workflow owner.

Give server more functionality with:

• Ability for server automatically retry workflow based on configurations: in example:
  • retry flow in specific time (for example in 30 minutes)
  • number of possible retries
  • based on specific workflow (other) results ability to trigger to run another workflow
  • (Maybe there is a better way) ability to run macros which would for example open MS Excel, and run macro inside it. I have some of the workflows where workflow opens excel, runs macro inside, that macro triggers special Add In which connects to Essbase, it pulls the data, saves excel file, and then alteryx continues working with the file. So if such or similar workflows could be run on Server that would be awesome.
  • This is extremely exiting one: possibility to create environment for self-service users, which it would not be something like gallery (because gallery is more suitable for Alteryx Designers/users).
    • in that one environment admin could grant access for user and tick what specific user could see and run.
    • so for admin it would be one environment, and user would see only what is needed for him/her.
    • in that environment user would also be able to schedule self-service workflows to be received in example by email, or BOX drive or any other way. Scheduled workflow would have to be approved by an admin before it would be actually scheduled. 
  • I have not tried this one myself, but that would also be great if all alteryx server environment could be accessed by mobile devices (of course, some features would be limited).

 Hopefully you will find these suggestions interesting and useful. 

Regards,

Aurimas

There are two key APIs that we use for extracting canvasses for governance & surveillance:

- the Workflows API which lists all canvasses on the server;

-  and the API call which returns a packaged version of the application by AppID

Unfortunately - when we query for all workflows to get the first list - there is no flag to indicate that a subset of these are actually deleted.   The result is that you need to make the second call to find this out which is wasteful.

Please add a "deleted" flag to the Workflows API so that we can identify which applications have been deleted without having to call the specific App ID post.

CC: @jalvarezv

When opening a canvas - it is possible to open from the gallery, which is important in a team environment.

However - as you work on this canvas - if you hit save, it does not save a new version to the server and increment the original (as would happen on sharepoint) - instead it asks you to create a new file.    

Please can you change this behaviour as follows:

- If I open from the gallery then when I save I'm updating the same Gallery asset and incrementing the version ID by 1.

- The only time I would save in a new file is if I use Save As; and explicitly pick a new file.

 cc: @jalvarezv

We are taking an incremental feed of all server canvasses in order to look for patterns - however there is no option on the server admin APIs (the Workflow API specifically) that allow you to filter by date.

Please can you add to this API to allow API users to specify an upload/updated date filter and only take items after this date.

cc: @jalvarezv

Currently, only users themselves are able to setup the default worker tag in their My Profile page. To ensure efficient management of worker nodes, Server Admins or Curators should be allowed to set the default worker tags of gallery users, preferably in bulk. This will help avoid workflows to be executed using the wrong worker node.

We have several workflows that call other workflows (i.e. via the Conditional Runner macro) but are running into some versioning challenges since we moved to storing all of our workflows in our gallery.  When I publish a workflow that references another workflow, I can bundle it up with the workflow when I save it, but then Alteryx places that workflow into the /externals directory, which is obvioulsy not the same as the workflow that we've saved to our gallery.  An example:

I have two workflows in our gallery...one that generates a TDE and one that calls that one if certain file availability and time conditions are met.  The "master" version of each is in the gallery, which is what we want...

...but when I load or save the Sales Analytics workflow in Designer, I have to bundle the TDE workflow with the main workflow in order for it to run from Gallery.  But now I've created a disconnected version of the TDE workflow and if I forget to update it when I update the version in the Gallery, I'll be running the wrong version.  I know I could store these workflows in a network directory, but that seems to defeat the purpose of the Gallery.

If I'm not missing something insanely obvious, I think this would be a very important feature enhancement, namely the ability to pull in a Gallery workflow into another workflow.

@SteveA did an article about server logging a few years ago which was very helpful.

https://community.alteryx.com/t5/Engine-Works-Blog/A-deeper-dive-into-Server-logging/ba-p/22389

... and in the training events at Inspire this year there was a session on how to find and interpret server logs.

it would be very useful for large server environments to move away from discrete log files as much as possible, and instead move towards a world where the logs are stored in a data format, and one logging infra is used for all so that an admin team can see these all in one place.

Granted - the initial boot-up of a server, where it needs to connect to the logging DB is going to be a challenge - but after this initial primary boot sequence it would be great if all server logs and logging events were stored in a database of some kind so that we can analyze and collect events.     That way, server admins can have a great UI experience; as well as a great analytical experience without having to regex through multiple different .LOG files.

Currently when running an Alteryx Workflow from the gallery via the API, it doesn't get logged in the user interface in the same way that running it interactively in the gallery GUI does - a shame as it then becomes harder to know the traffic and performance of a workflow run in this way.  

Currently there are certain locations on server that are paginating content results:

• /gallery/#!apps/studio
• /gallery/admin/#!apps
• /gallery/admin/#!subscriptions
• /gallery/admin/#!users

Each of these pages require users to either know exactly what they want to find by using keyword filtering or know exactly what page they want to go to and use the bottom arrows/page numbers to navigate to that page. Ditching pagination for something more intuitive helps users that may not be as acclimated with the depth of content when there are a lot of results, and also saves users multiple click interactions to find what they want.

There are tons of solutions for this, but infinite scroll is the most user-friendly & least taxing server & client side.

https://infinite-scroll.com/ has code & examples, and jquery seems to be the most widely used implementation.

Hi,

I've got an app in my company's gallery that I've updated 11 times, so in the gallery it says "version 11". I noticed when I click on that area, it brings up a window that shows all 11 of the apps I've uploaded over time, with options to make them the published version & to download. This confused me since each time I update the app I get a warning saying the app will be deleted, which is what I want.

So for this app, I have a 800MB file within it, which would mean that on my gallery server I have 11 versions of an app that each contain at a minimum 800MB of data. I've recently been told by support that this is as it's intended, and if I want to get rid of the all the different versions, I should deleted the app entirely and start anew. This of course would change the URL to the app, requiring the updating of documentation and redistribution of that documentation to over 100 users. And I lose the number of times the app has been run, which doesn't work for me.

My idea is to have another option in the window that shows all the different versions with the options to download, but this option would be to delete previous versions...COMPLETELY, knowing that the owner would no longer have the option to download the version or make it the published version. Having this would allow the owner to maintain the original app with the option of dropping previous versions that are really not wanted anymore.

Upon utilizing the Alteryx gallery to create and test an automation app in cooperation with other business areas, we found that the list of "recent modified files" that appears when selecting a file browse query has several issues, or areas in desperate need of improvement:

Not only does this list append new files to the bottom, resulting in a less than desirable experience when selecting files from this list across multiple occasions when testing, but the list eventually reaches a capacity where no new files can be shown. Furthermore, for processes that involve small modifications being made to a file or group of files that is fairly consistent in naming, a list of ambiguously named files will quickly cause confusion. If this type of small improvement is possible, please reach out to me about any avenues towards achieving it, or if there is a person or department to appropriately contact.

-John

When saving a workflow to the Gallery, I would like an option on the Save window to save directly to a collection. This can be an existing collection, or would have the ability to create a new collection. The current process requires you to log into the Gallery after saving the workflow and move it to the appropriate collection.

A maintenance mode would not be luxury, so that the worker does not take any more new job and finishes those which it has in progress. to be able to stop this one more easily.

I would like to suggest the idea of being able to handle row-level security data sources in a more seamless way using Kerberos passthrough, where Alteryx Gallery will pass the information that User A is running the workflow to the underlying DB and will authenticate as User A. 

We have many workflows that are built to handle different queries of a database that are reliant on knowing who is running the workflow in Gallery. We also have many regional workers, and we want to keep the administration of these connections to the data as simple as possible. 

For more information, check out the Community thread on this subject.

For a given DB connection - there's a need to be able to specify the owner for this specific connection.

Reason for this is that the credentials for a given DB are not all managed by the central admin team - so we'd want to say that a given DB connection is owned by a particular person so that this can be updated frequently as passwords change.

For resilience - our particular policy would be to have 2 owners so that if one person resigns or changes roles, it invalidates the primary and reverts to the secondary - and then asks the new Primary to create a backup owner.

While working in the Gallery, I think the file browse tool should allow the user to import a file without selecting a sheet or <list of sheet names> as is does locally.  

For example, I have created an app in which the user is able to import a file with multiple sheets, and all sheets are brought into separate input data tools with a single file browse tool (shown below).

Since the user does not select a sheet name, the file browse tool only brings in "SelectedFileName.xlsx|". The action tool is then set to replace a specific string "SampleFileName.xlsx|". This allows the input data tools to take this new file name, and add each respective sheet name to the end.

However, when working in the Gallery, the user is required to select a sheet name or list of sheet names, meaning a file browse tool is required for each sheet that you would like to import (shown below). This is a huge inconvenience for the application user, as they have to select the same file numerous times to import every sheet. 

Please let me know if you would like me to provide any more information, I would be happy to do so.

Thanks,

Matt