Alteryx Server Ideas

Please add a TAGS filter for workflows filter

Hello,

I was recently hired by a fortune 500 company to eliminate use of their Access DB's by replacing them with Alteryx solutions.  My first step is to understand the old DB's so I know what type of workflow to build.  I'd love to have an ERD tool built in Alteryx to drop right after the input data tool.  The closest I've found is the Network Analysis tool, but I don't see that giving me the desired output.  

I would like to see how tables are connected, what manipulations are being done, when a query/view/macro was last used, what outputs being delivered. 

Thanks!

Gina

Currently it takes four clicks and three displays (including the current scheduler display I'm attempting to post as well) just to temporarily disable a job.  It would be so much more convenient if there were a one touch icon on this display that allowed you to do that function.  

Ability to change the default workflow settings when to also include [Others may view this workflow's history] in a similar way to the other attributes in workflow settings that are set by default.  This would prove beneficial for workflows which are shared across a large team and need to be run on a consistent frequency and are not run headless.  The inability to set this by default leaves a risk that the setting remains unchecked and more than one user triggers that workflow in a given month which could result in a material impact if the output of that workflow is posting to another system in the firm.

Hello, 

We have been building a solution for a client that involved chaining apps. When we uploaded the workflow to the server, we got the below error: Workflow exceeded maximum runtime of 30 seconds and was cancelled. We were able to rectify this by having the client implement the change here. While I understand the need for the limit, is there any plan to have this fix be more obvious to the average user to implement or avoid needing to reimplement following a server upgrade?

Thanks, 

I Would Like a new Email added under [ Admin -> Notifications -> Emails ] where it would send an Email when a Schedule reaches the status "Complete" 

This can serve a couple of use cases;

1. You have many things going on and this email can let you know "This schedule has now been completed"  
   1. From my experience we usually schedule things indefinitely, however if an end was put in place this can be a reminder of whether or not to continue scheduling the workflow
2. It can also notify when a schedule inadvertently reaches "Complete" status, in the backend this could be because it has status "Corrupt: AlteryxService_RetrieveSecureData Failed."
   1. This has caused issues multiple times of schedules that are supposed to be indefinite reach "Complete" Status without our knowing. With many workflows and schedules this is not something we can babysit.
   2. brief research suggests this error could be due to restarting the Alteryx Service during a schedule, which we do weekly for our backup. And trying to coordinate a time when no schedules are running is difficult when something runs every 10 minutes.

When using In-DB with iSeries over Generic ODBC everything works fine in Designer however when executing via Gallery process fails because a semi-colon ";" is added to the SQL statement as a terminator character and iSeries rejects this SQL0104 - Token ; was not valid. Valid Values < END OF STATEMENT > 

We have a MongoDB connection string that we plug in to RuntimeSettings.xml during install.  Upon startup, the Mongo connection fails because RuntimeSettings.xml expects the connecting string to be encrypted.  The fix for this, is for someone to manually update the MongoDB connection via the Alteryx UI.  We would like a way to encrypt the MongoDB connection string for RuntimeSettings.xml before we start Alteryx for the first time.

Hello,

Looks like the user inputs (check boxes, free text fields, drop downs, file uploads etc., ) to the app are "temporarily" stored during the course of the app "Run" time. These - especially the "uploaded files" get deleted from  the temporary folder after the successful run of the workflow.

Ex: user uploads 2 files to the app as inputs. see attached interface.

It is important that the user selections are persisted on the alteryx server for debugging, investigation, audit trail purposes.

Of-course - there are workarounds by some extra code/logic within the app. But - in-order for the "server" tool to be considered as robust/industrialized - it is critical to "log" the user interactions on the server side.

Is it something already looked into?

Regards,

Sandeep.

Hi Alteryx Team,

I understand that the Timeout feature on all Workers is only available for the workflows scheduled on Alteryx Server.

In a heavily used server environment and depending on how workflows are configured, can we have a timeout feature available for non-scheduled workflows (adhoc workflow runs/manually triggered workflow runs) as well on all the Workers on Alteryx Server ?

Thank You,

Nishi Jain

It would be great if we can set the priority of a job when scheduling a workflow through either the Designer UI or through AlteryxService addtoqueue command

In my organization we primarily schedule jobs through these avenues and this would bring them up to par with the scheduling capabilities of Gallery

For example:

AlteryxService https://help.alteryx.com/current/server/alteryxservice-commands

addtoqueue=path,host[:port],secret[,true]

^ add an optional parameter that takes enum value {Low, Medium, High, Critical}

Designer UI

Add a dropdown that takes an enum {Low, Medium, High, Critical}

Alteryx Server API should be allowed to publish the workflow in the gallery. 

Hello Alteryx Devs - 

So, I'm poking around the Atlerxy Gallery API stuff with an eye toward building a set of classes that can interact with workflows without exposing Gallery proper to the community at large.  That being said, I was a little dismayed to find that all interactions require inclusion of *user specific* API Keys and Secrets.  It can be dealt with, but ultimately it means that configuring a middleware tier between the real world and Alteryx server requires an additional hierarchical level; i.e., understanding which of the developers came up with workflow X and having *their* API Key / Secret attached at configuration time.  

Anyways, it might be easier to just have a global trusted key / (super) secret.  If you get that, you can execute a workflow.  

Maybe we have a special studio that people could clone to, and in this way, you'd only have to track a single key/secret outside.  

I mean, the existing system works OK for one offs, but if you wanted to have a (semi) modular system in place, dependence on understanding publishing entity specifics seems to muck things up for no discernible benefit.  Of course, maybe in some places there is benefit to this scheme (?), but it is causing me to craft some weird work arounds early in development, which gives me a sinking feeling.

Or am I doing it wrong? 

Thanks for listening. 

brian

The search for replacing a workflow is poor (and I get that it is probably challenging to write on the back end) but as a result even if I type in the exact title of the workflow (aka copy and paste) Alteryx replace can't find it. Not only does this mean I have multiple workflows with the same name running around (loads of fun with lack of version control) but it also makes this entire thing more frustrating every time I update a workflow (as normally this also means the scheduling of said workflow breaks).

It would be awesome if instead of having to search by title for your workflow that you wish to replace with if you could instead use the URL where Alteryx Gallery put the workflow and then there wouldn't be any confusions about which workflow and you wouldn't have to type.

*This is an idea from @cneivam  from the Portuguese Community*

- Gallery in all supported languages

*This is an idea from @cneivam from the Portuguese Community*

• Can’t use CReW macros in Server

I know that the documentation shows that you can setup a worker to a specific QoS so that it will only pick up work for a particular workflow or app, but there could be a greater use for it.

For example if the Admin could control what QoS means for each definition.

I.E. Application, vs a workflow that runs over an hour, vs in-database tools. Then it will allow the admins to self guide where the work is going.

Right now there is only three levels

• Normal workflow execution: QOS = 0
• Chained application execution: QOS = 4 (all apps in the chain aside from the last)
• Workflow validation requests: QOS = 6

This was great for Alteryx public, but for private Galleries we need to distribute the work better than FIFO.

Hi,

I have missing this functionality in alteryx gallery where we can see the runtime status of running app.

In Workflow result option we can view only post completion of app run.