alteryx server Ideas

Share your Server product ideas - we're listening!
Register for the upcoming Live Community Q&A Session - and don't forget to submit your questions for @DeanS regarding the future role of analytics here.

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

Good Day

 

We need a way to read a workflow log file while the workflow is running .. we want to peek inside the log file to see what is happening in the workflow, especially for the  case when the workflow seems to be "hung". This would be an invaluable troubleshooting tool.

 

Currently these worklfow log files are locked by Windows and are inaccessible by all but unapproved 3rd part utilities .. if at all.

 

Often these logs disappear if the workflow needs to be deleted in order to save the environment

 

It is noted that the service logs do not exhibit this behavior, so the request is to

1) allow the running workflow logs to have the same behavior as the service logs

2) provide a work around to allow reading of the running workflow logs

3) ?????

 

Thank you for thinking about this

 

Tom D

  • General

Situation:

As your analytics work grows - you find yourself using the power of Alteryx to create shared macros.    These act as an accelerator for a team because one team member can us a reusable solution created by another team member.   For example - many teams need to get data out of JIRA (or some other system) so you create a connector that everyone can use.

 

That's going well - and now you have 20 teams all publishing canvasses to your server (possibly 100s of canvasses running in production) which make use of your JIRA connector - all good so-far!

 

Problem:

BUT THEN - you discover an issue with the JIRA connector and you need to fix it and publish a new version!

 

It's at this point that you realise that the canvasses on your server which use your JIRA connector are NOT pointing to it, but they have made a copy and included this inside their canvas.   So when you fix the problem with the JIRA connector - no-one gets the fix!

 

This is because every application uploaded to the server is a yxzp file, which zips up a COPY of all the shared macros and uses this in an isolated way.

So - in order to get the new JIRA connector (with the defect repaired) used instead of the old one you now need to:

- Download EVERY canvas on your server

- Unpack them all to expose the sub-macros being used

- Inspect them to see if they are actually an instance of the JIRA Macro

- Make a list of the owner and application IDs

- reach out by e-mail or phone to every one of these folk to ask them to republish their Alteryx workflow with your new version of the JIRA connector.

 

 

Proposal:

Please can we revisit this - we really do need the power of shared macros - and we also need the ability to fix and manage these like a product over time.   This will have an impact on the engine (hence copying @AdamR ) 

 

Desired end-state:

- When you build a canvas using a shared macro - it doesn't store the macro itself, but rather a reference to the version on the server - unless you explicitly decide to break the connection and take a copy.

- When you check this canvas into the server - your application / yxzp does NOT include a copy of the shared macro - instead it has a reference link

- this means that Alteryx Server can now track which canvasses use this shared macro very simply

- When I fix this shared macro - I can then do an in-place update; or if the interface is not the same (i.e. different inputs or outputs) then this has to be a new version and the users will stay pointing to version 1.

 

This is how shared assets are managed in a micro-service world, which is the way that all of our architecture is going - and it seems important that we build this thinking into the Alteryx infrastructure too.

 

 

 

 

 

 

 

@AdamR ; @Treyson ; @SteveA @DerekK ; @BlytheE 

Admin settings for the Alteryx server are currently split between the Admin GUI in the gallery (screenshot 1 below) and a tool called "Alteryx System Settings" (screenshot 2 below).

 

Please could you move all of the system settings into the Admin section of the GUI.   Not only will this allow an admin to administer the settings remotely (rather than having to be logged into the actual server with an interactive login which is needed now) - it will also consolidate them into one place which makes things easier for admins to ensure that all settings are set up correctly.

 

This could be done progressively - a little bit in every release - over the next couple of releases, it does not need to be done in a big reengineering or a massive big-bang release (in fact - progressive release is much more favourable since you learn along the way and big-bang releases are well known to be failure prone).

 

cc: @TanyaS 

 

 

adminsettings.jpgadminsettings2.png

*This is an idea from @riverotoledo-GPA from the Portuguese Community*

 

  • How to bring user’s variables/information that we want to use within the workflow that will be published in the Analytic App in the Gallery (For example, I believe that all “non-sensitive” information from MongoDB related to the Gallery actual session should become variables)

*This is an idea from @cneivam  from the Portuguese Community*

 

- Gallery in all supported languages

*This is an idea from @cneivam from the Portuguese Community*

 

  • Can’t use CReW macros in Server

The mongo db back is a working process but I would like to replace individual workflows and not the entire server state.

  • General

Many people maintain valuable information in Excel files, and many organizations, like ours, also use SharePoint to store and share structured and unstructured information. We see most user-generated and maintained data in Excel files in SharePoint document libraries, and one of the great benefits of Alteryx is the ability to join that Excel data with other data sources.  Unfortunately, the v11.0 Scheduler cannot resolve the UNC-style ( \\server@SSL\DavWWWRoot\site-name\document-library\filename ) addresses, so workflows that access this valuable SharePoint Excel data must be run manually. The SharePoint List Input tool can read the list-style metadata for Document Library files, but does not access the file content.

The Scheduler should be enhanced so that scheduled workflows can read Excel data stored in SharePoint Document Libraries. 

  • General

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

 

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

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.

  • General

When posting an app to the Gallery, if the app has, say, one PCXML output for the user to see, and one Excel file for the user to download, it would be helpful for to be able to specify which shows first to the user.  For example, I have a PCXML that gives the user summary tables, and instructions on how to go to the drop down above and select the second report, click on the Excel icon, and download it.  But if the Excel report shows up first, then there is no ability to give them instructions and many simply won't be savy enough to go find the PCXML in the drop down.

  • General

Please support SAML 2.0 for gallery

When upgrading dot releases to designer desktops, allow for compatibility to the server without the mandate to update the server.
  • General

We are hoping to move to Mongo Enterprise as the backend for our Alteryx server, however we may not be able to given that Alteryx does not currently support Kerberos & Keytab authentication.    

 

Please could you add this to the server so that larger clients with Enterprise Mongo can scale upwards?

 

cc: @avinashbonu @DamianA @BenBu @Deeksha

  • General

I would like to set a retry count when scheduling a job, and also to specify to duration in between retries, e.g. job fails, but then will retry to run 3 times with a 5 minute wait in between each retry.

 

Also would like a radio button next to all workflow results, so when you get a list of failed jobs you can click all the jobs and then hit rerun.  This should be complimented with select all functionality.  This will prevent me from having to go into each job and rerunning, i.e. save me loadsa clicks! 

Along with setting a schedule for an app in the gallery, the user should also be able to set the different interface values for each schedule he/she makes.

 

My main use case is regarding having generic templates for ETL processes, that have multiple different types of runs based on configuration values, but I'm sure there are plenty others.

 

Best,

dK

  • General

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 @WayneW @MattH @SteveA @ZachH 

 

  • General

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.

Although the connectivity to the eMail infrastructure is set up on the controller and worker nodes - there is no ability to set up automated alerting for errors on workflows from the server.

 

We would like to be able to set up the gallery as follows:

- Every job is owned by a user or a distribution list

- If that workflow throws an error or warning (this should be configurable on the server, whether warnings are included), then the author should be e-mailed with a link to the specific workflow and the error log.

 

This can be done in a round-about way, by running an error-reporting alteryx job after the fact - but this kind of alert needs to go out almost immediately given our dependance on Alteryx for specific SLAs.

 

cc: @avinashbonu ; @Deeksha ; @revathi

  • General