Alteryx Server Ideas

Share your Server product ideas - we're listening!
Submitting an Idea?

Be sure to review our Idea Submission Guidelines for more information!

Submission Guidelines

Featured Ideas

Hello,

 

We recently upgraded our on-prem instance of Alteryx Server/Gallery to version: -

 

  • Client: 2020.1.0
  • Server: 2021.3.3.63061
  • Server Binaries: 2021.3.3.63061
  • Service Layer
  • Master: 2021.3.3.63061

 

We have noticed that the search functionality in various areas (top and right-side) no longer return results using a "contains" but rather it is doing an "exact" or "starts with" keyword search. This is very frustrating to many users as we can't easily find our workflows quickly compared to previous versions.

 

Please improve search functionality.

As the title says: please make the date modified data more granular e.g. yyyy-mm-dd HH:MM:SS and not 6 months ago

 

The current behaviour is the same in designer & browser, but is more important in browser (first screenshot) as there isn't an indicator or method or sorting the order.

 

Joe_Lipski_0-1636614871689.png

 

 

Joe_Lipski_1-1636614871707.png

 

Joe_Lipski_2-1636614871724.png

 

I would suggest a service split to simplify maintenance actions in the Alteryx Server.

 

Split Alteryx Service into 5 services:

 

 Alteryx controller

  • Dependencies: Alteryx Database
  • Purpose: Controls job submissions
  • Meaning: The Alteryx controller Service stopped means neither the users or the scheduler can submit new jobs

Alteryx Database

  • Dependencies: N/A
  • Purpose: Database
  • Meaning: The Alteryx Database Service stopped means all the platform is down

Alteryx Gallery

  • Dependencies: Alteryx Database
  • Purpose: Controls the Web UI
  • Meaning: Alteryx Gallery Service stopped means the gallery web page is down

Alteryx Scheduler

  • Dependencies: Alteryx controller, Alteryx Database
  • Purpose: Controls the scheduled jobs
  • Meaning: The Alteryx Scheduler Service stopped means the users can still submit jobs manually but scheduled jobs wont be submited

Alteryx Worker

  • Dependencies: Alteryx controller, Alteryx Database (only applicable if the server where the Alteryx Worker Service is running the Alteryx controller)
  • Purpose: Executes the jobs
  • Meaning: The Alteryx Worker Service stopped means no job will be executed on the node

 

This service split will help perform some maintenance tasks and enables the Platform Administrators to shutdown the platform correctly shutting down the services in the correct order.


Usage Example 1 (Cold Backup):

  • Stop the controller so no more jobs can be submitted
  • Stop all the workers
  • After all the workers have stopped the Alteryx Database Service and the rest of the remaining services can be shutdown
  • Preform the Cold Backup
  • Start the services

Usage Example 2 (Changes in the worker configuration - By doing this the users will still have access to the gallery and their jobs):

  • Make changes in the worker configuration
  • Restart only the worker service

Usage Example 3 (Changes in the Gallery Page or Configurations):

  • Stop the Gallery Service
  • Make the changes
  • Start the Gallery Service

Currently, Alteryx Server lacks rich job scheduling functionality to other products like Control-M and Informatica's Scheduler

 

Feature Requests:

 

1) Ability to configure job retries on failure without having to rerun the workflow based on a  event trigger: https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/How-to-run-a-workflow-from-an-event...

 

There are common occurrences where a workflow may fail to connect to Input sources and a retry would normally resolve the issue. 

 

2) More user friendly way to setup dependencies between scheduled workflows.  For example, if workflow A fails it triggers workflow B to run.  If workflow B runs without errors, it triggers workflow C to run.  Currently, we would need to configure this based upon events.  A complex chain of scheduled workflows becomes difficult to manage and scale.

 

currently, there isn't any way to fully delete (safely) a user from the gallery. So if there is a previous client or previous employee in gallery, we cannot clean up the gallery settings - only "disable". It would be great to have a "trash can" symbol next to the users where we can remove them from the server and keep all of the users clean. 

One of our Server customers has a need to disable all schedules temporarily across all worker nodes.  I do not see an easy way to do this unless we go into each worker's settings and disable from there, but this is not ideal.

 

The reason is for scheduled maintenance windows during a large upgrade or migration.  Currently stopping the Alteryx Service on each worker is time consuming.

 

Thank you! 

We have at the moment our server configured to work with SAML credentials. Whenever a user sets the credentials option to be "User must specify own credentials" the validation is performed using the servers own local user, giving out an error whenever some workflows with SSO data access are uploaded.

 

It would be great if a window would pop up or credentials could be configured for the validation to aviod seeing the error to show up.

The gallery shouldn't allow to create data connections with already existing names.

For example, in designer it's difficult to choose which data connection we want to work with if they have the same name, please verify the images in attachment.

I would like to be able to see which collection(s) a Workflow is in since in future users will access the majority of workflows via a Collection - so if a user asks me about access to a certain workflow I can find out how they would get access to it i.e. which Collection(s) it was available in and who owns those.

When a user publishes and schedules a workflow on the gallery, they have the option to specify their time zone to ensure that the execution of the workflow occurs at the appropriate time. However, if the workflow invokes the DateTimeNow() function, the captured time is in UTC. If it is important for the end-user to have that time that is captured be in their local time zone, they will need to manually (either within the workflow or as a user input for an Analytic App) specify the offset from UTC.

 

Instead, there should be an Engine variable that captures the offset (or the time zone) that the workflow was executed from (or scheduled in), which can dynamically adjust the DateTimeNow() output appropriately.

The current Gallery API executes a job until it reaches a completion state with either success or failure.  Once reaching that state, the callout to /v1/jobs/{jobId}/ will return an array of messages that can then be parsed to gather information about the execution of the job, similar to the output you see in designer or via the CLI when running a job directly.

 

It would be nice if the callout to the jobs endpoint would constantly update and return the messages array with each callout.  With jobs that take longer to execute, our Gallery API wrapper could then report back to us and let us know what messages have come out as the jobs runs.  For example, if a process takes 2 hours to execute, we might want to know how far along the job is or if it has met a special condition that will cause it to run longer, etc.  To do that, we could add in message tools that report info messages to us.  Unfortunately, these messages are ineffective if we are running via the API because we won't see them until the job has fully completed.

As a Gallery Admin I would like to be able to add and remove a user from local groups on the User page.

I realise that this would only work for local groups and that AD groups would need to be excluded (and indicated as unavailable for editing)

 

 

Paul_Holden_1-1624525178113.png

 

When a render tool is run on Designer pointed to a temporary file the log gives you a clickable link to access the output.  When deployed to the Gallery unless you have given it a specific output destination with %temp% in the filename you get... nothing.  

 

What did I expect?  The pdf or other temp file to render on the screen or at least download for me.  Or give me a dropdown selection of the various files render could create for me.

2021-09-29_15-20-05.png

 

In prior versions, Gallery Admins could easily and quickly reactivate users that were deactivated (e.g., and employee leaves the company so we inactivate their Gallery account, but then they come back to the company in a few months with the same name and email).  

 

Now, the only way to do this is to edit the Mongo page.


We need a way via the UI to reactivate users, like we did in the old UI.


I suggest adding an option in the current User List/Grid to be able to filter for Inactive users.

Apologies for posting this in the community ideas forum - couldn't find a better location.

 

There are a rich collection of Alteryx Tools which are housed in the public Gallery - and a sub-set of these are created by and certified by Alteryx.   Could we provide a mechanism to filter to only show these Alteryx Certified assets so that we can see which have the high level of trust?

 

Many thanks

 

Good Day.

 

We would like a built-in process that would search or, and resolve, workflows that are stuck in the "initializing" state. These seem to happen for various reasons but communication problems between the controller and workers .. usually a socket timeout.. which appears  to be most problematic. It seems  that these type of errors should be expected in all but the most stable environments,

 

Currently, the only tool that we have to solve this problem is to restart the Alteryx Service on the controller and while this works there tendency to cause some collateral damage in workflows ...erroring or restarting from their beginning.

 

There may be a way to solve this without restarting the service by editing Mongo using a tool like Robo 3T but that is unproven and has its own risk.

 

After dealing with this issue and struggling for quiet some time we think that the best option is to implement a "clean up" DB process that will run every 5 min or so, capture a list of workflows in the "initializing" state , then compare that list to one in the next 5 min cycle and fix any workflows that appear in both lists. We think that returning  any stuck workflows to the queued state would be the best Fix  option.

 

We just don't want to continue to use Restart the Service process to solve this issue and accept the collateral damage.

 

Thank you for your consideration

 

Tom D  

 

 

 

Hi Team,

 

Earlier when we are in 2020.2 version we used to have "Company field" option when we are creating New Private Studio in the Subscription tab . Now we have Upgraded to 2020.4 version and we no longer see that option .

 

We have used Company Field to Tag the Solutions with certain specifications that would help us with the cost recovery mechanism.

 

So we need to have Option in our Use Case again.  If could you please include "Company Field" option in Subscription tab or if Subscription is deprecated then in Collection tab for coming versions it will help us a lot.

 

Hello,
One of the frustrations we have faced in using Alteryx Gallery is the question "How do we set up many users with their respective collections easily?".

If we take for an example, the scenario where a company has 300 potential users of the gallery, who are all going to login and generate a report based on their department.
In order for them not to be able to generate the reports on other departments, the report generation workflows are put into collections. The current solution to this (atleast on SAML Authentication), is for a user to sign up, and then a Curator to assign them to their given collection. This is fine for small scale solutions, but the purpose of server is allowing for large scale deployment and automation of tasks, and this is far from ideal for a larger company.

If the server is setup on Windows Authentication, the users are able to be categorised within the Windows Active Directory, and then these groups (which may pre-exist) are able to be added to the gallery straight from the AD (see here), however this is not a feature within SAML Authentication.

From my knowledge, SAML Authentication should easily allow for this functionality, and it works very similar to Windows Active Directory. I mentioned this on a call with a Customer Support Engineer, and he explained that this wasn't part of his known roadmap for the Alteryx Gallery. 

I do believe this to be an extension of a current post on the Alteryx forum, however, this details opening the API to allow for this on an API level, however I would also suggest for this to be integrated within Alteryx Gallery, as not all users are experienced with using, or building tools around, the API.
 
Cheers,
TheOC

I am in the process of migrating apps from the old gallery to the new. I have screen captures of the results from the same app in both. In the older gallery version, if there is only a single file type available, it defaults to that file type and you click the icon for the type. In the new gallery version, you must select a file type before you can download the file, even if there is only a single type available. The dropdown makes sense for one that you have multiple types (like pcxml), but it makes no sense to require the user to go through an extra step to select a type before downloading when that's the only type they can download. Please see all the screen captures. The blue-ish background is from the new gallery.

At some point we would like Alteryx Gallery to support SSO via SAML and Authorization via AD groups. The way I want is to have Authentication via SAML and Authorization via AD groups. For instance one of our apps Tableau: It does authentication via SAML (SSO) and for authorization, we import AD groups into Tableau thrice a day(stores the groups in a .xml file), once the groups are in the Tableau, we secure the objects within Tableau using that LDAP groups (which kind of become local groups after import). Basically the userid after the successful authentication step is used by the app for authorization.

I just stated Tableau as one of the ways to implement Authentication and Authorization for an enterprise app. If Alteryx Gallery needs to be an enterprise app, you will need to look into this idea. 

 

Thanks
Raj

Top Liked Authors