Alteryx Server Ideas

We do NOT want all users to be able to share their DCM connections.  The only way to do this is to disable the options on User Profile as it defaults to enabled for all new users.  

Admins should be able to control this and all user profile setting defaults by role. 

Example, New Artisans should all have access to create new Collections and Schedules, but DCM sharing is disabled.

Hi Alteryx experts!

There were some ideas similar to this one but none like it and really really old ones, so I`m revamping the idea due to recent struggles and the many questions we got on the server discussion board!

Workflow events are nice and helpful but they require the user to add it to every single workflow.

The Gallery admin also struggles to know when a schedule fails. 

There was the Server Usage Report before, but now most server admins have no idea when a schedule fails.

There are many ways of managing schedules and failed jobs (MongoDB, logs, events), but it would be nice to add a simple option to notify a user on each schedule. It would be even better if we added another option to enable this option in all schedules globally!

This idea could be combined with this one from @fjablo 

https://community.alteryx.com/t5/Alteryx-Server-Ideas/Notification-from-the-Alteryx-Server-when-a-sc...

Let me know what you all think!

Best,

Fernando Vizcaino

Currently Validation runs follow these two rules:

1. The "Validation Run" option is enabled by default for all newly uploaded workflows.
2. The validation process runs using the local user account, even when the workflow requires specific workflow credentials to execute - often resulting in access or permission errors that would not occur in a real run.

To improve flexibility and reduce false flags created by the validation run, I'd like to propose the following enhancements:

1. User-Configurable Default for Validation Runs
   Allow a Designer user to disable the 'validate and run' option by default in the User Settings.
2. Customisable Validation Run As Functionality
   Provide the option for a user to specify who the validation run should run as, rather than always defaulting to the local user.

These changes would make the validation workflows more reliable for users using workflow credentials within their Server.

Currently the default 'Rows Per Page' is set to 10 when within various pages on the Gallery. 

As we add more and more Apps to our Gallery it would help to be able to increase the default so it is higher than 10.

This will help ensure users do not forget about or miss tools that are available to them which are hidden on other pages. Additionally, they will not need to remember what page to jump to if the App does not pull through to the first 10 rows, or prevent the need for them having to increase the number of 'Rows Per Page' themselves.

Hello,

Right now, we can manage DCM connections through API.

However, a connection is an object composed of :
-a datasource (like my sharepoint tenant or this specific postgresql database)
-credentials (my user / password or a token)

When creating a DCM connection, credentials and datasource are required but you can't create (or even get) it through API independantly.

So basically what I would like :
-management of datasources
-management of connection (and when creating, either creating a new datasource or referring to an existing datasource)
-management of credentials


I feel like we're in the middle of the bridge here, with an almost awesome solution but not finished.
NB : I understand we can't get credentials secret but being able to create it would be great.

Best regards,

Simon

Idea: Option to receive an email notification when a schedule gets disabled (could be added in the user settings, see attached picture)

Business Impact: The implementation of this idea would reduce delays that might even have a financial impact because

not receiving any notifications when a schedule was disabled could lead to

• important processes not being executed and users realizing that only at a later point in time (>> potential financial impact and stress)
• the user not being able deliver a report in time (>> potential financial impact)
• huge effort to manually track the workflow results on the server (or email notifications after a successfull run) to avoid the above two bullet points (>> financial impact due to waste of time)

I would be glad if you could implement this idea because I think it would be useful for a lot of people!

The V3 jobs API endpoint woefully lacks any usefulness. The current endpoint only has a get jobs/{jobid} method that is not useful because a database admin must query the database to get a list of all job IDs. To add insult to injury, this method is only limited to the user whose job is running or queued.

These are new features that I am proposing

1. GET jobs/list—This method must be callable by all users. Parameters such as none (default—full list), running, or queued will display jobs with the appropriate status. The job ID of the running or queued job and the worker it is running on must be included in the resultset.

2. GET jobs/{ownerid} — This method must be callable by all users. Like the GET jobs/list above, the resultset must include the job ID of the running or queued job and the worker it is running on.

3. DELETE jobs/{jobid} — This method must be callable by the person who scheduled the job, the owner of the workflow, or the curator. This method is the equivalent of cancelling a job on the Server Admin page - #!/admin/jobs by a curator. All three mentioned people have a vested interest in the running or queued jobs on the server and must be able to cancel those jobs.

4. POST jobs/reassign/{jobid}/{new_job_tag} — This method is restricted to the curator and applies to any job in a queued state. It allows a curator to reassign a job to another job tag or the first available worker for reasons determined by the curator.

This is an enhancement that I am proposing
1. GET jobs/{jobid} — This method must be callable by all users. This will allow any user to get the details of any running or queued job.

Logging requirements

All DELETE or POST methods must be logged and purged based on the Persistence Option > Delete queue and results after (days).

It would be great if you could overwrite an existing workflow when saving to the gallery from designer. It could be a simple popup with a yes/no option to overwrite/save a new copy. Currently, you would have to

1) Save your workflow to the Gallery.

2) Click on ok and be taken to that workflow.

3) Go back to your private studio.

4) Search for the app you want to replace.

5) Realize you have 7 copies of the same workflow with the same name and try to determine which one you want to replace. (this could just be a "me" problem)

6) Select that app

7) Click on replace workflow.

😎 type the name of the workflow in the box.

9) Look through your list of 7 workflows and choose the one that was just uploaded. Usually the first in the list I think.

10) Lament that it took way too many steps.

I recognize that you can open workflows from the gallery in designer which does allow overwriting, but I've run into issues with 1) external dependencies not working as expected (ie packaged assets don't quite work the way I want) and 2) about half the time it will simply give you root errors and then your only option is to save to a folder and then go through the process above.

Hello all,

This may be a little controversial. As of today, when you buy an Alteryx Server, the basic package covers up to 4 cores :
https://community.alteryx.com/t5/Alteryx-Server-Knowledge-Base/How-Alteryx-defines-cores-for-licensi...

I have always known that. But these last years, the technology, the world has evolved. Especially the number of cores in a server. As an example, AMD Epyc CPU for server begin at 8 cores :
https://www.amd.com/en/processors/epyc-7002-series

So the idea is to update the number of cores in initial package for 8 or even 16 cores. It would :
-make Alteryx more competitive
-cost only very few money
-end some user frustration

Moreover, Alteryx Server Additional Capacity license should be 4 cores.

Best regards,

Simon

Hi Alteryx support team,

We would like to use the search functionality available in the schedules tab of Alteryx gallery and when anyone searches the schedule by typing the name in search box on schedules tab, he/she should get list of the results along with the schedule information such as frequency of schedule, times run etc.

As of now, when one searches results are displayed as jobs and their run history.

Case reference -  Alteryx, Inc Case # 00606791

Regards,

milan

Hello all,

Right now, we can choose either MongoDb or Microsoft SQL Server as a backend. I would suggest to add Postgresql. Why ?

-it's open-source
-it's reliable
-it's free
-it works well on many environments
-it's popular
-it's already used as backend for Tableau or Qlik and many others
-it respects SQL norm and doesn't have a lot of specificity

Best regards,

Simon

Commas save lives! With large numbers, it's difficult to see what number was actually entered without commas present, and the wrong number can easily be entered as a result:

Is this number

• 100,000
• 1,000,000
• 10,000,000

It's hard to say without taking a really close look!

When scheduling an analytical app on Gallery, there is no UI for submitting app values. This significantly limits the value of scheduling workflows and using analytical apps. With this feature, it would allow our users to have more flexible scheduling while also simply maintaining one workflow. Because this feature doesn't exist, we have had to build workarounds by either creating multiple workflows or utilizing APIs. 

Since this feature is already available for manual runs and APIS (shown below), it shouldn't be a reach to also have this feature when scheduling a run.

Manual Method:

API Method: GET /workflows/{appId}/questions

Scheduling Method (no app questions): 

Currently, failed job results stay in the Mongo DB forever.  Please either make it adhere to the same coding in the Server Settings for "Delete queue and results after (days)" setting, or make it a separate option for failed jobs. 

When I create a DCM Entry in Gallery, it would be great if the users I share it with would also be able to reference the credentials in their desktop designer when they sync their connections to the Gallery. 

I would like to be able to view all schedule results from all users in my Gallery.  Currently, I can see the "Workflow Results" for any schedules I create.  But I cannot see them for users unless they share them.  As admin, I want an option on the Gallery Admin screen just like there is on the Gallery user screen to see "Workflow Results" for every schedule that is in the Scheduler Database, regardless of who the user shared it with.

Currently, the only way to accomplish this is to go to Designer, View Schedules, connect to the Controller, and go to the Results tab.  This should be built into the Admin screen in the Gallery.

Currently, we see the Districts and Collections now compressed into a list view. 

Previously, the Server had the widgets feature which really showcased the self-service nature of the Sever. Losing that just made decreased the emphasis on user experience. 

It would be great to allow Server Admins to decide whether they want lists or widgets to be available toggles as a design feature for both districts and collections will be of great help.

In addition, regardless of the option, the image size and wording size should be much larger - easier for people to see. Right now, we have to zoom to 150% to make it easier for ourselves to see. Having the ability to control font size, font control with bolds, italtics, etc. will be very helpful as well.

After a job is run on Alteryx Server, Gallery lists Job Results with a Status column containing with one of 2 values:

• Error (represented by a red exclamation point icon); and
• Success (represented by a green checkmark icon).
  See attached screenshot for illustration.

If any WARNING messages are generated by the workflow, the operator/user is unaware unless they take the time to expand the message log details, then scroll through the long list of messages that typically appear in the log.

Because the Success Icon appears whether there are Warnings or not, the user must dutifully spend extra time scrolling through the list looking for Warnings even if there are none to be found.

My Idea: provide additional information under the Status column in one or more of these ways:

1. add a 3rd status option with a yellow/orange icon that indicates if/when 1 or more warnings are present
   • This should be a quick/easy enhancement that would provide immediate value
     
     
2. append one or more numbers after the Icon to indicate counts (see mock-up example)
   • There seems to be ample space for this type of info
   • This could be done at a later date as a subsequent enhancement

I think that the user would benefit from a filter where they could focus on errors, warnings, or other types of messages in the same spirit as the Designer interface, but I recognize that would be a lot of work and I am not asking for that now.

We leverage Active Directory groups to manage user permissions to most of our company's resources like databases, file shares, applications, etc.  This idea is for the ability to manage a Gallery Data Connection via an Active Directory group.  In many cases, our AD group membership actually dictates what permissions a gallery connection should have, but we must manually add/remove users to the Alteryx connection to keep it synched with AD.

I think there are several ways Alteryx could be enhanced to support this; i.e. the AD group could be specified on the connection itself or it could be inherited from a Studio where the subscription is enhanced to support assigning AD groups to it (which could benefit other areas of Alteryx).

I'm told by Alteryx support that this functionality is unsupported but to post the idea here.  If anyone knows of workarounds to this limitation I'd certainly be interested!