Alteryx Server Ideas

 Java Version upgrade requires LLS settings to be changed manually and LLS service to be restarted. 

so every time there is a java version upgrade,  users have to be notified of the downtime  (even though they could move into 7 day grace period) and then the flexnetls.settings file has to be updated with Java home path.  

Local License Server settings has to pick up the latest Java installation and not require manual Config change and service restart. 

@Kosi @SeanAdams 

Installation/upgrade of java in all servers are usually firmwide Tech team activity - which are outside of Server admins control. 

Java support by Alteryx - is version 8.0.212 - while the latest version available in our premise is 8.0.241. support for latest version of java - which is required for functioning of Local License Server should be prioritized. 

@Kosi @SeanAdams @ydmuley @RajK @LizaNemchynova @Arianna_Fuller @MPistone 

We're looking to use the worker setting that cancels jobs that run over a certain amount of time. However, In testing we noticed when the server kills the job it does not trigger the workflow event for 'after run with errors'. That said, it does trigger the 'after run without errors' event, but there is no detail in the email as to what happened. This behavior seems counter-intuitive. We primarily use 'after run with errors', so our users could potentially have their workflows cancelled and never hear about it. 

is it possible to do one of the following:

• Trigger the 'after run with errors' workflow event if the server cancels a job
• Have a server notification that emails users when a job is cancelled due to run length

We're currently running server 2019.1, so please ignore this idea if this issue has been resolved in later releases. 

Here is the server setting I am referring to

Have the Alteryx Server send a notification when the license is within a configurable amount of days to being expired via SMTP

In prior projects (before the gallery started acting more like a management console (still would like to see a few more features there too ;) ) , we were able to automate the deployment of the workflows. But there's no good way to automate the deployment of the schedules.

The best I've heard is doing a complete dump of the mongo instance on the lower environment and moving that file and ultimately restoring that to the prod environment (messy).

Even using the Gallery, there will still need to be an admin who goes through the process of setting up schedules to deployed apps. 

There should be a REST call to export and import schedules of apps from one environment to the next within the gallery. 

Best,

dK

Right now we can set the limit of processes a worker can run and each worker will ping the controller when a slot is available so that it can assign a new process. However, this is not efficient and you can truly load balance because you don't know how busy that worker acutally is...

We need a way that might be simliar to how we do on DataStage GRID environment where the LSF platform balances that workload across the entire GRID.

Hello,

I need to monitor which applications are shared with who on regular basis. We follow the 19.2 subscription model to share applications. 

Can you extend server usage reports to include such data?

Best,

Piotr Zawistowski

The admin (aka curator) needs to be given more control. The admin should have greater control than the users of the system.

My organization is in the Healthcare industry and we have HIPAA laws to abide by when it comes to data. Not all users should be able to see all data. Developers should not have complete control over the data they publish.

Private studio

• admin should be able to control if users can publish to Alteryx gallery (compliant issues occur when our organization's data is shared to outside users)
• admin should be able to control if user can publish to public gallery (compliant issues occur when all users can all see and run workflows)
• admin should be able to delete subscriptions and users

Collections

• admin should be able to create collections so they can manage the collections and what users have access to (devs should not be able to give any user access to their workflows)
• admin should be able to control if users can create new collections (again, compliance issues)
• admin should be able to grant and remove download of workflow rights
• admin should be able to delete connections

Get tips from Tableau as they have admin controls down with their permissions process.

I wish Alteryx had an Alteryx gallery not only for workflows but for pure data sources as well which we can access with;

• freemium license for certain aspects
• a specific monthly fee or
• a prepaid model...

And I would like to be able to get weather data as a starter;

• historical temperature data is one thing and can be found over the internet so this part may be the freemium one...

But especially the most needed aspects are;

• cloud cover
• relative humidity
• average precipitation rate
• barometric pressure
• wind chill temperature
• wind direction in degrees
• wind gust speed

Obviously 5 day 3 hour forecasts for all these aspects are another thing and probably this will generate some revenue...

This information is so essential in order to accurately forecast

• credit risk in agricultural lending to
• planning electricity loads and pricing...

Mathematica (since version 7) and wolfram has this built in already!

https://www.wolfram.com/products/mathematica/newin7/content/CurrentAndHistoricalWeatherData/

http://demonstrations.wolfram.com/symbol.html?symbol=WeatherData

This is the source of data; http://reference.wolfram.com/language/note/WeatherDataSourceInformation.html

Totally agree that maintaining a data source covering worldwide is not an easy task but I think will help Alteryx users and customers a lot...

Hi

My idea is to facilitate scheduling through Gallery vs the separate scheduler built into Designer. The reasons for this:

1. The current scheduler authentication with Alteryx server via token is a big security concern. This allows all users to see all schedules, workflows, output logs, etc. for the entire server.  
2. It will better interact with the Alteryx 10 version contol. Current scheduler shows all prior versions in the workflow list.
3. Allow the server/gallery admin to setup scheduling rules. Ex: No scheduling during certain windows (for maintance downtimes), max frequency of scheduling, prevent users from scheduling too many jobs at the same time, user level rules.
4. Allow scheduled workflow output to be retrieved from the "Workflow Results" section by the user who scheduled the workflow. Ex: I schedule a workflow that takes 2 hours to run at 6AM each day, then by the time I arrive at the office at 8AM, I can login to the gallery and download the output. 

Thanks,

Ryan

Idea:

To create an IoT district for the Alteryx Gallery...

Rationale:

Many vendors are now focusing on the IoT wave,

having some examples on IoT use cases would be a nice resource for many...

• Please star the idea if you like it,
• Comments are more than welcome

Best

Hello,

Currently we are working on an issue where we are seeing an "inbound pipe" error during a scheduled workflow, terminating at the error.

However, the workflow doesn't officially complete; it simply terminates.

For the majority of workflows, when a workflow runs with errors, completing with errors, even if the workflow was unsuccessful, you can send an email via the events for that workflow, if the workflow completes with errors, to use as an alert or trigger, etc...

However this doesn't work when a workflow suddenly terminates with errors.

I'd like to see functionality added to all ow for an email event when a workflow terminates unexpectedly, without completing.

This way, I could set up a job to re-trigger the workflow if this happens.

This can occur when memory is swamped during the initial workflow.

This functionality would be a huge positive.

Thanks

In Gallery 10, List Boxes (that are within a Radio Button) have their contents sorted horizontally.  Previously (Gallery 9.5) the contents of List Boxes was sorted vertically.  This new orientation makes it very difficult to find specific items within the list.  The problem is particularly severe for long lists, when it becomes common for the check box and associated text to become separated on two different lines.

I would love the ability to select multiple workflows at once to disable/edit/move workflows to a different studio or disable the schedule all at once (so like a check box to select them)- instead of having to manually select each one and move them and have to go back and forth.

This would also help during update time- as the longest part of the updates is waiting for the service to stop.  If i could select all/multiple schedules to disable at once- then the service would be able to stop when I chose (instead of waiting for scheduled workflows to run)

When installing and configuring Alteryx, the wizard allows the administrator to select the Gallery authentication to be used among:

Built-in

Integrated Windows authentication

Integrated Windows authentication with Kerberos

SAML authentication

The note states:

Once an authentication type has been selected, it should not be changed. Changing it may cause technical problems.

The gallery manual states "Once an authentication type has been selected it should not be changed or Gallery functionality may be compromised." 

https://help.alteryx.com/server/current/admin/Configuration/SystemSettings/Gallery.htm?Highlight=%22...

If you are reading this idea suggestion, I hope it is not too late for you. Why allow the user to change the authentication method once the install is completed? What are the options to solve this?

One option would be to grey-out the "Authentication Type" section in the  "Gallery Authentication" screen, so the user is not able to change authentication methods once after the first configuration is set. This would still allow the user to change SAML settings.

Another option, if somehow there is a reason why a user would want to change authentication types even though it is not supported, what about changing the layout to make it more difficult to change the authentication type.

What are your other suggested changes?

This is not relevant if this idea is implemented https://community.alteryx.com/t5/Alteryx-Server-Ideas/Allow-changing-of-Gallery-Authentication-witho...

However, I would imagine that a UI change would be a lot easier to implement that supporting overhauling the user management in the MongoDB.

Mongocontroller.log during its MongoDB dump processing records DB admin password in clear text.    This poses a security risk now only to the company but to the MongoDB itself. 

Is there a security patch ready to be pushed out to eliminate this risk?

Hey Sever Gurus - 

There might times where it would really nice to have a group of workflows that were logically related that you wanted to run without having to invoke a 'run now' for each workflow individually.  Sure, you could technically get there with the Runner macro, but in my case, there are intermittent scenarios in which I'd like to be able to run a set of related workflows to kick the tires, but they run at different schedule frequencies during normal operations.  As it stands now, I have to go hunt through 39239 different workflows, find the 12 associated with project X and tell it to blast away individually.  This brings me a great sadness.  

So what I'd like to be able to have is some flavor of named / logical grouping I could attach to a workflow at upload to scheduling time, I could then tell the scheduler to show me / run everything attached to that grouping.  

Thanks!

brian

Enhance the USER tab in Gallery for showing the active user status, last login time

Easy to filter out the active user

Allow Admin to kill user session 

This may be more from an admin standpoint but once I add workers into a cluster (controller token added), I have no way of knowing if the worker is now added to the cluster unless a workflow starts getting serviced and I view it from the 'View schedules' tab.

This causes issues specially when we have to add multiple of them and need to keep a track of which ones are added to the cluster or not.

On the admin page, I should be able to view the list of the workers that is currently existing on the cluster.