Alteryx Server Ideas

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. 

I would like to suggest the idea of being able to handle row-level security data sources in a more seamless way using Kerberos passthrough, where Alteryx Gallery will pass the information that User A is running the workflow to the underlying DB and will authenticate as User A. 

We have many workflows that are built to handle different queries of a database that are reliant on knowing who is running the workflow in Gallery. We also have many regional workers, and we want to keep the administration of these connections to the data as simple as possible. 

For more information, check out the Community thread on this subject.

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.

We would like Gallery admins to be able to add any workflow to a collection - not just the workflows they authored.

The purpose is to have one collection where we have a set of workflows that were reviewed and approved for audits.

Only the reviewer could add to this collection

My team utilizes the Gallery API extensively and have found that we have processes that the API has listed as actively running, but cannot be found via the Controller's GUI.  As a gallery artisan, I can call flows via API, but cannot cancel these executions unless I reach out to the administrator group to kill them manually. 

It would be extremely helpful to add an endpoint with the ability to submit a specific job GUID and have the server/controller kill the execution of that flow and clear up the server capacity.  This could then be scheduled on a regular basis as a maintenance  task to keep the server clean.

Thanks

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 Alteryx Developers,

It would be great if you develop a way to connect the Alteryx Designer to AWS Redshift by SSO. When i try to set this type of connection at the Simba ODBC Driver it opens the connection several times with AWS at the browser and that ruin the customer experience.

Best Regards

Danilo Benjamin

I would like to see some functionality in the Alteryx Gallery in which you can select multiple schedule workflows to disable/enable. Currently as an admin if I have many schedules I need to enable/disable I need to go into each schedule manually to disable or enable. This is okay for one or two, but I have about 20-30, it is very time consuming. I would like to see maybe some checkbox functionality next to the workflow to select and then an option to either disable all selected or enable all selected.

While in a workspace or collection, it would be great to be able to select multiple workflows and perform a bulk action on them (e.g. delete). This would help cleaning up unused workflows quicker.

Thank you

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.

As per design Alteryx Server retains all FAILED jobs in the Queue and Results collections even when we set the server to keep run history and results for x days

Purging records from Designer involves manual activity

Proposing the idea of purging these error records through automation script:

Step 1: Stop Alteryx Server

Step 2: Backup Mongo DB

Step 3: Replace big size files: AS_ResultsFiles.Files.bson, AS_Results.bson, AS_ResultsFiles.bson, AS_Queue.bson with Empty .bson files of same name in the backup/AlteryxService

Step 4: restore MongoDB from the backup (with the replaced files

Step 5: restart Alteryx service.

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.

Maintaining multiple workers (five currently, soon, six) with identical setups is challenging when dealing with In-Database (InDb) connections. I must log in to each worker, start Alteryx Designer, go to In-Db settings, and create the connection. This also becomes tedious when trying to update passwords, which occurs every 90 days in my company.

The suggestion is to set up an In-Db connection on one worker and have it propagate to the other workers. 

Propagates to other workers →

This would save time maintaining workers in the gallery and help prevent errors during setup on each worker (e.g., typing in the wrong password).

As an "extra credit" mission, expose In-Db connections through an API that can list, create, update, or delete an In-Db connection.

Hello all,

As of today, if you want to give the Alteryx Gallery user an Excel with your data out of your worfklow, you MUST design an Excel Report with Report tools.

However :
1/ It's highly time consuming to design the report
2/ It leads to many errors, especially on column size : a quick research on Alteryx community gives you several hundred topics
3/ the excel output works really fine

This is frustrating as hell for users !

Best regards,

Simon

Enhance the v3 APi for workflows - /v3/workflows/{workflowid} - to get information for first n versions and/or last n versions of the workflow.

The problem

The current API will return information about all versions of a workflow. If a workflow has several hundred versions, you'll get all version information, much of which is useless and can take a long time to process.

The (potential) solution

Allow the API to take parameters like first n versions and last n versions. This will allow the API to return only the respective version information that would be of interest to the user.

The red box in the image is the enhancement in swagger:

in the current alteryx gallery if we need to disable of enable the schedules workflows we need to manually enable or disable them.

example if we have 100 scheduled workflow. and we want to disable all of them and then enable them later. currently we spend hours to manually disable and enable each of them.

By adding a feature to select the workflows in scheduled to enable of disable the selected one at one which will save hours of time.

In the example given, there are four scheduled jobs running in the server at the moment and one manual job is being triggered by the user and is in a queued state for more than 30 minutes to start running. However, in MongoDB, when a job is triggered, that time is captured as the start time (not considering the queue time). If we consider the start time of As_Queue in our workflow, we ended up with a mess. Since that manual job is queued for 30 minutes and running for only 3.30 hours, it is being killed by our workflow. It should only be killed after 4 hours.  

• How did we determine the total queue time & the execution start time for the running/queued jobs? 
• How do I kill this job automatically after four hours while taking queue time into consideration? 
• Is there any other way to kill the manual jobs after four hours? Please note that scheduled jobs will be killed automatically by the system after four hours.

For our large organization a requirement is that the Server connect to MongoDB cluster requiring keytab kerberos authentication. Can we please upgrade to needed MongoDB version that would support this as well as enable it within Alteryx Server.

(https://docs.mongodb.com/v3.2/tutorial/control-access-to-mongodb-with-kerberos-authentication/)