Alteryx Server Ideas

Some of our artisans are unable to publish straight from designer and it would be great if there was an "Upload workflow" button in the private studio just like there is for curators in the admin panel.

Hello,
One of the frustrations we have faced in using Alteryx Gallery is the question "How do we set up many users with their respective collections easily?".

If we take for an example, the scenario where a company has 300 potential users of the gallery, who are all going to login and generate a report based on their department.
In order for them not to be able to generate the reports on other departments, the report generation workflows are put into collections. The current solution to this (atleast on SAML Authentication), is for a user to sign up, and then a Curator to assign them to their given collection. This is fine for small scale solutions, but the purpose of server is allowing for large scale deployment and automation of tasks, and this is far from ideal for a larger company.

If the server is setup on Windows Authentication, the users are able to be categorised within the Windows Active Directory, and then these groups (which may pre-exist) are able to be added to the gallery straight from the AD (see here), however this is not a feature within SAML Authentication.

From my knowledge, SAML Authentication should easily allow for this functionality, and it works very similar to Windows Active Directory. I mentioned this on a call with a Customer Support Engineer, and he explained that this wasn't part of his known roadmap for the Alteryx Gallery. 

I do believe this to be an extension of a current post on the Alteryx forum, however, this details opening the API to allow for this on an API level, however I would also suggest for this to be integrated within Alteryx Gallery, as not all users are experienced with using, or building tools around, the API.
 
Cheers,
TheOC

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.

Hey Alteryx Dev Gurus - 

I've got a situation wherein the user runs something in Gallery, and complains.  I have to log in as that user to view the output files that came back out.  As a super user, I should be able to have all seeing ability!  Thanks!

brian

When opening a canvas - it is possible to open from the gallery, which is important in a team environment.

However - as you work on this canvas - if you hit save, it does not save a new version to the server and increment the original (as would happen on sharepoint) - instead it asks you to create a new file.    

Please can you change this behaviour as follows:

- If I open from the gallery then when I save I'm updating the same Gallery asset and incrementing the version ID by 1.

- The only time I would save in a new file is if I use Save As; and explicitly pick a new file.

 cc: @jalvarezv

There are two key APIs that we use for extracting canvasses for governance & surveillance:

- the Workflows API which lists all canvasses on the server;

-  and the API call which returns a packaged version of the application by AppID

Unfortunately - when we query for all workflows to get the first list - there is no flag to indicate that a subset of these are actually deleted.   The result is that you need to make the second call to find this out which is wasteful.

Please add a "deleted" flag to the Workflows API so that we can identify which applications have been deleted without having to call the specific App ID post.

CC: @jalvarezv

We are taking an incremental feed of all server canvasses in order to look for patterns - however there is no option on the server admin APIs (the Workflow API specifically) that allow you to filter by date.

Please can you add to this API to allow API users to specify an upload/updated date filter and only take items after this date.

cc: @jalvarezv

@SteveA did an article about server logging a few years ago which was very helpful.

https://community.alteryx.com/t5/Engine-Works-Blog/A-deeper-dive-into-Server-logging/ba-p/22389

... and in the training events at Inspire this year there was a session on how to find and interpret server logs.

it would be very useful for large server environments to move away from discrete log files as much as possible, and instead move towards a world where the logs are stored in a data format, and one logging infra is used for all so that an admin team can see these all in one place.

Granted - the initial boot-up of a server, where it needs to connect to the logging DB is going to be a challenge - but after this initial primary boot sequence it would be great if all server logs and logging events were stored in a database of some kind so that we can analyze and collect events.     That way, server admins can have a great UI experience; as well as a great analytical experience without having to regex through multiple different .LOG files.

Hi,

I've got an app in my company's gallery that I've updated 11 times, so in the gallery it says "version 11". I noticed when I click on that area, it brings up a window that shows all 11 of the apps I've uploaded over time, with options to make them the published version & to download. This confused me since each time I update the app I get a warning saying the app will be deleted, which is what I want.

So for this app, I have a 800MB file within it, which would mean that on my gallery server I have 11 versions of an app that each contain at a minimum 800MB of data. I've recently been told by support that this is as it's intended, and if I want to get rid of the all the different versions, I should deleted the app entirely and start anew. This of course would change the URL to the app, requiring the updating of documentation and redistribution of that documentation to over 100 users. And I lose the number of times the app has been run, which doesn't work for me.

My idea is to have another option in the window that shows all the different versions with the options to download, but this option would be to delete previous versions...COMPLETELY, knowing that the owner would no longer have the option to download the version or make it the published version. Having this would allow the owner to maintain the original app with the option of dropping previous versions that are really not wanted anymore.

Currently there are certain locations on server that are paginating content results:

• /gallery/#!apps/studio
• /gallery/admin/#!apps
• /gallery/admin/#!subscriptions
• /gallery/admin/#!users

Each of these pages require users to either know exactly what they want to find by using keyword filtering or know exactly what page they want to go to and use the bottom arrows/page numbers to navigate to that page. Ditching pagination for something more intuitive helps users that may not be as acclimated with the depth of content when there are a lot of results, and also saves users multiple click interactions to find what they want.

There are tons of solutions for this, but infinite scroll is the most user-friendly & least taxing server & client side.

https://infinite-scroll.com/ has code & examples, and jquery seems to be the most widely used implementation.

The gallery shouldn't allow to create data connections with already existing names.

For example, in designer it's difficult to choose which data connection we want to work with if they have the same name, please verify the images in attachment.

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

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. 

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

Thanks,

Matt

Hey there,

Below you can see few of my suggestion to improve Alteryx Server. 

Idea for Alteryx Server monitoring:

• Increase data what could be seen on workflow results.
• Possibly create a report with filter option (to filter by user, gallery, workflow and etc.), which would at least contain data like:
  • Successfully ran workflows, count, percentage.
  • Failure rates, counts and etc.
  • Live data for monitoring purposes.
  • etc.
• Possibility to connect to workflow results data (live data) with other tools like Tableau or Power BI to create dashboards and etc. to monitor and act on the error as soon as possible.
• Give a chance for other users to check on the workflow statuses and etc same like workflow owner.

Give server more functionality with:

• Ability for server automatically retry workflow based on configurations: in example:
  • retry flow in specific time (for example in 30 minutes)
  • number of possible retries
  • based on specific workflow (other) results ability to trigger to run another workflow
  • (Maybe there is a better way) ability to run macros which would for example open MS Excel, and run macro inside it. I have some of the workflows where workflow opens excel, runs macro inside, that macro triggers special Add In which connects to Essbase, it pulls the data, saves excel file, and then alteryx continues working with the file. So if such or similar workflows could be run on Server that would be awesome.
  • This is extremely exiting one: possibility to create environment for self-service users, which it would not be something like gallery (because gallery is more suitable for Alteryx Designers/users).
    • in that one environment admin could grant access for user and tick what specific user could see and run.
    • so for admin it would be one environment, and user would see only what is needed for him/her.
    • in that environment user would also be able to schedule self-service workflows to be received in example by email, or BOX drive or any other way. Scheduled workflow would have to be approved by an admin before it would be actually scheduled. 
  • I have not tried this one myself, but that would also be great if all alteryx server environment could be accessed by mobile devices (of course, some features would be limited).

 Hopefully you will find these suggestions interesting and useful. 

Regards,

Aurimas

Our corporation has multiple private studios set up (depending on various teams within our infrastructure); when we provide a user access to one private studio, they cannot be part of another private studio (to update/add/remove their workflows); they can view/see them within the collections, but cannot action them.

If possible within the Alteryx Server interface, could users be added to multiple/different private studios (and be authorized for all), and have a toggle that would allow them to switch back and forth? This would alleviate a lot of our issues we have with users reporting/being involved with multiple teams (who are requiring access to different private studios).

The dcm admin apis look promising. I would love if they could add put endpoints for sharing/execution and sharing/collaboration for admins. There is already a delete command for those two endpoints

Please provide the ability to bulk add/delete users to a gallery. This would be useful for on-boarding/off-boarding large companies, departments, and external customers. For public-facing galleries, this would provide us the ability to on-board/off-board entire customers of ours. 

For a given DB connection - there's a need to be able to specify the owner for this specific connection.

Reason for this is that the credentials for a given DB are not all managed by the central admin team - so we'd want to say that a given DB connection is owned by a particular person so that this can be updated frequently as passwords change.

For resilience - our particular policy would be to have 2 owners so that if one person resigns or changes roles, it invalidates the primary and reverts to the secondary - and then asks the new Primary to create a backup owner.

Starting with Windows Sever 2016 edition one could use Docker containers technology on windows environments. My idea is to dynamically convert Designer jobs/workflows  to Docker containers at runtime.