Alteryx Server Ideas

As large enterprises continually strengthen security around their system and data assets, we're seeing adoption of products like CyberArk's Enterprise Password Vault (https://www.cyberark.com/products/privileged-account-security-solution/enterprise-password-vault/ )

 

The system is essentially a central repository that secures and automatically rotates passwords for privileged accounts- things like a functional account you would use to run workflows against a certain database or set of systems.

 

It would be great if Alteryx could build both Server (Run As Account) and Designer (for individual database connections) integrations with a tool like that.

I have tables that I need to run ETL jobs on every 5 mins. But, a batch job runs every day for an hour at the same hour. During that time I can't query the source.
With the current scheduler setup; it appears that my only option would be set up multiple schedules. Each running once a day, and a separate schedule for every 5 minute increment of the day with the exception of the one hour my source can't be touched.
Rather than that degree of hassle, doesn't it make more sense to set up a scheduled with and/or/not criteria?
Example:
Run every X minutes on Y days
Except: during %t am - %t am on Z days

I've seen some applications that have a visual scheduler for setting the exception times. That would be pretty cool too.
Bonus points if you can make an admin console for the server which allows the admin to set blackout date/time by table or DSN for all users (override their schedules).

Hello Community:

 

I was looking in the notifications part of the Gallery Admin and saw a glaring ommission: The validation email was something about a code, but nothing about a workflow. "What?!" I interrogo-banged.Where is "Email when workflow is complete?"

 

I would like to move that Gallery include an option (at the workflow level and globally within a studio (perhaps beyond, I'm a newb to Gallery)) that a user can subscribe to an email notification if the workflow completes (or errors out). 

Where I'm currently working, we have some workflows that take, literally, in the twenty-plus hour range. Instead of having to check when it is complete, it would be really nice to get an email from Gallery saying: "Hi guys! [Workflow X] is done! YAY!"

 

I realise there's an email tool in the rendering, but that is... shall we say, complicated. In this case, we're using an R-tool, so all the downstream tools are blind to the metadata. Filtering records down to one so that only one email is sent at the end of the chain is... challenging (remember that 20-hour thing? Try developing on a 20+ hour cycle. It's like 1970 up in here!). And totally counterintuitive. I also feel new users will have issues configuring an email tool; it took me 3 months to get ours to work and it only works from our server. Plus, it's a kludgy workaround. 

 

I feel that this would probably be easy to implement and fits the sensibilities of Gallery. 

 

Vote this up, folks!

 

Cheers,

Cedric

 

 

It would be nice to have an inbuilt function(s) that return an identifier (NTLogin for instance when the gallery is setup with windows auth) of the user running the app on the gallery.

Functions like - USERNAME(), DOMAINNAME() etc., helps.

 

I know that it can be achieved via the "__cloud:UserId" call , which is not officially supported by alteryx. It adds value if it is inbuilt within the product itself.

 

Regards,

Sandeep.

Currently the only filtering available in the Results tab in View Schedules is by Workflow Name. It would be nice to be able to filter by Status, so we can just look for potential problems, like warnings or errors. Currently, I have a job that runs every 5 minutes. That means I have to scroll through hundreds of rows, or about 12 pages using the default 25 rows per page, just to scan for potential problems in the last 24 hours.

 

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

On Success --> Do This

On Fail --> Do that

 

The lack of control and flexibility around the scheduler seems to cause people to bury the logid down in runner macros or unnessarily poll custom log tables to see if a status has changed.

 

I am aware of a couple of clients calling for this functionality. This can be performed via command line but it realy needs to be in the scheduler options.

As an enhancement to the gallery, I'd like to be able to save my application parameters in the gallery in a similar fashion to when I run an app locally.  Users can view the results of an application run, but can't save the parameters that created the run.  I'll go a step further than this and ask for another enhancement.  I'd like to be able to access the questions & responses within the execution of the app to display them during reporting.t

 

Use case:

 

For a list generation application, I need to present to the user the criteria applied during the selection process.

 

Input Address: 49015

Type of Vehicle: Chevy

Minimum Year: 2010

Maximum Year: 2015

 

I've got a working solution that is okay, but not very "Alteryx-easy".  I need to have a second update attached to the interface tool to update the user response.

 

Thanks for your consideration,

 

Mark

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.

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.

It would be great if the admin could change some default settings on the Alteryx Gallery page. For example, where we have the list of apps, show Detail view and sort by App name ascending by default.

 

When a process is running in foreground, the GUI does an excellent job of giving feedback to the user as to which "step" the job is running and how much data is processing through the active tools.  When that same job is scheduled, the amount of information is limited to when the job began execution.

If a tool was able to give checkpoint status out to the user, we could better monitor the progress of scheduled jobs.  The visibility to the job is most important for long running jobs.  We've unfortunately had instances where we have had to cancel jobs and to restart them not knowing how close or how far from finishing they were.

Thanks for your consideration,

Mark