Alteryx Server Ideas

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! 

When scheduling in Gallery and creating a recurring daily schedule, if you a start time of 7AM @ any time after 7am you also have to click the date on a day, for the schedule start date, else the you will receive an error message.  Please click the date on automatically, after all if the time is after 7am you can't schedule a job to run at 7am today. 

For large implementations of Alteryx - you'd want to have a live control-center view that allows you to see:

- The state of health of all the server components

- the depth of the queue in the controller

- Jobs failing vs. succeeding.

 

While this can be done by running alteryx jobs, and by going and looking for problems - what we'd want is to have a heads-up control center view which is self-refreshing all the time so that administrators can be notified when there are issues.    And this should not be e-mail notification (it's too easy to miss an e-mail or an SNMP alert)

 

Think about a 40 inch monitor on a wall (like in a traffic control center)  that allows the server management team to see the state of health of the plant at a glance, and dive into issues without having to constantly be looking for them.    this is a critical capability for enterprise install-base and would be a very useful capability to add to the platform.

The Alteryx Server Usage Monitoring & Reporting  reports are very useful. In order to automate the distribution and leverage our Tableau Server we have modified one of the macros within to publish the TDE to the Server and reworked the workbook to point to it. This is a fairly time consuming process to do, so the idea is to introduce a version of the workflow which pushes the datasource, producing a version of the workbook pointing to it.

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

Allow LDAP COnfiguration on Alteryx Server ,Right now its only AD ,but LDAP will be for for SSO ,SAML . 

The WebDAV protocol isn't supported by the Alteryx Scheduler,  due to the security constraints associated with connecting to SharePoint.  This is a server side limitation that should be aligned with the ability of the desktop to preform the WebDAV action.  

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

In the Alteryx Gallery UI, it's possible to set up workflow credentials so that a workflow published to the gallery runs as a specific user.  

 

Unfortunately when that workflow is run from the Alteryx Gallery API, it appears to only ever run as the Alteryx Server Run-As account. 

 

Our developers in working with this figured out that if they called the (undocumented) API that runs the actual Alteryx Gallery directly, they can achieve what they want, but it seems a risky strategy.

 

The idea would be:

-Either unify the APIs so that the Gallery itself uses the same API to run workflows as what you present as the "Gallery API" (the eat your own dogfood way)

-Alter the Gallery API to enable us to run as a different workflow credential

 

Without this, we're forced to permission the run-as account to access anything that uses this method, which in turn then becomes a bit of a security hole (any workflow run will have access to everything that the run-as account uses) 

Currently when running an Alteryx Workflow from the gallery via the API, it doesn't get logged in the user interface in the same way that running it interactively in the gallery GUI does - a shame as it then becomes harder to know the traffic and performance of a workflow run in this way.  

 

 

Organizations using Alteryx Server with an embedded MongoDB can benefit from an option to change the MongoDB User and Admin User passwords.

 

Current deployments of Alteryx Server allow regeneration of the Controller Token, and for many of the same reasons, the ability to change the MongoDB passwords would be beneficial to customers.

 

Many organizations rely on a centralized team for daily administration of the Alteryx Server and MongoDB. With the current functionality, when members of this team change positions, they continue to know the MongoDB authentication information indefinitely. Providing organizations with this capability allows them to make the determination of how/when a change is required to mitigate any risk of misuse.

 

 

Alteryx , Currently only supports AD , but looking for LDAP Support for the server to Mange users and Groups. It would be great if it supports SAML too.

Hi all,

 

i hopped onto Azure tonight to see if I could create an Alteryx server to start learning Alteryx server as a skill.    I was expecting the cost to be somewhere in the range of Microsoft SQL server on Azure, or Microsoft Power BI (a few dollars, but not more than $20 per month for limited usage).    I was fairly shocked by the price on offer (8k - 10k per month), with no option to price this by usage.

 

Could we work together to create options for people to stand up their own small Alteryx server like this for the purposes of learning - right now there is no way to learn Alteryx server unless you are actually an admin of a live server, which makes it impossible for people to learn this at home to build their skills (and impedes Alteryx building a base of skilled users in the market).

 

Happy to work with the team to help make this a reality.

 

cheers

Sean

Hi all, Per this thread, it would be helpful if we could have finer control of scheduled jobs in Alteryx Server: https://community.alteryx.com/t5/Publishing-Gallery/Resource-control-on-scheduled-jobs/m-p/61016/hig...

Specifically:

- Dependancies (one job should run after another in a chain)

- lower priority (some jobs should go down the priority queue to allow for others so that high priority jobs are not blocked by other less important ones)

 

 

Thank you Sean

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. 

Not sure if this has already been suggested but I couldn't find it in the ideas...

 

It would be awesome if in the Gallery some better documentation could be created for the naming of the different private studios, collections, and districts. The naming causes some confusion because it is so different than most other products which causes confusion in our company.

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.

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

Right now we can set the limit of processes a worker can run and each worker will ping the controller when a slot is available so that it can assign a new process. However, this is not efficient and you can truly load balance because you don't know how busy that worker acutally is...

 

We need a way that might be simliar to how we do on DataStage GRID environment where the LSF platform balances that workload across the entire GRID.