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

I've seen various solutions/workarounds but this seems to be a table-stakes ask?  When scheduling a workflow I should be able to specify which parameter values to run with.  Just two of many use case examples - 

Use case #1 - a single analytic app could be scheduled multiple times, each schedule specifying a different line of business

Use case #2 - credentials, allow the user to schedule a workflow with their saved credentials.  When their credentials change all they would have to do is update the schedule parameters

 

(If you know a better way I'm all ears, not the API thought that isn't a bad way to do it, just not super Easy)

6-25-2020 5-39-35 PM.png

I would like to see the enhancement of being able to schedule a start and stop time for specific jobs that need to run multiple times per day, so they don't run during the nightly backup periods of the Alteryx server. This can cause the daily backups of the Alteryx Gallery to fail. Currently SQL Server Management Studio/SQL Server has the function to able to schedule start and stop times for specific job. Currently Scheduler page on Alteryx Gallery/Server lacks this feature.

 

SQL Server Management Studio

mackedet_0-1590532280855.png

Schedules on Alteryx Gallery/Server

mackedet_1-1590532639645.png

 

 

For scheduled jobs, there should be an option to include performance profiling in output logs globally.  Basically we are looking at how we can understand which custom macros are in use, and in which workflows, and one way to do this would be to get the output logs into another tool (i.e., splunk), and then set up some queries there.  It would work, but I would have to tell N developers to go set performance profiling on, re-upload their workflows, ect.  

 

But why not have a switch on server / gallery that just turns this feature on globally for every scheduled workflow?  

 

Thank you for attending my TED talk on why performance profiling should have an option to be set globally. 

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

 

  • Being able to control the workload in Alteryx Server (for example, making sure that a workflow can run only when another set of workflows finish running)

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

 

 

 

 

For whatever reason a schedule is disabled, whether a Studio expires, or for any other legitimate reason, a notification email should be sent to the Admin and the one that created the schedule in advance of it being disabled. When a scheduled workflow is not executed, it leaves us scrambling for answers. A sudden disablement of the schedule is disappointing to discover after all other stones have been turned. Notify us in advance of a schedule being disabled. 

  • Scheduler

Currently when scheduling workflows, there is an option to schedule based on the calendar day but not on business day. For example, if I want to run a workflow on Business Day 1 of every month, it is not necessarily the first day of every Month. For the month of June 2019, Business Day 1 is June 3rd, since the 1st and 2nd fall on the weekend. Many departments run their processes on Business Days rather than Calendar days. Also factoring Holidays into consideration would be a plus since January 1st for example is a Holiday, Business Day 1 would fall on the 2nd.

  • Scheduler

Hi

 

It will be great to make visibility of workflow execution results to other users in same subscription.

 

As of now, only schedules are visible to all users in a subscription, but not the workflow execution results executed by a user to other users in same subscription. 

 

This will avoid duplicate execution of same workflow by multiple user in a team as it will provide option to cross check the execution results by other users, if executed already, before execution of same workflow.

 

Regards

Haribabu Muppaneni

I really want to see this feature in new versions. Its frustrating the lack of options we have with scheduling workflows on the server. I need to have my process run every 10 mins but only on certain days and in certain time windows. Creating a schedule for this is impossible unless I manually create hundreds of schedules. 

 

I have a few workflows that I have hosted on out Gallery Server and I have them scheduled.

 

Ex: Process A is scheduled to run every 10 mins Mon – Sunday.

Problem: I only need Process A to run Every 10 Mins on Mon – Sat from 2 AM to 6 PM

Currently there is not a scheduling configurations that allow this type of schedule. How can I get my workflow to run every 10 mins but only during certain times and on certain dates?

  • Scheduler

Hi Alteryx, 

 

Now, under the Job Tab, it is only show the status of running job.

 

Suggest to add one new page for showing the run history of each workflow/job.

 

1. Workflow name

2. Priority 

3. Assigned Worker

4. Start time

5. End time

6. Duration

7. State

8. Job Type (schedule or manual tracker)

9. Owner

10. Message ( e.g. error log)

 

Best regards,

Samuel

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

Use case: I need to schedule a workflow to run every 2 hours each day, with the first run at 7am and the last run at 7pm

Current solution: I need to create seven daily schedules for each hour that i need the workflow to run

Idea: Add an intraday "Start Time" and "Stop Time", or "Between" to the "Minutes / Hours" schedule type, so i can create one schedule that meets the use case requirements

Example schedule with new parameters that meets use case requirements:

Start Time = 7:00 AM

Stop Time = 7:00 PM

Repeat Every = 2 hours

 

Start Time could default to 12:00 AM

Stop Time could default to 11:59 PM

 

screenshot.png

  • Scheduler

Currently, this is completely manual with whoever is assuming the schedule creating it under their profile and then the old schedule being deleted.

 

This can happen often in organization where a user leaves the company or assumes a new role requiring some else to maintain those schedules. It would be convenient if there was an option to reassign the owner of a schedule to simply this process.

In order for us to manage the large number of canvasses on our server - we need to add the ability for Admin teams to require additional attributes on every canvas:

For us, these mandatory attributes would be:

- Which team do you belong to (dropdown)

- What business process does this serve (dropdown - multiselect)

- Primary & secondary canvas owner (validated kerberos)

 

For the ones that have dropdown lists - we can provide the master data into a drop location or into a manually configured list on the server.

With Version 2018.3, you removed the Autodetect SMTP button, and with it, have rendered the Email Tool virtually useless for many people, which is a shame because it is a critical tool for some of us to share reports produced in Alteryx.

 

In requiring an SMTP path, there are a host of authentication issues that need to be addressed, and we can't seem to figure out how to configure the path and From emails properly to allow the tool to work without errors. 

 

My only solution at this point is to rollback to 2018.2 so I can continue to use the Email tool. 

 

Please address this so we can use the tool as before, or provide the necessary configuration options to allow for proper authentication with popular email services (Gmail, etc.)

 

Hi,

 

We have more clients that would like to prioritize their scheduled jobs based on run time and importance. 

 

It could be a simple priority number, that decides which job that need to run next. Further it could be nice to be able to allocate certain workers to certain jobs. 

 

I am looking forward to your feedback.

 

Daniel

Currently if there is a password change, I have to download my workflows, update the password in the Tableau connector, and reupload the files. 

 

This would enable groups with a single sign on to ensure scheduled workflows are not interrupted. 

Hey Alteryx,

 

I'm liking the new ability to change the permission for users to schedule, prioritize and assign their work.

 

I would also like the Permissions to not show if I've turned it off. For most users this feature will not be available and showing a feature they won't be able to use will cause more problems then answers.

 

Just like in the notification tab, I would like the features that are off not show up in the end users profile tab

 

Permision Requests.png

 

It would also be nice if we could assign this to a workflow and not just a person. A more likely scenario is that an App that needs a user input shouldn't be scheduled since it won't work. 

To have the ability to turn off the scheduling for just that workflow is more likely then to turn off that feature for an entire person.

 

Thank you

The AlteryxService addtoqueue command is great, but it leaves me wanting more.  My simple use case is to run WorkflowB via the addtoqueue command in an after run event from WorkflowA, which is run daily.  The result is that i end up with a cluttered scheduler with many instances of WorkflowB that i need to manually clean up, since addtoqueue creates a new record in AS_Applications each time it runs

It would be useful if there was an AlteryxService command for each of the subroutines already built in to the scheduler front end app: schedule workflow, update workflow, add workflow, remove workflow, edit schedule, etc

MongoDB objects could be identified by oid which the user can get from querying the AlteryxService database

I don't want to rebuild what you've already built, just need a little more control over it 🙂

image.png

 

 

 

 

  • Scheduler

I wish Alteryx would allow more control over user access to scheduling workflows. Currently there is only a radio button that globally allows users to access the scheduler. I wish we had another layer where we could limit access by Permissions. For example, we would like all Artisans and Curators to have access to the scheduler, but not viewers.