Alteryx Server Ideas

I think it would be a great feature to include the performance tuning logs as an optional output in Alteryx Server. 

 - This would allow me the ability to leave performance logging turned on, so I could see what was happening during an automated scheduled run of the workflow. 

Performance Log :   <Link> (or attachment)

I would also like to see a tool (or tools) as optional outputs such as:

File(s) Generated:  

    <List of Files:    <Link to Files>    <Size of File>

These type of outputs would be greatly beneficial options instead of "This Workflow produced No Output"

Thanks for reading

Randy

Big time user of the Gallery API. In fact, I wrote an R package for it (shameless plug: https://cran.r-project.org/package=alterryx).

It is great that you can queue a job for an application using the Gallery API but it would be great if I could also cancel a running job.

We spent almost a full day on Friday internally, and also about 3 or 4 hours of time for 3 Alteryx Server engineers (thank you all - MattH; ZachH; WayeW) and Ben Burkholder trying to get our gallery server to start.

Error message was "

Failed to construct Gallery daemon process, process exited code <9002>

This was all that was provided in the server log files; the gallery log files; and the Windows Event Viewer.

In the end, it turned out that the issue was very simple - the MongoDB had open locks in place that needed to be deleted; and then the service came up immediately.

Several man-days of our effort; as well as the precious time of the Alteryx Engineers who gave up their Friday afternoon to help could have all been avoided if the error-message on the server failure said "Login failure on server due to open locks - please clean out locks on db.locks collection" with a link to the solution or a lookup code that be researched on the Alteryx support site.     

Please could we go through the server service and eliminate all the exit codes and replace with human-friendly error messages - that way we could allow this kind of issue to be self-diagnosed, and allow the Alteryx Engineers to spend their time building the next generation of Alteryx Server rather than diagnosing a table lock.

cc: @avinashbonu @revathi @Deeksha @BenBu @WayneWooldridge @MattH @SteveA @ZachH 

Hi,

It would be nice if scheduled workflow credentials could be linked to the workflow and not the individual versions of the workflow.

It is problematic for the user that they need to remember to reschedule the workflow, whenever they publish a new version of the workflow.

Best,

Daniel

Today, if I want to save a job onto the Alteryx Gallery, I need full permissions to do so and it is a manual process.  For some organizations, this level of access is deemed excessive, which can make properly leveraging the Alteryx Gallery difficult.  Having the ability to write a "deployment" script that could publish a workflow to the Gallery, and potentially add a new workflow to a Collection would be incredibly helpful in these cases.

I have been looking at the content in Alteryx Public Gallery for some time and I have had some concerns about the safety and usability of the macros/workflows in the gallery. 

I think there should be an option to rate, review and provide feedback on stuff that is out there on the public gallery. This will be helpful in many different way.

1. It will generate trust about the workflow/app. If I see that something is rated higher and has been used and commented by a lot of users I am more inclined to use it
2. It will provide a lot of ideas on how a particular workflow/macro can be used in different ways 
3. Review/Feedback will help the author to make changes as required or suggested by users.
4. The macro's will probably show up in google search based on key words provided by users in their reviews.

......

I had initiated a thread some time ago related to this, there is some useful information in there if someone has same concerns.

 https://community.alteryx.com/t5/Alteryx-Connect-Gallery/Can-Apps-and-Macros-in-Alteryx-public-Galle...

Thanks,

Ashish

Hi there,

Please can we extend the support for MongoDB to include MongoDB Enterprise latest versions, and certify at latest version within 3 months of release (both with the connector components, and the server infra)?

Given the deep dependence that Alteryx server has on MongoDB, being current with the latest version is critical (since many enterprises have a policy of moving to the latest version within 6 months, and shutting off old after 12.

https://docs.mongodb.com/manual/release-notes/3.4/

https://docs.mongodb.com/manual/release-notes/3.2/

Mongo 3.2 has been out since Sept 2015, and my understanding is that Alteryx Server is not yet certified for 3.2 - so it may be worth skipping to 3.4 (released 11 Sept 2017).

Many thanks

Sean

It would be GREAT if we could have an optional notes field in the gallery. When many tools are uploaded to a collection, the titles alone are not descriptive enough for end users. I have to publish a separate "menu" for reports that are available in the gallery. In some cases I have to number them. I wish users could just browse for themselves to find the application that is suitable for their use case. 

The only reference I can find to this idea is here : https://community.alteryx.com/t5/Alteryx-Connect-Gallery/Share-Results-in-a-Collection/m-p/231 .  It references that the feature of "sharing workflow results" was "on the Roadmap" in 2014.  I did some searching through the current Ideas page and cannot find anything.  I also reviewed the release notes since Alteryx 10.5 and cannot see that this was added.

A user approached me today with a problem of "Many people need access to the results of this data, and I want everyone to be able to see all the results".  While you could potentially email these results to a specified user set, that would require maintaining both a collection and an email tool in the job, and could potentially cause notification fatigue if users only care when they go to the Alteryx Gallery.  Similarly, results could be saved to a networked location, but that would require a user to go to two locations in order to find this information.

As such, having a toggle that allows users with permission to view a workflow, to also see the results of any/all users, would be huge. 

I am looking for a way to secure the server In-DB Connections either based on individual user or using an AD group.

Thanks,

Partha.

This is a real flaw in the product (almost a bug), you cannot search for a schedule.  We have about 150 jobs scheduled to run daily.  If you want to amend the schedule you have to page next through all the schedules to find it.  If you search for the workflow name, you get the workflow screen which does not contain a link to the schedules.

Also add a link to the schedules for each job on the workflow page.  I.e. search for job ABC, see that it has 3 different schedules associated with it and be able to edit, or delete any of its schedules.

If you get server up and running and develop  200 workflows and then schedule them, and then want to change the schedule on one of them, it is a total hassle.  What did I call that workflow? you sit there wondering as you look through a huge list of workflows.

It would help a lot to have the concept of projects / folders / some type of logical grouping so I say, What did I call that workflow? while only looking in the public safety, or HR, or Accounting, or whatever subset of workflows.  I mean, we don't have to go all crazy and have collections, districts, and private studios, but at least one layer of categorization would go a long way in making a proliferation of workflows more manageable. 

Thanks!

I think it would be good to arranged the Workflow results into tabbed pages by completion status, e.g. a tab for failures, warnings, success, all.  We run about 200 jobs in the morning and have to page through all the workflow results to find failures.  

Also would be useful to search workflow results by completion status, e.g. find all workflows that have failed.

I know that the documentation shows that you can setup a worker to a specific QoS so that it will only pick up work for a particular workflow or app, but there could be a greater use for it.

For example if the Admin could control what QoS means for each definition.

I.E. Application, vs a workflow that runs over an hour, vs in-database tools. Then it will allow the admins to self guide where the work is going.

Right now there is only three levels

• Normal workflow execution: QOS = 0
• Chained application execution: QOS = 4 (all apps in the chain aside from the last)
• Workflow validation requests: QOS = 6

This was great for Alteryx public, but for private Galleries we need to distribute the work better than FIFO.

I have my  component set to email me if it errors, which is great.  But then when it does bork, I get a 6M email that is impossible to scroll through on a mobile device.  Maybe give an option to only email the error line / tool identifier so you have a better idea of what happened, but don't get war and peace as told by info logging.  

Alteryx Server seems to natively support MicrosoftSQL and Oracle connections on Alteryx Server. It would be helpful to natively support (i.e., a non-ODBC connection) for Cloudera Hadoop as well.

In Gallery, I'd like to see the execution log in the workflow results, i.e. what you get if you run the workflow from Designer.  I'd like to see this whatever the status of the workflow completion.  Would be useful to assess warnings and the performance of components within the workflow.  Also would give me useful stats about records loaded etc.

Please support SAML 2.0 for gallery