Alteryx Connect Ideas

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

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

Submission Guidelines
Don't forget to submit your entry for the Excellence Awards by October 30! | Need more information about the program? Check out the blog here

Featured Ideas

Hi Alteryx Team,

 

Can you please add PDF or Word Download Option for Glossary Definition Term in Alteryx Connect. 

 

Thanks

Sri

We are moving our measure specifications that are in a PDF format to the Connect glossary.  We would like to keep the formatting that exists in the PDF when copying the spec.  However, the format doesn't always copy over.  It would be nice to have the 'Format Painter' option similar to what is in MS Word where you can copy the format from one line to another line.

 

We found out that we are able to setup Nexus modes in global config settings.

We can distinguish modes by relationship types and object types. It is nice.

We would like to distinguish Nexus setting by object’s location as well (to show/hide objects in diagram by their location).

For example to show terms from one folder and to hide terms from another.

We ask you to make possibility to setup Nexus to filter out objects by their location.

Hello Alteryx Team,

 

Would you consider creating a metadata loader for SharePoint? A lot of companies that we are working with have a lot of data stored in SharePoint and they would like to catalog their metadata.

 

I am aware that it is possible to use the Files Loader when the SharePoint drive is mapped as a mapped drive in Windows Explorer, but the mapping and subsequent scheduling is very problematic, also because of security policies in large enterprises.

 

Having a SharePoint dedicated loader would be a great benefit.

 

Thank you very much for considering this idea.

 

Regards,

Jan Laznicka

Hello Alteryx Team,

 

We would like to be scheduling the loaders from the administration console, Connections tab. However, when scheduling from there, the loaders are being sent to the Alteryx Gallery under low priority and therefore can easily end up in a queue. As we are scheduling a number of loaders that run for a significant amount of time, it is essential to have the schedules set on precise times and have a certainty that they will not end up in a queue. However, the low priority in the Gallery prevents us from doing that.

 

It would be great if there was a priority switch directly in the Connect's Connections section, where it would be possible to select how prioritized should the loaders be in the Alteryx Gallery. Also a possibility to select a specific worker would be greatly appreciated.

 

Thank you very much for considering this idea.

 

Regards,

Jan Laznicka

Our Data Catalogue in Connect has about 2 millions items (tables, views, columns).

I see next issues:

  1. We collect metadata from about 10+ DBMS. So after each Metadata loader run, Alteryx Connect will start load_alteryx_db script and process whole staging area (DB_*) tables, not only current extracted metadata set from single DBMS. It will lead huge redundancy.
  2. Follows from first issue: One-by-one comparison of loaded metadata will take a lot of time in real environment with 1-2 millions items (ordinary situation in large Bank). And this comparison will be executed several times. It will increase the redundancy in the number of DBMS servers.
  3. All queries in this script containing column or table name as a parameter (e.g. src.TABLE_NAME='${query_table_name}' AND                                 src.COLUMN_NAME='${query_column_name}') will be executed as many times as number of columns in Data Catalogue (millions times). It will work very slow because it executes a lot of queries.

Can you optimize somehow this process?

We use Connect widely among hundreds of users. During a lot of concurrent sessions Connect begin to work slow and unstable.

It is nice to have high workload detection - to warn users about potential problems/instability/slow response (either by email or via some banner at the Home page).   

Hi Alteryx team,

 

Currently, there is a possibility to 'bulk certify' assets from the front-end using the Bulk operations functionality. Would it be possible to add also the 'bulk ownership' assignment feature?

 

We are aware that it is possible to assign owners using the Excel bulk upload, however, for a lot of users it is much more convenient and straightforward to do it directly from the front-end application.

 

This would really simplify the governance of assets in a large source systems like SAP HANAs, where certain users own large amount assets. It would enable data stewards to filter the respective assets using the built-in search functionality and assign the owners for the filtered subsets.

 

JanLaznicka_0-1583143440136.png

 

 

Thank you very much for considering this idea.

 

Regards,

Jan Laznicka

Please add possibility to sort and filter by any field in any asset, which has internal table. For example - column list in table, table list in schema. Or in "Used in " widget. as for now - sort operation is only applicable for name field. it is not convenient for long lists. 

Hello Alteryx team,

 

would it be possible to include a switch between All Projects and Top-Level Projects views when looking on a Tableau site in Alteryx Connect?

 

JanLaznicka_0-1585737355729.png

 

 

For many users, the navigation in Tableau is through the 'Explore' tab and then Top-Level Projects view rather than All Projects. This reveals the real tree structure of the specific Tableau site. In Alteryx Connect, currently, there are always all projects listed when looking at a specific site, so also sub-projects.

 

The hierarchical structure is already brought in, when opening a workbook, the route includes both projects and sub-projects. The idea is that there would be a switch between the 2 views when looking at a site.

 

Thank you very much for considering this idea.

 

Regards,

Jan Laznicka

 

 

Hi Alteryx team,

 

would it be possible to include a project filter in the Tableau loader? Currently, the loader brings in all the projects from the selected sites. However, we have come across a situation when each department in a company has a couple of projects that they do not want to load.

 

The idea is that it would be possible to list the names of the projects that won't be loaded. It could be done in a way that all the projects containing the listed words won't be loaded. This would give us the possibility to, for example, not load the projects containing 'Ad hoc' in their names.

 

We are aware that we might keep these projects 'invisible' using permissions, however, for operational purposes we believe that the project filtering capability would be much better.

 

Thank you very much.

 

Regards,

Jan Laznicka

Hi Alteryx,

 

currently, when running loaders from the Administration Console - Connections pane, there is no information about the status of the load. Would it be possible to include information such as success/fail message, run length, completion time or next scheduled run time?

Connection.png

 

This would much simplify monitoring of the scheduled loads and managing the schedule.

 

Thank you very much.

Regards,

 

Jan

Hi Alteryx,

 

we have noticed that when drilling up/down in the "all mode" in Nexus, it is not possible to see all subsequent relations for assets related to the object, where Nexus was opened.

 

For example, when opening the Nexus view on a business term:

 

JanLaznicka_0-1580215633414.png

 

We are unable to drill into the outgoing relationships for the highlighted Tableau dashboard, the only relation we see is its parent.

 

Would it be possible to show all relations when drilling up/down in the Nexus view?

 

Thank you very much.

 

Jan

Version upgrade of metaloaders gets difficult when customers change or add tools to already complex metaloader workflows.

 

Please better support customer customization by placing macros in the metaloaders at critical points

  • just after data input
  • just before data output

These macros would do nothing except pass data in and out

with the intent that customers build these out as they need to improve the resulting data catalog.

Most customer modifications could fit within limits of what these macros could do.

 

It would be easier to upgrade version when most often it only required replacing entire macros that had been modified.

The improvement would be worth the nominal impact on performance.

Where performance is a problem, un-customized macros could be removed.

.

Hi Alteryx team,

 

In Connect, users are able to open workflows, open reports (like Tableau) or use data source in a workflow using the blue button on an asset page. With the new functionality of cataloguing APIs, would it be possible to implement this button for API endpoints as well, meaning users would be able to trigger the API directly from Connect?

 

2020-03-04 13_25_00-Get posts.png

 

Thank you very much.

Michal

Hi Alteryx team,

 

It would be great if it was possible to load SAP HANA systems using ODBC DSN instead of the normal host name.

 

From our experience, there is often more than 1 node present for SAP HANA systems and when entering the master node into the loader interface, we can't easily switch to a failover node when an unexpected event happens. Sometimes, it is not only the matter of nodes but for example a migration of an instance to cloud might result in a different host name. As a consequence, the loadcode is different and it is not possible to migrate the previous enrichment to the asset pages created under the new loadcode.

 

A solution for this would be the possibility of loading SAP HANA systems using the ODBC DSNs (this is already possible for example for Hive and it would be great if it was available for all applicable systems).

 

Thank you very much for considering this idea.


Regards,

Jan Laznicka

Our users should primary look for certified objects. How ever the advanced search does not have the possibility to search for certified objects.

Hi Alteryx team,

 

Would it be possible to implement custom URL in the HDFS loader when using Knox Gateway? This could be implemented in the same way as in the normal Input Data tool.

 

When connecting to HDFS using the Input Data tool, the URL is automatically generated, however, it is possible to change it. Sometimes this is necessary as the 'sandbox' part of the URL is for some companies not applicable, they have for example their company names instead of it:

 

JanLaznicka_0-1585161087518.png  JanLaznicka_1-1585161125093.png

 

 

However, in the Alteryx Connect HDFS loader, this is not possible as there is no such field in the interface:

 

JanLaznicka_2-1585160401795.png

The 'sandbox' part of the URL is then automatically brought through 2 formula tools:

 

JanLaznicka_3-1585160565194.png  JanLaznicka_4-1585160575989.pngJanLaznicka_5-1585160621052.png

 

This makes it impossible to load the HDFS metadata into Connect using the out-of-the-box Alteryx loader. Implementing a field into the interface like in the standard input data tool would solve this problem.

 

Thank you very much for considering this idea.

 

Regards,

Jan Laznicka

 

 

 

 

 

Certified objects should appear in the top of any search.

 

Today it has no effect on the search if a object is certified. Certified objects should be boosted in the search.

 

In the administration console, Connect configuration, search boost it should be possible to ad weight to certified objects

Hi Alteryx team,

 

apart from the current known issue of format of email notifications (which in some cases shows a code instead of a proper notification), can you work further to improve the visual of the email notifications?

 

Currently, the notifications do not contain any indication (information) that it is coming from Alteryx Connect so very frequently, it is even captured by the spam filters or users have no idea what they are receiving.

 

The expectation would be to include perhaps the Alteryx Connect logo, perhaps name of the instance or some other details, possibly even customizable by the administrator (to some extent only, obviously).

 

Thank you

Michal