Alteryx Server Ideas

currently, there isn't any way to fully delete (safely) a user from the gallery. So if there is a previous client or previous employee in gallery, we cannot clean up the gallery settings - only "disable". It would be great to have a "trash can" symbol next to the users where we can remove them from the server and keep all of the users clean. 

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.

Very Simple Request.

Just like how you can search for a collection, we would like to be able to search for a schedule. One team has over 5 pages of schedules and it would be nice for them to search for one to update vs having to scroll through 5 pages to find it

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.

Our company prefers to setup active directory groups to manager our users and resources separately for better tracking of what a group has access to.  We setup global group roles with users as members and local groups with privileges to a resource and the role as a member. We would like to be able to use nested global groups in the User>groups and have it still setup the users once a nested group is setup. Attached his the priv group an role.  We were not able to login with the priv group, but could login once the role group was added.

Thanks

Hello,

We would like to have the option to configure the timeout of the manual running jobs, as already exists for the schedule jobs.

Regards

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.

The Pop up window for Browser tool currently is working in the App environment but not working in the Gallery environment. It is essential when you want to show user the immediate results. there will be too much efforts for user to see the results if I use output/render tool.

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

Please add a TAGS filter for workflows filter

Hello,

I was recently hired by a fortune 500 company to eliminate use of their Access DB's by replacing them with Alteryx solutions.  My first step is to understand the old DB's so I know what type of workflow to build.  I'd love to have an ERD tool built in Alteryx to drop right after the input data tool.  The closest I've found is the Network Analysis tool, but I don't see that giving me the desired output.  

I would like to see how tables are connected, what manipulations are being done, when a query/view/macro was last used, what outputs being delivered. 

Thanks!

Gina

Good Day.

We would like a built-in process that would search or, and resolve, workflows that are stuck in the "initializing" state. These seem to happen for various reasons but communication problems between the controller and workers .. usually a socket timeout.. which appears  to be most problematic. It seems  that these type of errors should be expected in all but the most stable environments,

Currently, the only tool that we have to solve this problem is to restart the Alteryx Service on the controller and while this works there tendency to cause some collateral damage in workflows ...erroring or restarting from their beginning.

There may be a way to solve this without restarting the service by editing Mongo using a tool like Robo 3T but that is unproven and has its own risk.

After dealing with this issue and struggling for quiet some time we think that the best option is to implement a "clean up" DB process that will run every 5 min or so, capture a list of workflows in the "initializing" state , then compare that list to one in the next 5 min cycle and fix any workflows that appear in both lists. We think that returning  any stuck workflows to the queued state would be the best Fix  option.

We just don't want to continue to use Restart the Service process to solve this issue and accept the collateral damage.

Thank you for your consideration

Tom D  

Hello

Alteryx Server with SSO configuration not able to sign request. Could you remind ? We need this feature to go into production (see attached image). 

best regards,

Nissar

Hi, 

I think it would be extremely useful to be able to trigger an Alteryx workflow using Power Automate. 

The main benefit I see at the moment is automatically triggering an Alteryx workflow when the input data has been refreshed.

This would also enable a Power App to be added directly to Power Bi which can simply be clicked to re-run an Alteryx workflow then refresh the Power Bi dataset. 

It would be helpful if there was a way to setup notifications so that it would email Admin whenever a workflow runs longer than a preset amount of time.

Admin would set time threshold for triggering notification i.e. > 15min and Alteryx Server would email Admin whenever a workflow runs longer than that so that they could monitor this specific workflow and take corrective action,

Our Organization uses a Password Manager to automate the update of service account credentials used in Windows Services. 

Would like to request the ability to leverage that functionality with the Run As user inside of Alteryx Server Settings used with Workflows. 

This would increase application security, while ensuring the process is automated, thereby limiting issues from human interaction.

Examples of these types of application are ERPM(Enterprise Random Password Manager), Thycotic Secret Server, and I am sure there are others. 

Hello, 

We have been building a solution for a client that involved chaining apps. When we uploaded the workflow to the server, we got the below error: Workflow exceeded maximum runtime of 30 seconds and was cancelled. We were able to rectify this by having the client implement the change here. While I understand the need for the limit, is there any plan to have this fix be more obvious to the average user to implement or avoid needing to reimplement following a server upgrade?

Thanks, 

This idea has been touted in different flavours over the years (but not implemented), but I'd like to push it a little further:

1. Create the ability to collaboratively edit an Alteryx workflow - e.g. like you can edit Microsoft documents collaboratively. If the front-end is primarily an XML interface, this should in theory be possible?

2. Version control (not version tracking) - i.e. automatically state the differences in scripts between versions and allow for checking in and checking out of code

3. Power BI & Tableau Prep have the ability to see exactly what changes were made and to reverse steps to get back to a specific stage of development: it would be great to have a panel that tracks all the edits you've made since you started editing the workflow

In simple terms, a modern, interactive way for multiple developers to work together, but also to encourage the use of Server to "check in" your application and to avoid developers saving the same file over & over again locally.