Alteryx Server Ideas

Hello

Alteryx Server with SSO configuration not able to sign request. Could you remind ? We need this feature to go into production (see attached image). 

best regards,

Nissar

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 you create an App/Macro locally and give it a custom icon, that icon should follow the App/Macro when you load it into the Gallery.

Idea:

Using a few designers and registering to the Alteryx Gallery are good fits for micro and small enterprises, from investment vs capability stantd point.

Alteryx Server is suitable for medium to large enterprises with at least 45K USD budget yearly and many alteryx users possibly more than 20...

Don't you think there is a need for something in between? I propose Alteryx mini-server (well we can find a better name hopefully :)

Rationale:

Many Alteryx clients seem to utilize Alteryx designer for ETL,

then some of them further enrich data and model forecasting or predictive modelling.

Before even considering a server they output to a BI server like

• Qlik server or
• Tabelau server or
• PowerBI

If there is a need for automation Alteryx designer + Scheduler does all the trick needed.

Once you update everything in a repetitive fachion 100s to 1000s of Qlik or Tableau users can reach to the most uptodate content and discover dashboards...

I believe we can do a similar thing with a mini server...

What to do:

Currently, many of our most useful apps in the gallery utilises blocked tools (download tool, R tool etc). Every deployment or even minor updates to these apps require emailing the Alteryx Curator account for exception requests. This process is quite cumbersome, although the need for it is understandable. However, given that not a single app from us was ever rejected (and we submitted dozens of requests) , it would be great to have a process in place to apply for a permanent whitelisted status. This would give trusted app authors the ability to deploy apps with blocked tools without emailing the Curator. 

Option to update ownership to any other valid license holder as needed.

Use Case: Currently the canvas owner is marked by default as the user publishing the canvas to production.

However, we have seen instances where the person moves teams and would like to hand it over to another person.

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.

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

We've purchased a server license and several designer licenses to publish analytics apps to customers via our internal/company gallery. Whether a user signs in or not, users should not be subjected to corporate Alteryx ads. This is a terrible user experience and detracts from our ability to deploy self-serve solutions.

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.

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. 

Hi,

I have an existing app in my company's gallery. I updated the app in the gallery to not allow others to download. I just made changes to the desktop version of the app and saved it to the gallery, then went thru the steps of replacing my existing gallery app with the new version (this part I like). BUT, after updating the app, when I went back into the app settings, the option for others to download was checked again. To me, the app should inherit anything that was manually done to it in the gallery, like making it not downloadable. Is it possible to have this changed in a future release?

Thanks!

Aliases are a really powerful tool, particularly when you have multiple environments (EG Test, Prod) and need a published workflow to work without any code changes (In particular in an IT or Release/Change Control model).  By configuring a system alias on your Test and Prod servers, code will dynamically point to the correct server.

However, aliases can be somewhat cumbersome if you have a lot of databases on a server, and those database names change by environment.  Effectively, you end up needing an alias for each Database, which runs into naming convention and standardization issues.

Having the ability to configure a "database value" or a "database alias" would do a lot to help this.  This could either be a file that would be attached (allowing for easy config changes without risk of modifying the underlying code structure) or a secondary tier of aliases, so that a connection string might go from:

aka:SQLSERVER (contains sqlserver and database information)

to:

aka:SQLSERVER||aka:database - so that at runtime Alteryx would evaluate the SQLSERVER alias and the database alias to create the correct connection string for that environment.

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.