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
It's the most wonderful time of the year - Santalytics 2020 is here! This year, Santa's workshop needs the help of the Alteryx Community to help get back on track, so head over to the Group Hub for all the info to get started!

Featured Ideas

Hi

In a heavily used server environment, and depending on how workflows are deployed, it is possible to accumulate a vast number of "one off" workflows that could/should be deleted  as they would never be used again. In one of our environments we have over 1 million of these.

 

Currently we are manually deleting them 500 at a time but have asked if there is a way to script the delete process to make it more efficient. We have been told that to really delete a workflow you would need to touch at least 4 collections.

 

Can we have a Delete workflow API in one of the next releases in order to address this issue?

 

Thank you

 

Tom Diroff

I would like to see the enhancement of being able to schedule a start and stop time for specific jobs that need to run multiple times per day, so they don't run during the nightly backup periods of the Alteryx server. This can cause the daily backups of the Alteryx Gallery to fail. Currently SQL Server Management Studio/SQL Server has the function to able to schedule start and stop times for specific job. Currently Scheduler page on Alteryx Gallery/Server lacks this feature.

 

SQL Server Management Studio

mackedet_0-1590532280855.png

Schedules on Alteryx Gallery/Server

mackedet_1-1590532639645.png

 

 

It would be very useful to have a standardized method to set up notifications to the server admins and to the job owner themselves if an alteryx canvas fails (error).

 

My understanding is that currently the only way to do notifications on failure for every canvas is for every canvas to individually set up events.   On a large implementation, this becomes very difficult to manage.

 

Standard notification for job failures.png

I am noticing what I think it's a big gap in terms of turnover and job changes.  Even though you can add workflows to a Collection for development and update purposes. Only the original owner/publisher can see the version history for a workflow. At least that appears to be the case in 2020.1

 

Is there any discussion for the road map to include a way to transfer the ownership of a workflow from one user to another? this would alleviate the need to publish a brand new version and then reset all the scheduling. 

For scheduled jobs, there should be an option to include performance profiling in output logs globally.  Basically we are looking at how we can understand which custom macros are in use, and in which workflows, and one way to do this would be to get the output logs into another tool (i.e., splunk), and then set up some queries there.  It would work, but I would have to tell N developers to go set performance profiling on, re-upload their workflows, ect.  

 

But why not have a switch on server / gallery that just turns this feature on globally for every scheduled workflow?  

 

Thank you for attending my TED talk on why performance profiling should have an option to be set globally. 

*This is an idea from @cneivam  from the Portuguese Community*

 

  • Being able to control the workload in Alteryx Server (for example, making sure that a workflow can run only when another set of workflows finish running)

 

It would be good to have these table headers sizable, so that it can be expanded to display complete Name (and other fields).

 

nanda419_1-1578508155151.png

Currently the e-mail settings for the server are set up using a wizard and are not available within the admin UI.

 

Please could you add an explicit section to the Admin UI to allow the admin team to set up approved SMTP settings, allowing this all to be managed in one admin console.

 

Further: Can you allow the admins to push these settings down to the desktop users.   This would allow the admin team to control the SMTP usage and prevent data leakage.   It would also reduce complexity for the user since the SMTP settings are all pre-set making eMail tools; and Events easier to set up.

 

CentralEMailSetup.png

Could the community receive a comprehensive data dictionary of all the collections in Mongo with:

- Description of each collection

- Description of each attribute (or field) within each collection

- Documentation of joins between the collections

 

A great example can be seen in how Tableau documents their postgresSQL tables: https://help.tableau.com/current/server/en-us/data_dictionary.htm

 

This would be extremely helpful as we are determining which collections we need to store, how to construct queries and how to build analytics on our assets. 

 

Thank you!

  • Administration

Given the need for administrators to be able to perform analysis and monitoring on server performance; user usage etc - it is necessary to provide full documentation for both the API and the database underlying the server so that admins can use this to good effect.

 

Ref: https://community.alteryx.com/t5/Alteryx-Server-Discussions/Server-API-Download-packages-for-surveil...

 

Although very limited documentation is available on the server API (https://gallery.alteryx.com/api-docs) what we're looking for is a much more fully formed and navigable experience like some of the examples below.

 

This will make building helper processes substantially easier; as well as allow admins to fully manage their environment.

 

Many thanks

S

cc: @HeatherHarris @revathi @AshwiniChezhiyan @LizaNemchynova

 

  • Administration

As the Server Admin I'd like to have the ability to view ALL "Workflow Results" for all Subscriptions.This will give the highest level admin the ability to monitor all schedules (on the entire server instance) and monitor if they are unable to complete successfully (example- unable to allocate memory) and any other errors are occurring. 

 

Knowing this information will help the server administrator understand if there are issues with the server itself (e.g. if we need more workers or to simply adjust actual server system settings..etc..)

 

 

 

 

We have several clients that operate in a Multi-Forest environment due to mergers and acquisitions.  Currently with Alteryx Server the only option we can offer them is to use Built-In authentication.  A lot of corporate and particularly finance institutions prefer a single sign on approach and utilise Windows authentication to do this.

 

Would it be possible to add support for Multi-Forest organisations into Server to support organisations going through mergers and acquisitions?

 

This would really benefit us in selling Server in to organisations with complex structures and reduce friction in publishing or preparing workflows.

Now, gallery does not support AD group , need to setup user one by one.

If gallery support AD group synchronization, it is more convenient for gallery admin to manage large number of users.

By assigning AD users to AD group, it will reduce the maintenance task of gallery admin, since gallery admin don't need to grant rights in the gallery directly. 

This idea covers 2 things:

- Disabling certain tools for users

- Pushing out other tools

 

Disabling;

- If we want to disable a particular tool for everyone or for specific users - then we need to go to every single deployed machine and adjust settings or delete some DLLs.

- What we would need is to be able to take a user / group of users - and de-select certain tools or apply limits

- In our corporate environment - every designer needs to check in with the server before fully starting up.   If it cannot connect to the server, it needs to terminate gracefully

- As the designer logs in - the first negotiated conversation is "What tools and capabilities and standard default settings should I have"

 

Pushing Out:

- If a useful tool is brought into our environment (like the JIRA connector here: https://gallery.alteryx.com/#!app/JIRA-Connector/58d87c2feffc2a0dd0b5ed8f or the CREW macros) - we want to be able to push these out to all the users

- Again - every designer checks in with the server first

- Then negotiates tools

- then downloads any missing tools or updates new versions of existing tools.

 

This kind of central server capability is essential in any enterprise deployment of several hundred seats.

 

 

 

 

 

 

  • Administration

Right now, if you are using Windows Authentication, you can map AD group and users on the Permissions and Collections tab.  But for some reason, you can't use AD groups on the Data Connections tab.  Most of our databases are already secured by in-house AD groups in which you have to be a member in order to access that database.  Instead of managing a 2nd, most likely duplicate, list of users in the Data Connections tab I would like to be able to map the pre-existing AD group to that data connection.  That also means I don't have to service access requests.  If someone wants access to a database, they talk to the database owners, get added to the group and then they automatically can pull that data into Alteryx.

  • Administration

I work at a large organization where Security and Privacy are of utmost importance. The ideology that we need to follow is Least Privilege and Need to Know.

 

We (Curators) do not want all the Artisans to publish workflows to Home Page, either knowingly or unknowingly. We however do want to allow a few power users to publish their work in Home Page, but currently the Gallery does not provide the ability to pick and choose who can share workflows publicly. We are educating users to not share any contents publicly, but as we scale up, it will be difficult to manage and govern this.

 

I'm suggesting to implement a global Yes/No feature that will Enable/Disable Artisans to publish contents in Home Page (just like the way we have for Jobs/Scheduling feature). Further, in Users section, Edit User setting needs to have a Yes/No button that will allow Curators to let certain Artisans place workflows in My Company's Gallery.

 

Organizations that never want any workflow to be shared publicly can disable this feature using global Yes/No button. Organizations (like the one I work at) that want to enable this only for certain Artisans, can set the Global Yes/No to No, and then in Users tab, they can pick and choose the Users that need this functionality (which will override the global default). Finally Organizations that do not really care about this functionality can just set the global setting to Yes.

 

Hoping other organizations find value in this functionality as well. Thanks.

Please Enable OAuth 2.0/OpenID Support for Alteryx Server  & Connect. Currently, it supports only AD , SAML . 

 

Current SAML has limitations, Unable to import Security groups from LDAP/AD if SAML is enabled.  

 

 

As users change roles; or possibly even leave the firm - we need to automatically manage the ownership of their and their permission.

 

- We need to be able to export all permissions and ownership of assets by user using an API

- We then need to be able to revoke permissions using an API (we have a central entitlement management process that this can be tied into)

- we also need to trigger a revoke on all licenses via API.

 

If done within Alteryx server:

- When a dept code on a user changes; or user leaves - trigger an invalidate on all assets.

- Workflow to both the primary and secondary owner to ask for a new owner

- Also automatically trigger a revoke on all licenses

Would like to see a Notification hierarchy implemented to Gallery. Currently, the settings that control notifications are at the Gallery-level....where only the admin can control, for example, notifying users if a new workflow was added to a collection they belong too. Could this setting be inherited, but then, for example, a Collection owner can implement their own notification settings that overrides the Gallery default? Using the same example as before, perhaps the Collection owner could disable notifying their Users if a new workflow is loaded to the collection.

 

Nick

We have the Local License Server installed.  Right now, if a Designer user changes roles, or leaves the company, they have to release their license from their client-side machine.  If they don't release it properly, and IT can't get us into their machines, then we have to wait 7 days for that license to roll off the server.  There should be a way for a system admin to forcefully revoke someone's license.