Alteryx Server Ideas

Hi,

As part of enterprise alteryx server deployments, would it be possible to remove alteryx server controller tokens and use asymmetric certificates (X509) instead?

Adrian

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 Alteryx,

The scale of the column width in Alteryx Gallery is fixed.

Sometime may not show the whole word of that column, it is very inconvenience.

Actually, not only in gallery but also in designer. Like the Manage Data Connections pop-up window. 

Even in 2019.4, the display problem hasn't been improved. 

Can Alteryx improve the UI of gallery and designer asap?

Best Regards,

Samuel To

With Version 2018.3, you removed the Autodetect SMTP button, and with it, have rendered the Email Tool virtually useless for many people, which is a shame because it is a critical tool for some of us to share reports produced in Alteryx.

In requiring an SMTP path, there are a host of authentication issues that need to be addressed, and we can't seem to figure out how to configure the path and From emails properly to allow the tool to work without errors. 

My only solution at this point is to rollback to 2018.2 so I can continue to use the Email tool. 

Please address this so we can use the tool as before, or provide the necessary configuration options to allow for proper authentication with popular email services (Gmail, etc.)

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

All of the default values for the RuntimeSettings.xml can be found in the C:\Program Files\Alteryx\bin\RuntimeData\RuntimeSettings.xml.

These values are overridden by the RuntimeSettings.xml file in the ProgramData folder. Unfortunately, there is no “formal” documentation right now.

The suggestion would be to show users the universe of XML tags and their corresponding accepted value configs, and other data related to the XML entity.

Element Name ServiceProviderEntityID -> child of Authentication -> grandchild of SystemSettings

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.

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

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.

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

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 

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

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. 

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

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

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.

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

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.