Alteryx Server Ideas

I have a lot of workflows that depend on each other. Currently there's LOTS of hassle to effectively schedule a set of workflows to run subsequent.

Typically we run workflows (eg. product hierarchies) that would need to be completed before the next workflow should start (eg. sales data). We currently have some wonky workarounds that are high maintenance, but I would love to see this as a feature in the Gallery.

We have groups asking within our organization for ways to check the status of a running workflow in Gallery. They are wanting to understand which step in the process the workflow has completed for longer-running workflows.

They are looking for an experience similar to when running in Designer where they can see which tools have been completed. At the very least, they would like the log to be reported live and not shown at the end of the run.

Currently, the run feels like a black box where they do not know how close it is to completion or which steps it has made it through.

We have tried to build workarounds like the Email tool, but have been unsuccessful. For example, the Email tool does not send an Email until the workflow completes which defeats the purpose. The closest workaround is writing our own log along the way that can be reported on which is not a clean solution. 

Hello all,

As of today, if you want to give the Alteryx Gallery user an Excel with your data out of your worfklow, you MUST design an Excel Report with Report tools.

However :
1/ It's highly time consuming to design the report
2/ It leads to many errors, especially on column size : a quick research on Alteryx community gives you several hundred topics
3/ the excel output works really fine

This is frustrating as hell for users !

Best regards,

Simon

Enhance the v3 APi for workflows - /v3/workflows/{workflowid} - to get information for first n versions and/or last n versions of the workflow.

The problem

The current API will return information about all versions of a workflow. If a workflow has several hundred versions, you'll get all version information, much of which is useless and can take a long time to process.

The (potential) solution

Allow the API to take parameters like first n versions and last n versions. This will allow the API to return only the respective version information that would be of interest to the user.

The red box in the image is the enhancement in swagger:

In the example given, there are four scheduled jobs running in the server at the moment and one manual job is being triggered by the user and is in a queued state for more than 30 minutes to start running. However, in MongoDB, when a job is triggered, that time is captured as the start time (not considering the queue time). If we consider the start time of As_Queue in our workflow, we ended up with a mess. Since that manual job is queued for 30 minutes and running for only 3.30 hours, it is being killed by our workflow. It should only be killed after 4 hours.  

• How did we determine the total queue time & the execution start time for the running/queued jobs? 
• How do I kill this job automatically after four hours while taking queue time into consideration? 
• Is there any other way to kill the manual jobs after four hours? Please note that scheduled jobs will be killed automatically by the system after four hours.

Hello,

It would be beneficial to have integration between Alteryx and SIEM solutions, and  send all Alteryx logs to the SIEM solution just like any other IT solution. The reason is to comply with the policies of customers, where InfoSec team must have centralized logging for all systems and hence a holistic view of the security posture for the infrastructure.

An Example of this would be seeing logs concerning change of user privileges' and system settings (on the SIEM).

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

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

System Administrator should be able to configure portal pages be being able to choose the columns, columns widths, and sort order.  For Example  in the collections view,  there are columns Inight Count, User Count, Studio count which add no value to my user community.  Yet the name column is not wide enought to show the full names. The collect page is sorted by Create Date which does not add value and once you get above 20 collections  

The recommendation would be to allow System Admins to be able to change these settings.  If the definations are stored a json or xml file or some other file that can be edited, allowing for the customizations.  Admins would edit at their own risk working with in parameters and documentation provided. 

Very Simple Request.

Just like how you can search for a collection, we would like to be able to search for a schedule. One team has over 5 pages of schedules and it would be nice for them to search for one to update vs having to scroll through 5 pages to find it

The Pop up window for Browser tool currently is working in the App environment but not working in the Gallery environment. It is essential when you want to show user the immediate results. there will be too much efforts for user to see the results if I use output/render tool.

Please add a TAGS filter for workflows filter

Hello,

I was recently hired by a fortune 500 company to eliminate use of their Access DB's by replacing them with Alteryx solutions.  My first step is to understand the old DB's so I know what type of workflow to build.  I'd love to have an ERD tool built in Alteryx to drop right after the input data tool.  The closest I've found is the Network Analysis tool, but I don't see that giving me the desired output.  

I would like to see how tables are connected, what manipulations are being done, when a query/view/macro was last used, what outputs being delivered. 

Thanks!

Gina

Hello

Alteryx Server with SSO configuration not able to sign request. Could you remind ? We need this feature to go into production (see attached image). 

best regards,

Nissar

Hello, 

We have been building a solution for a client that involved chaining apps. When we uploaded the workflow to the server, we got the below error: Workflow exceeded maximum runtime of 30 seconds and was cancelled. We were able to rectify this by having the client implement the change here. While I understand the need for the limit, is there any plan to have this fix be more obvious to the average user to implement or avoid needing to reimplement following a server upgrade?

Thanks, 

Hello Alteryx Team,

I've developed a workflow and successfully uploaded it to our Alteryx Gallery. This workflow requires an Excel file as input, which the user should select interactively via a File Browse Tool.

To achieve this, I've used the following configuration:

• An Input Data Tool is connected to a sample Excel file and reads a specific sheet (e.g., "Sheet1" or "Data").
• A File Browse Tool allows the user to select the Excel input file.
• An Action Tool connects the File Browse Tool to the Input Data Tool to dynamically update the Excel file path

Every time a user runs the workflow in the Gallery and selects an Excel file, a pop-up window appears, prompting the user to select the Excel sheet.

I do not want to have the option of selecting "<List of Sheet Names>". I only want to be able to select the Sheet itself.

I would suggest to add an option that allows the creator of the App to deselect the field "<List of Sheet Names>", so that the User on the Server can not see and select this field.

Thank you in advance for your help!

Best regards, Felix

Data Connections and Workflow Credentials are key part of migration process for workflows to Gallery.

They are provisioned for each user upon request.

When a developer leaves the organization, there is no easy way to identify all the Data Connections and Workflow Credentials assigned to that user.

Current options in the Gallery is for the Admin to browse through each Data Connection and Workflow Credential, navigate the Users tab and identify the list users. 

For a large organization with many Data Connections and Workflow Credentials it will hard to manage this since.

1. If the workflows change ownership, the new owner has to be given access to the Data Connections and Workflow Credentials.

2. Remove user access to the Data Connections and Workflow Credentials.

A Gallery page in Admin should include all Assets a user owns/has access to which includes the following. By selecting a user, the list should populate.

1. Workflows
2. Schedules
3. Collections
4. Data Connections
5. Workflow Credentials

We have implemented a solution to capture this information by getting the details from MongoDB. Also an automated process where the list goes to the manager when a developer leaves the organization so that he can manage the assets by identifying a new owner for the assets.

In the new version, we have an easy way to change ownership of a workflow in Gallery. In the same manner other Assets also should be taken care.

Workflows which are scheduled and continuously failing in a row 5 times need to stop/disable the schedule. Sent a mail to the workflow owner stopped schedule due to continuous error.

For Administrating the schedule workflows this feature helps a lot. Many users create workflows and dump into server and schedule it and forgot it if we implement this strategy, it will be helpful to both users and Admin team.