Alteryx Server Ideas

Alteryx DCM has been an incredibly useful addition that supports key security concerns from companies. Currently, only three external key vaults are supported:

• Hashicorp Vault (KV secrets engine) - supported for Designer 22.3 and later.

• CyberArk Conjur - supported for Designer 22.3 and later.

• AWS Secrets Manager

https://help.alteryx.com/current/en/designer/tools/dcm---designer/dcm-external-vaults.html## 

I propose that we also include Delinea Secret Server.

Thank you and hopefully we can start to add more to make this feature widely useable and support security compliance.

Hi all,

In an enterprise environment - DB connections need to be set up from the server and pushed down to your users; and they need to be managed across the various servers in your software lifecycle.

In other words - you may have a sandpit / dev server env; a UAT env; a pre-prod; and a prod env - and each of these need to have the same DCM credential IDs so that users can access these.     

(before you say "you can do this from the desktop) - that is true, however that's not a workable solution in an enterprise env because that means that users can change the password from their desktop into a prod env which is a breach of IT General Controls)

The solution here is to break DCM out in to a separate service - where

- all your servers (dev; UAT; Pre-Prod; Prod) can all point to one instance of DCM

- users can maintain their own connections and credentials

        - Each needs to have up to 2 owners so that you can deal with people moving jobs / leaving the firm

- users can also entitle these connections and credentials to their team members so that when the team member logs in, it shows a popup saying "you've just been given access to new credentials / connections"

- A particular connection may have multiple different variants - depending on the environment.

        - HR Data may point to a UAT version of HR data if you're on the UAT server; and to Prod if you're on the Prod server

        - if a connection is environment specific - then it also needs to have segregated credentials (since the login to your UAT HR Data may not be the same as prod).

Thank you all

sean

cc: @wesley-siu @_PavelP 

User who share Apps/Workflows with other users in a collection are not able to see the results of the other users executions directly in the gallery.

Could you please add the possibility to share workflow results in the Alteryx Gallery?

after run workflow in server, it has to download output files one by one. it very annoying when the number is huge.

please change like other platform like SharePoint etc. enable select all options and/or download all options.

Given some jobs are scheduled / can take a while to run it would be useful if Server provided the option to notify the submitting user when it has been completed, which a link to the results.

If you look at post: Re: How do I extract Server Job Run ID at runtime - Alteryx Community amongs others you can see there have been various attempts to create workarounds for this using a combination of API's & Mongo DB calls to build up the information to provide a URL in an email at the end of the flow. However, it feels like this should be an out of the box notification that can be enabled/disabled at the flow level with Alteryx Server.

Improve Gallery scheduling to allow the end user to specify company denoted Holidays when scheduling a workflow. If the workflow is scheduled on a Holiday the schedule would not run. This should be configurable per workflow schedule. Example: A daily report Monday through Friday would be able to skip Holidays based off a Holiday exclusion list. 

Hello Alteryx Server Admins,

It would be fantastic to manage users' permissions with user groups. This would help manage all users with permission to create collections and schedules from a centralized page.

Something like this:

Best,

Fernando Vizcaino

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.

As an admin - would like to have the following features on the Gallery

1. add summary cards to TOP of user page that show same summary as diagnostics page

2. "export to excel" icon 

3. ability to filter date

4. allow selection of ALL

5. allow me to default my settings choice so its always "all" - screen shot below

I might be missing something here but as far as I know there is no feature (user or admin) providing a list of data connections being used by a specific workflow. And conversely, which workflows use a given data connection. This should work for both 'Standard' Data Connections as well as the DCM. 

I would like to propose a number of small enhancements to the Gallery:

1. Time format. The 12-hour time format (

    

   ) is confusing to everybody except Americans. Please add support for a 24-hour format. This could be done either by extending the Locale settings or by a separate check box. Please make sure that this time format is used everywhere in the Gallery (last update, last run, schedule, etc.).
2. Date format. Even though using English as GUI language, I prefer the time format according to ISO 8601-1, namely "YYYY-MM-DD". Please add support for this format, independent of selected language.
3. Number of Rows per Page in My Workspace: Each time I open My Workspace, the number of listed workflows per page is set back to 10. Please add support to set the default number of workflows in the user settings or at least preserve the chosen number within the same session.
4. Fully utilize the screen in My Workspace: Even after switching to more than 10 rows per page, nearly half of my screen stays empty. Please add function to utilize the screen completely.
   

When adding jobs to the queue via API call, you currently cannot specify the name of the job.

Running the job directly from gallery allows this as in the picture below, but there is no setting to do so in the API.

When a workflow is used in many different situations, being able to specify a name for the individual run will make tracking and troubleshooting easier.

Add entered parameter into the result panel. It helps to debug process and audit.
sometime users save file in different way, and it not directly related to the interactive question
(e.g. Question: "SAP FBL5N Data" Input: "EXPORT (2).XLSX")
when error happen, I need the source file and the parameter.
if this idea is implemented, i just need the screenshot, which faster, without user to re-run the workflow to screenshot and share the parameter setup.

Hi all,

Having all the schedules/results centralized in the same place would be neat!

Option 1: Have all on the same page and have an additional column to describe the shared source.

Option 2: Have a separation between my own schedules and the ones shared with me.

Best,

Fernando Vizcaino

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.

It would be good to have a new field with the owner of the data connection, when users asks to be part of a data connection, we should know who is the identified owner to contact and ask for approval.

Thanks.

Regards

Joana Santos

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

Most companies work on a period level basis and that is every 4 weeks.  There is no way in Alteryx currently to schedule workflows to run only every 4 weeks, the monthly options do not match this cadence.  If the option was added to select "every X week(s) on X day" this would also encompass biweekly scheduling as well.  Outlook currently has exactly what would be needed (screenshot attached.)