Alteryx Server Ideas

We have the Local License Server installed.  Right now, if a Designer user changes roles, or leaves the company, they have to release their license from their client-side machine.  If they don't release it properly, and IT can't get us into their machines, then we have to wait 7 days for that license to roll off the server.  There should be a way for a system admin to forcefully revoke someone's license.

As a Server 2018.4 admin, I need granular control of Server/Gallery defaults including:

1.) Pre-allocate AD users and groups (under Permissions) to specific Studios

2.) Control defaults for scheduling/priority/worker settings on Users

3.) Control defaults for workflow download/no-download at Gallery or Studio level

4.) Control defaults for notifications. Currently I have to check each notification template individually to disable it. Change template tile colors (or whatever) to provide visual queue as to which are enabled or disabled.

Above all, the tiled approach to displaying users, groups, studios simply isn't scalable. A simple data grid type display will allow higher information density allowing settings like: sharing, download ability, scheduling, credential type settings (studio default, artisan specified, runtime entered etc) to be easily reviewed. Basic server governance relies on easy visibility (reporting) of settings to ensure consistency...

Please provide support for sharing a (gallery/Stored) Workflow Credential with a Group.  

Current capability appears only to support Users/Studios.

It would be nice to be able to change the Gallery URL from:

• http://localhost/gallery/
• http://alteryx.mycompany.ca/gallery/

to:

• http://localhost/
• http://alteryx.mycompany.ca/

The reason being to make it easier for end users to find the server/content.

Original forum post here: https://community.alteryx.com/t5/Alteryx-Server-Knowledge-Base/Changing-the-Gallery-URL-on-Alteryx-S...

We have several clients that operate in a Multi-Forest environment due to mergers and acquisitions.  Currently with Alteryx Server the only option we can offer them is to use Built-In authentication.  A lot of corporate and particularly finance institutions prefer a single sign on approach and utilise Windows authentication to do this.

Would it be possible to add support for Multi-Forest organisations into Server to support organisations going through mergers and acquisitions?

This would really benefit us in selling Server in to organisations with complex structures and reduce friction in publishing or preparing workflows.

Currently it takes four clicks and three displays (including the current scheduler display I'm attempting to post as well) just to temporarily disable a job.  It would be so much more convenient if there were a one touch icon on this display that allowed you to do that function.  

I would love the ability to select multiple workflows at once to disable/edit/move workflows to a different studio or disable the schedule all at once (so like a check box to select them)- instead of having to manually select each one and move them and have to go back and forth.

This would also help during update time- as the longest part of the updates is waiting for the service to stop.  If i could select all/multiple schedules to disable at once- then the service would be able to stop when I chose (instead of waiting for scheduled workflows to run)

Hi All,

The limit of data connections in Alteryx Gallery is 100 only.

Is it possible to increase the limit ? 

Best Regards,

Samuel

Currently, even if Alteryx Server is installed in E drive, RuntimeSettings.xml is generated in C¥programdata¥alteryx. Users cannot replace RuntimeSettings.xml to other folders.

It would be nice if a feature that users can specify place to save RuntimeSettings.xml.

Or, it would be nice if this specification  is put in the documentation.

Hello,

This issue relates to an inability to input data from a database where access to only certain columns is permitted. This is due to PII data being present in the data.

I am trying to pull data from one table at a time using the standard ‘Input Data’ tool. 

As I do not have table level access I am explicitly specifying the column names and not using a wildcard. Please see the example below, query highlighted in yellow and the returned error in red. You will see the error message returned from Alteryx suggests a * wildcard has been used despite specifying the exact fields to pull.

Several of the Ford GDIA team and Ford HPC team have reviewed this with me and cannot assist. The HPC team believe it is a bug in Alteryx which has been reported by other users internally, that is ‘Select *’ commands being sent from Alteryx despite specific columns being outlined in the query to the data lake. As we only have access to specific fields within Ranger (due to PII data) the select * fails and returns an error.

I can confirm my ODBC connections are all set correctly as I can pull from certain tables where I have full table level access but not others. Access rights are all in place as I can use the same query on Ambari without issue.

Thank you for any assistance you can provide,

Michael Higgins

Example Query

Select STATION_ID, STATION_DESC from dsc60082_qlscm_tz_db.qlsc_station limit 10

Info: Input Data (3): ODBC Driver version: 03.80

Error: Input Data (3): Error SQLPrepare: [Hortonworks][Hardy] (97) Error occurred while trying to get table schema from server. Error: [Hortonworks][Hardy] (80) Syntax or semantic analysis error thrown in server while executing query. Error message from server: Error while compiling statement: FAILED: HiveAccessControlException Permission denied: user [mhiggi37] does not have [SELECT] privilege on [dsc60082_qlscm_tz_db/qlsc_station/*]

---

Hi Michael,

I believe it would require turning off the queries we currently run to retrieve metadata and retrieving metadata only for the columns selected in the query.

Please submit to our Idea Center for consideration.  Thanks!

--
Angela Ogle | Customer Support Engineer

I'd love the ability to have one schedule for a workflow at specific times. 

Currently you have to create 4 different schedules if you'd like a workflow to run at 10 am, 3 pm, 5:30 pm and 11:30 pm and doing this makes the "Scheduled Workflow" section of the server not only cluttered, but a lot more difficult to manage.  (like spotting accidentally duplicated schedules- which also happens more often than i'd like :)

Thanks!

When installing and configuring Alteryx, the wizard allows the administrator to select the Gallery authentication to be used among:

Built-in

Integrated Windows authentication

Integrated Windows authentication with Kerberos

SAML authentication

The note states:

Once an authentication type has been selected, it should not be changed. Changing it may cause technical problems.

The gallery manual states "Once an authentication type has been selected it should not be changed or Gallery functionality may be compromised." 

https://help.alteryx.com/server/current/admin/Configuration/SystemSettings/Gallery.htm?Highlight=%22...

If you are reading this idea suggestion, I hope it is not too late for you. Why allow the user to change the authentication method once the install is completed? What are the options to solve this?

One option would be to grey-out the "Authentication Type" section in the  "Gallery Authentication" screen, so the user is not able to change authentication methods once after the first configuration is set. This would still allow the user to change SAML settings.

Another option, if somehow there is a reason why a user would want to change authentication types even though it is not supported, what about changing the layout to make it more difficult to change the authentication type.

What are your other suggested changes?

This is not relevant if this idea is implemented https://community.alteryx.com/t5/Alteryx-Server-Ideas/Allow-changing-of-Gallery-Authentication-witho...

However, I would imagine that a UI change would be a lot easier to implement that supporting overhauling the user management in the MongoDB.

Would like to see a Notification hierarchy implemented to Gallery. Currently, the settings that control notifications are at the Gallery-level....where only the admin can control, for example, notifying users if a new workflow was added to a collection they belong too. Could this setting be inherited, but then, for example, a Collection owner can implement their own notification settings that overrides the Gallery default? Using the same example as before, perhaps the Collection owner could disable notifying their Users if a new workflow is loaded to the collection.

Nick

While working with Alteryx Server, I noticed that there is no way for an Premium Artisan to organize the workflow results. With processes that are running hourly, each day, the workflow results gets very cluttered with the same things, and it takes some time to clean up. It would be nice to add a search bar that would filter out workflow results dependent on what you are entering in the textbar. Below is a very lo fi mock up. The spot where I entered "dispositionReport" at the top is the text bar that filters the workflow results below it. The red lines are simulating the removal of said records. Then offer a select all option to then delete all of the workflow results records. 

Hi there,

we are in a dynamic team where people move from 1 project to the other that implies moving series of workflows from private studio to collections prior to sharing. I have not found other ways but to do that 1 by 1 with very limited ways to filter the flows.

Could there be, from the collection, a way to 

 - increase number of possibilities to filters to find the proper flows (or maybe just simply allow folders in the Private studio)

 - be able to multi select the one to add / delete from / to the collection

thanks,

Mongocontroller.log during its MongoDB dump processing records DB admin password in clear text.    This poses a security risk now only to the company but to the MongoDB itself. 

Is there a security patch ready to be pushed out to eliminate this risk?

Insights should work like Apps. We should be able to publish insights then grant permission to other people/studios to access the visualizations. I have many clients / users that can benefit from having access to the Insights i'm gathering from Alteryx. 

As part of the Persistence Expiration processes, within Designer we have the ability to set a retention threshold of the results tab.   i.e. 30 days.

After enabling this - all completed results are purged  but all the "error" results remain.  And this depending on the original count can run into the thousands, such as in my environment.   Id like to see the "Error" results become part of the clean up processing because of the following reasons:

1.  We do not have dedicated admins that have time to manually or by group delete these error result items.

2.  Most if not all - errors are resolved immediately.   if there were to be kept as a reference, a screen shot of the results are normally taken and filed away.

Support says this is intentional for resolution tracking purposes - but to counter - as I stated in item 2 - most errors are immediately looked at and worked on. So there is no reason to keep errored results. Especially when they are time-stamped dates greater than the expiration values selected.

Having the option to disable schedules within the Designer application would be advantageous for we support staff.  Especially when multiple service restarts or server reboots are required.  When we perform migrations or restores or even upgrades or when conducting server maintenance actions.   As we know starting of the Alteryx service immediately queues up workflows to be run based against there schedule times.   When maintenance is being performed we do not want workflows to run, and/or having to wait for completions or have the user to rerun the workflow.   The option to temporarily disable schedules globally with a click of a button is far better then changing the parameters of the schedule or even deleting it.   To go a step further = an internal mongodb administration command to disable/enable schedules would also be helpful at the database level