Alteryx Server Ideas

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.

Hi,

@patrick_digan pointed out to me today that in my ignorance I thought that the "On Success - Show Results to User" option in Interface Designer did something on Alteryx Gallery, like it does when run locally.  I tried to prove him wrong (I've been manually checking off what outputs I want since day 1! How could it not have been doing anything?!) and failed miserably.  As far as we can tell, this functionality is simply non-existent within Gallery.

Please add this functionality so that we can suppress files (without reverting to hacky tricks like changing the output location so the Gallery can't see the output) with a simple check box.

Link to my shame, where I very openly explained exactly how I thought I had been solving this problem the whole time, and how after testing and review, it looks like I hadn't done anything with this configuration.

All these check boxes... and they don't change anything!

The ability to select a workflow or app within the Gallery web interface and change its name. This would maintain its historical run data, version control revisions, placement in collections, etc. 

Use case: As a workflow or app continues to be developed over time, the name may need a revision to continue reflecting the workflow's function. 

Best regards,

Ryan

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. 

Sometimes when using someone else's Gallery App which has a long list of options to select from, I will hit Run before realizing that I haven't set all of the options.  Then, the App fails (obviously).

Rather than just getting a message that my app run failed on the Gallery, it would be nice to have a link then that automatically re-loads the previous options I had set so I would be able to see which option I didn't fill out properly.

If a job fails it would be perfect if we could set something in the workflow settings so that the job would retry again in X number of minutes for the next Y number of times. We have jobs that connect to external resources and sometimes the network will reset and will cause the connections to all drop. An example would be I want a workflow to try again in 10 minutes for a maximum of 5 times so over the next 50 mins it will retry every 10 mins if it fails

When viewing the schedule viewer with more than the default per page workflow amount of 25 workflows, if you sort it only sorts in the 25 in the current page. I would expect it to first sort all workflows then show the first 25, and actually used the interface with this as my expectation for longer than i'd care to admit, leading to a large amount of confusion when i for some reason couldn't figure out why workflows that i scheduled were not showing up. Obviously this is down to user error and now that i understand it i don't have any issue, but at the same time, why would the sort not apply before population of the list?

Interested to know if i'm the only one who's been annoyed by this.

~ Clive

In some organizations, it may be difficult, if not impossible, for permissions to be applied or exemptions made to enable wide ranges of users the “Logon as batch job” permission needed to run workflows in a Server with the current run-as credential capability.

If possible, could the Alteryx process still run as the server admin or "Run As" account, but enable the workflow to access the various different data sources (windows authentication) using specific credentials entered when running the workflow. So while the whole process runs as Service Account A, the access to databases, file systems, etc. may be done using their own specified credentials.

Some of this can be accomplished today by embedding credentials in database connections, but this isn’t an ideal scenario, and a more holistic solution that covers a wider array (or all supported) data sources would be preferred.

We've noticed on our Server Gallery that users must click 'Run' two separate times when running an app.  The first time they see 'Run', its really taking them to a configuration screen, rather than actually executing the tool.  What if that first 'Run' button was changed to 'Configure'?  We've seen that users hesitate to run apps because they aren't sure what they're getting when they click 'Run' the first time.

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.

Isn't it great that we can toggle between outputs from an app in the Gallery, being able to view and download each one? Yes! However, what if an app produces a lot of outputs...such as 1 per state...or 1 per product type...or 1 per month...etc. What is get is something like this:

Now imagine how long it would take to download all of these...ouch. I recommend Alteryx add a "Download All" button to the page that appears after an app finishes running.

Related Community Post here.

I'm really loving the new data connections for 11.0. We have deployed them in a private gallery for our users and it's great. The only drawback is that the server itself cannot easily be configured to use these same credentials. I would like some way for the service account running our jobs on our server to use the data connections from the gallery. I can assign the credentials to that service account just fine, but it never picks them up since it never open up the Alteryx GUI when it's running jobs. This would allow us to have one spot with all of the credentials. Currently, we're going to have 2 locations with all of our credentials that we'll have to make sure stays in sync: 1 in the gallery for the users, and 1 on the sever box for the server.

Thanks!

In any large IT environment - you will have multiple systems which each use different nomenclature to describe the same thing

This relates to products; currencies; customers; suppliers; trade types; etc.

At present - our users are bridging this gap either by:

a) creating a bunch of excel spreadsheets with "Magic Code Translation Tables" - which is unfortunate because these become unmaintainable very quickly and live on people's desktops (and are not reusable assets) or

b) creating a whole morass of one-way-translation tables to translate from each input source to the normalized format - these are all hand-rolled translation tables; with hand-rolled ways of adding translations etc.

What would be very useful is to allow Alteryx users to specify these kinds of domain concepts on the Alteryx server, with a flexible way of adding synonyms.  For example - our master customer list is kept on the server with a master customer ID (call it MID for Master).   If I'm dealing with a new system that uses a different customer ID (call it NsID for New SystemID), then I can map the NsID to the MID centrally so that anyone who wants to do analytics on this data can just drag in a converter from NsID to MID; and also drag in the master customer list with the MIDs.

This would allow all these Magic Translation Tables to become an enterprise asset rather than isolated data islands, and act as an accelerator for every other team using this data.

Would it be possible to specify whether a worker handles scheduled jobs, ad-hoc jobs or both?  Right now it seems that the workers treat both types of jobs the same, meaning that a slew of ad-hoc jobs initiated from the Gallery could slow down jobs that are scheduled to run on a regular cadence.  It'd be great if those scheduled jobs could have a dedicated worker (or workers) and have any ad-hoc jobs handled by a separate worker (or workers) so that the scheduled jobs (which might be more important) are not held up by one-off jobs.

Can we make the ability for a developer using Alteryx Designer and having a workflow using in-DB tools to pass along their credentials with the workflow when scheduling to run on Alteryx Server.  An individual user may have access to only certain tables in Teradata for example and the ODBC connection on Server may not have access to the same tables so we need to be able to pass along the encrypted credentials.  THanks!

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.