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

We had an idea, when you have an yxdb file, you have all the metadata including the field descriptions column from previous formulas or selects, it would be so usefull to have that in connect so that you can easily write a dictionnary from alteryx designer.

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 @

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

 

 

Clicking the ‘Use in Workflow’ button in connect downloads a workflow file with the Table which I can open in Alteryx Designer.

 

When I open in Alteryx it asks for Userid/PW but there is no option for SSO (single sign on):

 

If I leave the username and password blank then the connection fails and I get an error.

 

In the case of SSO the connection string should be:

 

SSO:  odbcSmiley Very Happyriver={HDBODBC};SERVERNODE=saphXXX.europe.company.com:30415;Trusted_connection=yes;

 

instead of this: 

 

UseridPW:  odbcSmiley Very Happyriver={HDBODBC};SERVERNODE=saphXXX.europe.company.com:30415;UID=USERNAME;PWD=__EncPwd1__

 

Please note ALL of our users use SSO so current functionality is useless to us.

 

I have raised this as a bug with support but as usual they ask me to post here.

 

This option should also ask if the connection is In-DB connection also per this post:

https://community.alteryx.com/t5/Alteryx-Connect-Ideas/Have-In-Db-input-as-an-option-when-selecting-...

 

 

I'm using HP Vertica as a data source of Tableau.

 

At this time I'm considering to install metadata management tool in my company.

But there is no name of HP Vertica on available list of Alteryx Connect.

 

I would be grateful if Alteryx could release a metadata loader of HP Vertica.

The share of Vertica increase gradually in Japan.

 

 

 

 

Connect applies a standard set of weightings to different categories of information (people, terms etc.) when returning search results. When combined with likes/dislikes, these determine the order in which results are returned - details below:

 

Alteryx Connect uses the following scoring parameters for the Lucene engine:

  • Likes and Dislikes, using the following formula: (Number of Likes) / (Number of Likes + Number of Dislikes).
  • Certified assets: +1.2
  • Person: +2.4
  • Term: +2.2
  • Report: +2
  • Report sheet: +1.8
  • Alteryx workflow: +1.5
  • Table: +1.4

 

It would be useful to have control over this weighting, e.g. when you have large numbers of Person records being returned before Terms; but advice from Customer Support has been that these are not currently customisable. I'd like to request that this ability be considered for inclusion in a future release of Connect.

 

 

We have some scheduled workflows that utilize the download tool for API calls. When we scrape them with connect there aren't any references to them in the "Relationships" or "Data Connections" areas.

 

Even if this is something that would be difficult for Alteryx to scrape through a workflow, I would love the ability to create entities like this and manually connect them as a data source. Like we have some partners where there 10 to 15 API calls are required to pull the entire data set. It would be great to know which workflows reference those APIs so that if changes are made on their side, we can easily identify which workflows are impacted.

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

 

It would be great if we can have a conversation feed like twitter or yammer in Alteryx Connect Homepage!!! That will up the social platform a notch. #PleaseMakeItHappen! Smiley Very Happy 

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. 

 

@OndrejCsummarizes connect as "a state-of-the-art Data Catalog with a social twist".  

I define it in a broader fashion as data analytics social network, a collective intelligence or #datahive...

I would propose adding Analytics projects and related documents and the relevant relationship data;

  • Project charter,
  • Solution approach document,
  • Data dictionary,
  • Project timeline (a gantt chart etc.)
  • Roles & responsibilities

 into the picture so that any team can track their Data Science project progress there...

 

 Here is a nice process flow view of a DS process

docs.microsoft.com/en-us/azure/machine-learning/team-data-science-process/overview

 

MSTDSPtasks.png

 

 A Microsoft Project view of the Analytics projects at hand...

 

ms-project-templates

 

 

 

 

as per the title, when selecting "Use in workflow" a user should have the option to connect with the in-db tools when applicable rather than being stuck on a green input tool with an odbc connection. Ditto when searching from the omnibox in designer. 

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

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

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. 

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

It would be great if we can have a conversation feed like twitter or yammer in Alteryx Connect Homepage!!! That will up the social platform a notch. #PleaseMakeItHappen! Smiley Very Happy 

Would be good to create an Alteryx Connect plugin for Tableau so that you can access Connect from Tableau?  Would improve user experience if the user can access the information catalog without leaving their BI tool.  So for example, have an Alteryx Connect sidebar in Tableau to allow you to search for a table or file then click and add as a data source and immediately start data discovery/analysis.
 
 

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. 

In a large environment- especially an analytical environment - copies of data will often appear in multiple places.    an example of this is where a copy of a shared dimension or a shared piece of reference data is copied in multiple different data marts.

 

In order to manage this - we need to be able to mark these as copies of each other so that we can point folk to the golden-source; and so that we don't need to document this asset multiple different times.

 

Example:

- Client List appears in the data lake; on the Sales data mart; on the Finance data mart; etc

- We would want to group all 3 of these together; and mark the Data Lake version as the master; and all the others as copies.

 

User experience:

  • When I navigate to any Sales assets - it tells me that the Client List is a data asset which is used
  • When i click on this - it tells me that the sales version is a copy - and directs me to the one on the data lake

NOTE: There are circumstances where a copy may be deliberately filtered or incomplete (for example - regional subsets of clients) - in this case the relationship needs to be "Partial Copy" not "Copy"

 

 

CC: @DavidM @Arianna_Fuller