community
cancel
Showing results for 
Search instead for 
Did you mean: 

alteryx connect Ideas

Share your Connect product ideas - we're listening!

1 Review

Our submission guidelines & status definitions before getting started

2 Search

The community for a solution or existing idea before posting

3 Vote

By clicking the star in the top left corner of an idea you support

4 Submit

A new idea to suggest a product enhancement or new feature


Suggest an idea
0 Stars

Hello,

 

I'd like to suggest a "view as" on each page (like facebook) or a clear identifier that only certain people can view page. 

 

As an admin, I have to set permission setting for different group. It would be helpful to clearly see the permission setting as sometimes I forgot. 

 

Thank you.

0 Stars

Hi

 

Do we know if there is a function that can rename/replace multiple fields in 1 column through regex. I tried dynamic rename and replace but cant do it on multiple values in one column. Tried through formula but it didn't work.

 

REGEX_Replace([Job Title], 'Administrative Support 6', 'Goose') OR

REGEX_Replace([Job Title], 'Technologies 5', 'Geek')

 

Thanks

DD

0 Stars

If you remove the configuration of the SMTP server while you are in development, (the current solution to spamming users with notifications during the setup period of the data catalog) then put the SMTP server configuration back in when you are finished setup, all the changes that have happened in the interim will not be sent as a bulk send. This a risk when an email server is unavailable for a period of time that notifications for changes/comments/tasks will be missed.

 

Once the ability to switch notifications on and off is implemented, I think it would be worth reviewing how feasible this is.

0 Stars

The email notifications that are received are not easily marked or flagged/prefixed as coming from Alteryx. I expect that this may be on purpose so that data owners can't "hide" from changes/comments on their areas of expertise, but from a time management point of view, it would be good to be able to flag them in some way so that a rule can be run on them in the users inbox, and they can batch up their reviews/answers.

0 Stars

for the past 8 months I have been using alteryx and mostly working with the connect in db components , there are many issues which I am facing and i this this can be improved 

1. there is no such  flexibility of creating a table with the keys defined which is the most important pillar in database, also the options provided are limited , i.e. to create a new table , delete and append, drop table and recreate, 

now, there are many times where in we  need to update the tables based on the keys, which i find missing. Also how the option is defined is create a new table, next time if the job is run it states that the table is already created, for which we need to manually change the option in the next run.

 

2.which switching between in db and alteryx , if the records are more the alteryx lags completely and the job keeps running for hours , how can we achieve the flexibility  of alteryx designer if there is such bottleneck.

 

3.the flexibility that is provided with alteryx designer should also be given to in db components.

4.the parameters defined in the workflow can not be accessed in the in db  formula tools but can be used in the designer formula tools. this reduces the flexibility.

 

please look into the same

0 Stars

This might be a dumb ask, but I run into this alot. I have a workflow that has over 1000 tools and is super long. I would like to be able to to either right click and lock the connection sting so i can let go of the left click , scroll down to the tool, and then click on it to make the connection. Also, it would be nice to have the ability to right click on a tool and click a button "Connect to last used connection" as i sometimes join to the same table multiple times. Lastly, I just thought it would be cool if we can defined tools that are connected to the most so when i right click on another tool, i can open a drop down and select one of the most joined to tools, without even having to click on the original.

Connect provides users an ability to Certify/Decertify asset or mark the asset as "Do Not Use". 

 

Problem Statement: Canvases are published to production gallery and scheduled when there is a need for the output without any single person dependency. but when the canvas output is no longer required, users not always remove the canvases or schedules from production gallery. 

 

Idea: In order to ensure the Server is utilized only for those canvases that are in use, we would like to have a re certification process of assets at regular intervals. eg. Re certification of a canvas required every 6 months from the date of publication to gallery. 

 

With Connect - we can request users to certify or decertify or mark as Do not use but we will not be able to capture or track the re certification of an asset.  

 

Ask: Functionality in Connect to recertify assets at regular intervals or ability to decertify assets in bulk based on the publication date, so that we can request the users to certify again.  

 cc: @ @jalvarezv  @LizaNemchynova @

Currently, the Files Loader in Connect loads all files in a directory regardless of whether they are used in an asset (e.g Alteryx workflow, Tableau dashboard, etc). This becomes a problem when you have folders containing hundreds or even thousands of files that may not actually be linked in anyway to Alteryx or Tableau as those are all populated into Connect.

 

It would be beneficial if the Files loader was more selective about what files to load into the Connect UI by picking up file relationships discovered using the Alteryx and Tableau loaders for example.

 

 

We're working through an implementation of Connect - and it appears that every time Connect scans the Alteryx or Tableau environment, it does a full reload of all canvasses / workbooks.

 

However - we have several thousand tableau dashboards & alteryx canvasses - so this creates a significant delay on running the loaders, and we'd want to run these loaders every few hours so that Connect has up-to-date information (or at most 24 hours out of date).    Running a full export and scan is causing this load to take a very long time to run.

 

Can we change the default behaviour for all the loaders to use a delta-load rather than doing a full scan - i.e. only pull out assets that have changed since the last load?

 

 cc: @nganesha @Kosi

 

 

0 Stars

quality-not-quantity-words-on-board_GJjTpNvd.jpg

 

When Alteryx connect is first installed to a company with a small alteryx designer base, you do not benefit from lineage.

There are not much workflows at hand. So in order to realize Alteryx connect's immediate benefits I'd like to suggest;

 

a company-wide Data Quality Score.

 

  1. Let's score each data element in distributed data stores
  2. And automatically give a simple scale between one and five
    • 1 equals to, “we don’t know”
    • 2 data is entered or updated prior to 1 year, has conflicting data
    • 3 would be the norm and means customer provided this data, as accurate and as up-to-date as they have entered it and ‘agreed’ to share with you.
    • 4 means we cross checked the data with 3rd party sources or the addresses work in Google Maps”.
    • 5 equals to “we had the customer or the representative validated the address in last 3 months”.
  3. The scale will be based on;
    • Missingness
    • Information value (variance is high or not, if there is no variance no info useful thru the column)
    • How many times that column is addressed in other tables
    • Format (structured like a telephone number ###-##-## or semi structured like an address)
    • Is it an ID column
    • Is it a Datetime column, any discrepancies in date time columns etc.
    • Time since last update of data
  4. Once we have some lineage information than we'll weight th data based on how frequently it's needed, how many formulas are requiring the field etc.

 

And as soon as we install connect we'll have a grand vision of our data and even we'll be able to track the status of our whole distributed data assets with a trend line if we are going better or worse... Here is an example;

Cy6-HzAXUAABOLs

 

 

 

 

I published a workflow today that scans a directory for files and then pushes them to a Dynamic Input. I noticed that on Connect there is no relationship there anywhere referencing that we are scraping a directory. 

 

Connect has the db inputs and outputs and the "File Input" that references what the Dynamic input is originally set to go find, but there is nothing referencing the directory other than any notes that I have added to the description. 

 

The reason that I think this may be important. We connect to a folder where FTP files are dumped by a powershell script and we want to go through that folder with Alteryx and pull and upload as needed. However the file that existed in the original input (when we created this workflow) no longer exists. So the visual relationship is broken in Connect as soon as that file is dropped. If perhaps we don't have a tool that references this sort of connection to a directory, having the ability to designate a dynamic connection to the original file might be good instead. We just want to be able for those in the future to reference a location, rather than a file that hasn't existed in a while.

 

Directory Input.png

 

Would Alteryx please consider putting a "notes" page for gallery apps.  This would help the developer of the apps give notes and "how-to's" to the users.  

Our department has a site that manages request access to database, application...etc. The user will have better experience with the tool when they can click on the request access button and it directs them to the form that we use. 

Wouldn't it be great if Alteryx Connect can show badges earned in a user profile like how you have it in the Alteryx community? It would give people more incentive to contribute their knowledge and engage in the tool. This also give visibility to the leaders. 

 

It would be great if there is a way to highlight all the certifications ( ex. Alteryx, Tableau...etc.) that our users earned in their profile. This will help promote data literacy in our community and help users connect to the experts. 

Connect has the ability to visually see 1 level of dependancy (in the Nexus view).

 

For an asset owner - it is very important to be able to see ALL upstream / downstream dependancies to be able to understand impact.   Key here is answering the question "who will be impacted if I change XX"

 

This should include asset; owner; and depth - preferrably in a tree format.

 

CC: @DavidM @Arianna_Fuller

The asset sniffers are currently rudimentary - they are Alteryx Analytical Apps which need to be created by the admin team and then scheduling these.

 

This could be better controlled by a simple UI in the Connect Admin portal rather than requiring users to create their own jobs in Alteryx to do the sniffing. 

 

CC: @DavidM @Arianna_Fuller

Connect offers functionality for users to chat about data & analytical assets.

However - in order to meet regulatory obligations in a regulated Financial Services company - this communication needs to be surveiled by compliance.

 

Please could  you provide an API for this data to be monitored by compliance teams in near-real-time?

 

cc: @dataMack

 @DavidM @Arianna_Fuller

In order to ensure that assets are managed through the process from discovery through correct tagging - a configurable workflow is required to ensure that this process can be managed.

 

  •  Asset Owners
    • When an asset is discovered – first step is to associate an owner.
      • If the database already has an owner, and this is a new table – default to the DB owner.   For Tableau or Alteryx assets you can see the owner from the canvas.    If no owner is obvious - this then goes to an Admin to assign an owner
      • Owner can re-assign
      • Needs to be two owners for every asset
    • Once the owner is confirmed – meta-data needs to be captured
    • Then this needs to be checked against standard taxonomy
    • Then this description is pushed out
    • Admin team need to be able to spot and manage items which are not yet correctly captured or described

CC: @DavidM @Arianna_Fuller

For assets identified in Connect - we are currently not able to identify an asset as being a UAT version of a Prod asset.   Instead, these are listed as 2 completely different assets with no relationship between them.

 

This will be confusing for consuming users since they won't know which to use; and wasteful for the people capturing data about this asset since they will need to capture the info several times.

 

Request: Please create the ability to tag a given Alteryx / Tableau / Database server as "UAT / Dev / Prod", which will automatically tag the asset with this type.   Then allow asset owners to relate the prod and Dev version together as the same thing, but in different states.

 

Thus, when you search you will find 1 asset with several different states rather than 3 assets.

 

CC: @DavidM @Arianna_Fuller

Dean has inspired me to want Voice Activated Alteryx Connect so while I'm having my coffee in the morning I can have Alterexa explain the new data sources that were curated yesterday! Please make this happen!