community
cancel
Showing results for 
Search instead for 
Did you mean: 

alteryx server Ideas

Share your Server product ideas - we're listening!

1 Review

Our submission guidelines & status definitions before getting started

2 Search

The community for a solution or existing idea before posting

3 Vote

By clicking the like in the top left corner of an idea you support

4 Submit

A new idea to suggest a product enhancement or new feature


Suggest an idea

Wanted to grab some attention here regarding the Alteryx gallery search engine (which also bleeds over into searching for schedules and jobs when troubleshooting). 

 

Since a picture is worth a thousand words, I'm pasting two pictures (one attachment) of searching our gallery for the word "Contour" and the word "Signal". Both of these words are in the title of a single workflow - when I search for the word "Contour", the workflow pops up. When I use the first word in the workflow, which is "Signal", it doesn't pop up. 

 

I appreciate all that Alteryx does, but I wouldn't think this should be a difficult issue to fix, and I would imagine there are other frustrations with the functionality here. 

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..)

 

 

 

 

Following up on this post (https://community.alteryx.com/t5/Alteryx-Server-Discussions/Server-logs-do-not-include-download-tool... ), inclusion of the activity of the download tool in the Server logs would be very useful in monitoring this high-risk capability within an enterprise tech environment.

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

 

Alteryx Designer is an amazing data tool but it’s partner, "the Scheduler" needs some much needed upgrades. The Scheduler interface that pops up from Alteryx Designer does need a complete make over. I’m not going to address this but rather focus on the functionality that if delivered makes the Scheduler much more useful. 

 

Today I’m reading our Mongo db scheduler data using an Alteryx workflow and Tableau to show what’s happening on the Scheduler. This dashboard is what we refer to frequently to see the health of our companies data pipeline.  I’ll share both files soon. 

 

Here are the top 5 features for the Scheduler.

 

  1. Workflow priority ranking. When two or more workflows are scheduled to run at the same time, ‘priority’ sets the order of execution. Priority is set at the time of scheduling the workflow. Values range from 1 to 100. If a priority is not set the default is 50. The ‘priority’ field can be read from Mongo db. 

 

Why: At midnight we set off several workflows. We want to centrally manage which runs first based on a common ‘priority’ field. 

 

  1. Restrict which controller and workers a specific workflow can run on. Default is to run on all servers. At the time of scheduling a workflow can designated to restrict which server to execute on. This creates a field called ‘restrict’ which server it cannot execute on. 

 

Why: Some workflows only run on the main controller due to file system references. Also a worker can be tuned for CPU or Disk I/O and workflows that can benefit from this tuning.  Selecting a disk I/O intensive workflow to run on a server tuned for Disk I/O would speed up our workflows. 

 

  1. Set sequence of successfully completed workflows. 

FYI: We used the Runner tool for a short time to resolve this issue but learned quickly that the Runner tool is like a bull in a china shop and brought our server down. The runner tool as it is today is not an option for production work.

 

Why: This would allow you to run several workflows one after another. For example the first would read from a data source, the second would do calculations on the data and the third workflow would publish the data. All workflows are given a ‘workflow-number’ which can be seen in the scheduler list and read from Mongo db. 

 

  1. If a workflow fails you can set the number of attempts to run successfully. Report attempts greater than 1 in a new field called ‘attempts’ that can be read from the Mongo db. 

 

Why: Some workflows fail and if attempted to run again may work. This includes issues with locked files and workflows dependent on processes outside of Alteryx. 

 

  1. If a workflow runs more than X minutes the scheduler kills the workflow and reports a workflow error with a unique code called ‘execution-limit’.  This code can be read in the mongo db. The defaut is 90 minutes and can be set to any number of minutes. Each workflow can have it’s own limit. 

 

Why: Some workflows start to hog resources and need to be killed. If a new workflow is added this is a good way to protect the overall scheduled workflows. 

Please support GZIP files in input tool in Server. This is related to https://community.alteryx.com/t5/Alteryx-Product-Ideas/Support-for-GZIP-gz-compressed-files-in-input..., but logged in a separate Idea because the staff indicated in the thread that they are planning support for GZIP in Designer only in 2018.2. We need it in Server as well.

We currently have the ability to store connections on the server which protects the credentials - however this capability does not exist for APIs for Sharepoint sites etc.

 

Please could you extend this to cover authentication for ALL connectors?

 

Many thanks

Sean

 

cc: @revathi

On the workflow results window, I'd like to see a column for "Start Time". If I have a workflow that is running, I'd like to know what time it started running so I have an idea on when it might finish.

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.

It would be useful if the Admin of a Private Gallery (in house server) could delete studios and/or members.  Also, it's confusing that a member who's added also gets a Studio automatically set up.  Members (for my purposes) are only supposed to be able to run apps in collections that I grant them access to.  They should not get their own studio.  Even if they can't use the studio (or even know that they have a studio), it's not very efficient to have all these studios show up on the subscriptions screen.

I'm really enjoying the new Save As functionality to push to the gallery, but had a request that would make it even more useful for me. 

 

I saw that you can open workflows directly from the Gallery and edit them with version control, but it would be nice if it was possible to do a Save As on a local workflow and point it at an existing copy on the server.  I need to maintain a local copy of my workflow for dev/prod separation, but currently my way to push to prod is to do a Save As to my Private Gallery, remove the existing copy from the company gallery, and then share my newly created workflow into the company gallery.  This causes some headaches like no version control, switching out icons everytime, and overall just a messy way to push to prod.  

 

It would be helpful if there was a way to overwrite an existing workflow in the gallery rather than editing it directly.  

While working in the Gallery, I think the file browse tool should allow the user to import a file without selecting a sheet or <list of sheet names> as is does locally.  

 

For example, I have created an app in which the user is able to import a file with multiple sheets, and all sheets are brought into separate input data tools with a single file browse tool (shown below).
image.png

 

Since the user does not select a sheet name, the file browse tool only brings in "SelectedFileName.xlsx|". The action tool is then set to replace a specific string "SampleFileName.xlsx|". This allows the input data tools to take this new file name, and add each respective sheet name to the end.

 

However, when working in the Gallery, the user is required to select a sheet name or list of sheet names, meaning a file browse tool is required for each sheet that you would like to import (shown below). This is a huge inconvenience for the application user, as they have to select the same file numerous times to import every sheet. 

image.png

 

 

Please let me know if you would like me to provide any more information, I would be happy to do so.

 

Thanks,

Matt

Not sure if this has already been suggested but I couldn't find it in the ideas...

 

It would be awesome if in the Gallery some better documentation could be created for the naming of the different private studios, collections, and districts. The naming causes some confusion because it is so different than most other products which causes confusion in our company.

The more I'm digging into the Private Gallery (on our own Server, not gallery.alteryx.com), the more I'm feeling that the UI and functionality is very non-user-friendly.  

 

I would like to do something that I think is very basic (I am the Admin of the Gallery):

1.  Create Apps and put them in various Collections.

2.  Grant people access to certain Collections.

3.  Have those people, when they log in, only see the Collections to which they have access to (that I granted them).  And then run the apps in those collections.  Nothing      more, regardless of who they are.

4.  Given all three of the above, but I do not want to see them listed as an Artisan, nor do I want to see them have their own studio

 

Currenlty, no matter what I do, they have Studios, and some are listed as Artisans (and as mentioned in a prior post, you can't delete their Studios).  I've tried using Windows Authentication, but I get errors so that's not an option.  It would be nice if the above were options regardless of the Authentication type.

Allow the artisan to turn off the ability of a member to download app results.  Some of the information is highly confidential, and we don't want them to be able to easily print out a list of this information and have that list "floating around".  Or take sensitive client data with them to another job if they leave us and use that to profit their new employer.

0 Likes

Hello,

Now it is possible to share a collection which a user who is not granted to access Alteryx server.

 

We use AD to grant users access to Alteryx Gallery. However, when a user is not in this group, it is still possible to choose him as a person to share. 

 

In my opinion, such user should be indicated as someone who won't be able to use a shared collection, or he should be presented at all.

 

Best,

Piotr

0 Likes

It would be nice to be able to toggle between the Admin screens and the Gallery screens.  

Top Liked Authors