Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!
The Product Idea boards have gotten an update to better integrate them within our Product team's idea cycle! However this update does have a few unique behaviors, if you have any questions about them check out our FAQ.

Alteryx Server Ideas

Share your Server product ideas - we're listening!
Submitting an Idea?

Be sure to review our Idea Submission Guidelines for more information!

Submission Guidelines

Featured Ideas

So you've created your workflow with variable inputs and saved it to the server.  Would love to schedule the workflow to run on a recurring basis with saved input values.  I.e. single workflow with multiple schedules with different saved values.

I think this may be covered here, is there an update?

https://community.alteryx.com/t5/Alteryx-Server-Ideas/Schedule-Gallery-App-with-ability-to-insert-va...

 

 

 

 

Wondering if there are any plans to change the RC4 encryption on alteryx server to something stronger (eg: AES, Blowfish etc)

Would be curious to see if anyone else in financial services has this challenge from a security perspective.

Adrian

Hi,

 We need a way to figure out at which tool alteryx workflow is currently at (i.e., workflow execution progress log) when the workflow is running on the alteryx server scheduler.

This is very useful especially if you have analytical workflows that take long time to run (say 4-6 hours) and at the moment there is NO WAY to figure out at which stage the execution is at from the scheduler.

We can't open the log file on the server as the workflow is IN PROGRESS (we get the standard The process cannot access the file because it is being used by another process) . We can't see the underlying progress log under Scheduler Queue tab either.

It will be useful to capture that information in MongoDB or somewhere so that we can read the In progress log in the real time..

 Thanks,

Sandeep.

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.

 

The full question tree is not visible within the JSON object returned when requesting the 'Questions' in the .yxwz file on the Alteryx Server. There are nested questions that are visible but there is no indication that they are nested, missing label groups, tabs and no indication whether a question should be shown or hidden. This is limiting.

 

A full question tree in the JSON would allow for dynamic interpretation of the 'Questions' in the .yxwz file as structured through the Interface Designer.

 

Regards,

Ben

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.

Hi All,

 

Is there any plan to create an automated way of publishing apps/workflows to the gallery. This has been a common painpoint for me on several different projects when I explain how manual of a process this is.

 

I'd imagine this could easily be solved by adding an additional API call to their library. Ideally, you'd be able to point the gallery to a shared folder with workflows you want to push (git repo functionality would even be better), and have it just move the .xml scripts to the server/mongoDB.

 

Best,

dK

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

For our large organization a requirement is that the Server connect to MongoDB cluster requiring keytab kerberos authentication. Can we please upgrade to needed MongoDB version that would support this as well as enable it within Alteryx Server.

 

(https://docs.mongodb.com/v3.2/tutorial/control-access-to-mongodb-with-kerberos-authentication/)

The idea here is that it would be very beneficial to allow general users to publish .YXZP packages to their server gallery (and/or the pubic gallery!!!).  Currently, this can only be accomplished by a server administrator through the 'Admin' page on the server.  It is also a completely different process than that of publishing Apps, Workflows, Macros etc., which can be done easily from the desktop designer.

 

For instance,  I have developed an Adobe Analytics - Connector Toolkit, which is a .yxzp package, and is located HERE (check it out!).  However, I do not have the ability to upload it to gallery.alteryx.com because I am obviously not an admin on the public gallery.

 

The neat thing about publishing packages to the server is that they appear just like Applications in the gallery.  Descriptions can be added and you can even disable the default 'Run' button and provide a 'Download' or 'Save' button instead.

 

Hopefully, this is a feature that may be available in a future server release!

 

Regards.

 

Taylor Cox

 

P.S. - the Adobe Analytics - Connector Toolkit is also attached below.

 

 

When a user adds a canvas to the gallery - we need to be able to ask for a set of mandatory attributes on every canvas which are tied to meta-data.

 

So - in our world, these would be:

- Which business line does this belong to (pick from a list)

- What business process does this belong to (multi-select from a tree)

- Which part of the organization does this belong to (multi-select from an org tree).

- Who is the canvas owner as a developer; and as a Line-of-business owner (there are two different versions of the word "Owner" to us)

Every canvas that's booked into the gallery needs to have these fields added to the canvas so that we can inform the right person if a canvas fails, understand which part of our business is impacted, look at velocity & density analytics; etc.

 

This then requires a few pieces to be set up on the server up-front:

- Define your meta-data elements (tree; drop-down list; etc).   Admin will need to set this up in the beginning

- Define which meta-data elements are mandatory; and which are optional for every canvas.

- When these meta-data structures change - there needs to be a process that forces the owners to update them again.   For example if we change our org structure, that will invalidate some of the meta-data tagging on assets.

- If a user leaves the firm, owner information needs to be forced to be updated

 

Happy to talk this one through - for any large corporate env, tagging assets like this is super-critical, and this would need to be flexible because every org has a different set of tagging needs.

 

cc: @Deeksha @avinashbonu @revathi 

 

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. 

 

workFlowExample.PNG

When a process is running in foreground, the GUI does an excellent job of giving feedback to the user as to which "step" the job is running and how much data is processing through the active tools.  When that same job is scheduled, the amount of information is limited to when the job began execution.

If a tool was able to give checkpoint status out to the user, we could better monitor the progress of scheduled jobs.  The visibility to the job is most important for long running jobs.  We've unfortunately had instances where we have had to cancel jobs and to restart them not knowing how close or how far from finishing they were.

Thanks for your consideration,

Mark

When we upgrade a server - we often want to do this progressively so that we can move a few canvasses to the new version over time.
However - in order to do this we need to create an entirely new server URL and then users have to deal with the irritation and complexity of storing multiple addresses and knowing which one is where.

 

This would be substantially easier if we could put a load balancer / a consolidator in front of the alteryx server - so the user can go to the same gallery - but under the covers some of their stuff has been upgraded to the new version (on a new server) and some is still on the older server.    

Hi Team,

 

We have new idea which we dint find on Alteryx community, also Alteryx expert confirmed for now this is not possible.

 

Please find the below details:

 

Use Case: Automating Onboarding Process for collection creation.

 

Idea: Currently we are doing this onboarding manually, such as user fills up the form in Sharepoint with all relevant details for Collection Creation.

We as an Alteryx Support team, check the form and create the collection Manually.

We want to create a Workflow, such that it will read the form from SP and create the Collection Automatically without any Manual user intervention.

 

Benefits: If we Automate this then we can save manual user efforts and also avoid any manual mistakes.

 

Note: If this can be possible with any other feature of Alteryx like API, then also we are good.

 

Regards,

Niharika

 

When I added data connection on Alteryx Server, there are many unsorted databases. If it is sorted, it is easy to find.

clipboard_image_0.png

Currently the Gallery does not support Chained Apps or workflows triggered by events or Run Command Tool.

 

Please enable Chained Apps and flow triggering from Events and Command Tools.

 

I started building Apps a lot this last year and I have been using events and Run Command Tool for 3 or 4 years regularly.  In both cases I can't migrate most of them to the Gallery because the Apps chain and many flows trigger other flows in before and after events or Run Command Tool.

 

This should also enable the CReW macros that trigger flows.

 

I manage a server with 200 + Artisans. Some of them tend to abuse the Scheduler by having workflows running every hour or every x hours. This can penalize other users creating big queues thought the day. Currently I monitor the queue and schedule often and then contact these individuals to better accommodate their needs.

 

Having the possibility to disable hourly workflows, or enable to only specific users, would help a lot to deter the abusers.

 

Thanks,

 

Mauricio Estevez

It might be helpful to be able to use an API to call and pass parameters to/from an Alteryx App or Workflow on an Alteryx Server.  Then a user could use a  browser or another application to call an Alteryx app/workflow.

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.