Alteryx Server Ideas

The Schedules tab of the Gallery currently lists all schedules, 20 to a page, with no option to filter.  I am currently managing 183 active schedules.  In order to find a single schedule, I have to sort by Workflow name, then page through 10 pages of schedules to find the schedule I'm looking for.

Please add an option to filter this list. 

Ideally, I would like to be able to filter on multiple fields at once (example:  Priority = High, Status = Active, Owner = Bob Smith, Times Run > 20).  Barring that, a simple search option on workflow name, similar to the search option on the Collections tab, would be enough.

Sorry if this idea has already been addressed, but I would love an enhancement that would allow users to upload multiple files to the Gallery to be processed and ran by a published app. 

Currently, the only way to accomplish this is by adding multiple File Browse tools to the published app. But if you have a workflow that needs to upload more than a couple files, this becomes a problem. 

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!

When using In-DB with iSeries over Generic ODBC everything works fine in Designer however when executing via Gallery process fails because a semi-colon ";" is added to the SQL statement as a terminator character and iSeries rejects this SQL0104 - Token ; was not valid. Valid Values < END OF STATEMENT > 

We have a MongoDB connection string that we plug in to RuntimeSettings.xml during install.  Upon startup, the Mongo connection fails because RuntimeSettings.xml expects the connecting string to be encrypted.  The fix for this, is for someone to manually update the MongoDB connection via the Alteryx UI.  We would like a way to encrypt the MongoDB connection string for RuntimeSettings.xml before we start Alteryx for the first time.

I would like to be able to open a user from the gallery - and see which collection(s) that user is in

If my collection is broken - I cant see users at all

Hey Team,

With 2020.3, the new Groups feature came into light, which is great, but seems like it was only half-thought.

It would have been nicely complemented with some API endpoints that would allow managing the groups' members - add, remove, list members, etc.

Seems like the API on Alteryx is like 100 steps behind and seems like the new developments are not considering adding APIs for the new released features. I feel this is a product roadmap issue.

As an admin, I would like far more ways to automate managing the Server/Gallery than the ones currently provided by Alteryx.

Integration with AD would be nice as well, we use SAML, and would like to have the option to import AD groups that would sync automatically in Alteryx - same way Tableau has those groups that are imported directly from AD.

Thanks,

Alex

Hello, I would like improved user management features and/or training

• Display 100 does not seem to work consistently
• Click /navigate from user to user – once I select a user would like to go to next user
• Changes I make with filters refresh every time I go back – which means I have to constantly reset my view in between each user
• Modify user settings in collections – would like to modify user settings instead of delete and re add user

Allow admins to configure an outage window(s) of a specified amount of time (say 5-6pm every sunday) for conducting admin activities. Specifically this outage window would block any scheduled jobs, drive any manual started jobs to queue, and also issue a popup on the gallery to notify users that it's during an outage window. 

Add Admin ability to place the Alteryx Service (Engine) into Maintenance mode allowing current workflows to complete, but all new workflow processing moved into Queue to allow for server configuration and/or maintenance.

Currently, if I want to make a small configuration change (like a memory setting in the Runtime settings) I have to hunt for a quiet window or the lowest level of activity to kill the service (and the running jobs).

It would be helpful to flip a 'switch' and have all new jobs go into 'Queue' allowing for the change and service stop/restart ... then pick right back up with the queue in configured order. (execution time, priority level, etc...)

Hi Alteryx Team,

I understand that the Timeout feature on all Workers is only available for the workflows scheduled on Alteryx Server.

In a heavily used server environment and depending on how workflows are configured, can we have a timeout feature available for non-scheduled workflows (adhoc workflow runs/manually triggered workflow runs) as well on all the Workers on Alteryx Server ?

Thank You,

Nishi Jain

Hello Alteryx team, 

I would like to propose idea that was mentioned on the community but there is no solution either.

It was mentioned at https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Data-Cleansing-tool-suddenly-stopped-w...

The issue is related to Qlik Analytics Samples and error that it is causing with wrong path error for default macros like eg.CountRecords.

Similar to other code/software repository, it would be nice to have the ability to add a message to the reason why a workflow is updated/modified for users of a collection with access can easily review and revert back to older versions quickly.

Fix typo in introduction to user guide

As a part of the installation process or Configuration setting for Alteryx Server , can there be an option added to turn on "Subscription API" enabled for ever

I would like the ability to add Groups to a collection as well as individual users. This would make things a lot easier for situations where large sets of users needed to be added to a collection at once, or removed at once.

It used to be possible to create a robust user profile within the gallery, with many additional user details fields available. However all have been taken away leaving only a name and email address as a user profile.

Please bring back those user details as having additional information about the user always beneficial. If internal to the company, sometimes I need to know what department they are from or what office. And if external to the company, I need to know what organization they are from.

Having no additional user information can cause a lot of confusion, especially if any two users share a name since I don't know if it's the same user with a new email, or a different user completely.

Thanks.

There is a strong need for more APIs to be introduced in Alteryx Server so that our Admin teams can provide automated solutions to our users. My understanding is that a lot of these will be introduced into Alteryx Analytics Hub however, it is also needed in Alteryx Server.

I would propose that the internal APIs for Collections and Scheduler be exposed to the Admin Key/Secrets so that we can use these APIs to move our Users workflows directly to their collection or automatically schedule for them, if needed. It seems that all this would take would be to release the Authorization from internal to the Admin on the API.

APIs I am requesting be released:

• PUT .../gallery/api/collections/{collectionID}/apps/{appID}/
• POST .../gallery/api/scheduler/

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

We have configured the service account for Alteryx services on workers, controllers and Gallery. Kindly go through the below problem statement and current scenario and help to provide solution.

I will appreciate if we can setup a 30 minutes call and discuss on it.

Purpose/Current Design :

1. Our purpose was to on board the account in EPV-AIM/gMSA solution so that password won’t be hard-coded anywhere in the config for service LAN account.
2. Use same LAN service account to run the workflow on workers and write the output at destination paths [ Shared paths, Mailboxes]
3.  

Problem Statement  :

As we have added service LAN account  in multiple AD groups [ global and local ] it has become member of 440+ groups which has resulted in the approx.. token size to 8421.

Active directory has a limit of having approx.. token size to 10000 (10k) for LAN accounts and after that it will fail to authenticate with AD ; which will result in failure of starting Alteryx services.

Please refer below link to know what exactly issue we are facing and looking solution from Product team[Alteryx].

https://www.jijitechnologies.com/blogs/active-directory-token-bloat

We are looking from the Alteryx team :

1. Find a solution and provide some enhancement where we can use multiple (more than one) LAN accounts to run the workflows.
2. In Large scale when we are running workflows of different team’s it is obvious that LAN ID will be member of multiple AD groups and it will reach to Token bloat threshold.
3. We are looking something which can be provided as solution within the same setup to add multiple accounts or any other solution .

We already explored the option you suggested [https://help.alteryx.com/current/server/credentials] but as per our firm’s password policy we cannot save/use/withdraw privilege account passwords.

Because if we go with the suggested option we have to add the particular accounts in Windows server privilege group [ Log on as service, App_Security Logon locally and run batch job].

To meet compliant policy ; Any account which is privilege should be considered as app to app account and it should be integrated with Microsoft’s gMSA or CyberArk’s EPV-AIM solution to be on boarded account in vault. [ No human interaction with account ]

Feel free to reach out to me for any additional clarifications.