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

Alteryx Designer Ideas

Share your Designer 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

With the amount of users that use the publish to tableau server macros to automate workflows into Tableau, I think its about time we had a native tool that publishes to Tableau instead of the rather painful exercise of figuring out which version of the macro we are using and what version of Tableau Server we are publishing to. The current process is not efficient and frustrating when the server changes on both the Tableau and Alteryx side.

Single point of maintenance for Salesforce Input tool connection to Salesforce

 

This prevents user maintenance every time their password (and token) changes which requires them to update every Tool with new credentials

 

Also logged as issue under Alteryx, Inc Case # 00252975: Connection to Salesforce Issue

  • Category Connectors

Hi,

A lot of companies now are deploying on both AWS and Microsoft Azure.

Alteryx supports AWS S3 object storage out of the box, it would be important to support Microsoft Azure blob as part of the native Alteryx product as well. 

Cheers,

Adrian

At our organization we are required to change our passwords every few months forcing a change to my Tableau Server password.  How does this relate to Alteryx?  Well, every 90 days I have to change my password in the "Publish to Tableau Server Tool" for all of my workflows.  This is quite a cumbersome process that could be eliminated with AD.

 

If you dislike manually changing your for each workflow that uses this tool then "star" this post!

 

 

 

Hi,

A lot of companies now are deploying on both AWS and Microsoft Azure.

Alteryx supports AWS S3 object storage out of the box, it would be important to support Microsoft Azure blob as part of the native Alteryx product as well. 

Cheers,

Adrian

When you right click on a Macro tool (e.g. Google Analytics) within a workflow, you can choose the version of the tool to use. However, it does not indicate which version of the tool is already in use. 

 

Why is this an issue for me?

I have a workflow with 15 instances of the Google Analytics tool.  (I needed to use the API for each month fo GA data and then use a join. I built it this way due to the restriction on the number of records.)

 

So when I update the Google Analytics tool I have to do it 15 times. I'd like to be sure the update is needed before I start. 

 

Alteryx Support confirm that there is no way to tell which version of the macro is in use. 

 

Tableau allows users to do three very useful things to make data more usable for end users, but this functionality is not available with the Publish To Tableau Server tool.

 

Foldering of dimensions/measures

Folders.jpg

 

Creating hierarchies out of dimensions

Hierarchy.jpg

 

Adding custom comments to fields that are visible to users when they hover

Comment.jpg

 

This functionality allows subject matter experts to create data sources that can be easily understood by everyone within their organizations.  

 

Please "star" this idea if you would like to see functionality in Alteryx that would enable you to create a metadata layer in the "Publish to Tableau Server" tool or in an accompanying tool.

Right now the PublishToPowerBI connector only publishes to "My Workspace."  I manage datasets that feed reports for multiple workspaces, some of which are not necessarily personal workspaces (so there is no login associated). A drop-down that lets you select which workspace, that you are a member of, would be fantastic!

 

The workaround right now is to ETL in Alteryx then save the dataset out to OneDrive. You can then "Publish" the Excel sheet to Power BI natively, and the data refreshes once an hour. This works for some data, but we have use cases that need refresh rates much higher than that. Plus publishing directly to Power BI would be ideal.

It would be great if we could have a Windows Active Directory data connector tool added to the standard Alteryx toolset.

 

MS Excel Power Query and PowerBI both can connect to Active Directory for use as a data source, but are both very cumbersome to use.  Having a connector in Alteryx that can read AD data into a workflow would be super helpful for a long list of use cases.  A couple that are top of mind for me are:

 

-Leveraging group membership info for dynamic distribution of reports or datasets

-Being able to build reporting and dashboards about the organization (useful for Tech audit, HR, etc.) 

 

I've seen links to an old project on GitHub of someone that started development on this, but the method (just copy these random .dlls into your program directory) is seriously frowned upon by any enterpise IT.  Would be great if Alteryx could pick up that work, polish it a bit and add it to the actual Alteryx Designer toolset.

Tableau allows users to do three very useful things to make data more usable for end users, but this functionality is not available with the Publish To Tableau Server tool.

 

Foldering of dimensions/measures

Folders.jpg

 

Creating hierarchies out of dimensions

Hierarchy.jpg

 

Adding custom comments to fields that are visible to users when they hover

Comment.jpg

 

This functionality allows subject matter experts to create data sources that can be easily understood by everyone within their organizations.  

 

Please "star" this idea if you would like to see functionality in Alteryx that would enable you to create a metadata layer in the "Publish to Tableau Server" tool or in an accompanying tool.

It would be great if we could have a Windows Active Directory data connector tool added to the standard Alteryx toolset.

 

MS Excel Power Query and PowerBI both can connect to Active Directory for use as a data source, but are both very cumbersome to use.  Having a connector in Alteryx that can read AD data into a workflow would be super helpful for a long list of use cases.  A couple that are top of mind for me are:

 

-Leveraging group membership info for dynamic distribution of reports or datasets

-Being able to build reporting and dashboards about the organization (useful for Tech audit, HR, etc.) 

 

I've seen links to an old project on GitHub of someone that started development on this, but the method (just copy these random .dlls into your program directory) is seriously frowned upon by any enterpise IT.  Would be great if Alteryx could pick up that work, polish it a bit and add it to the actual Alteryx Designer toolset.

As you may know, the interrogation of Hive to get the Metadata is actually very slow on Alteryx

 

A first step of improvement (at least in the Visual Query Builder) has been proposed here

Smartest VQB

 

But the real issue for Hive is that the way Alteryx queries the Metadata : it passes "Show table" queries for all the databases. On our cluster, it means more than 400 queries that last each avout 0.5 seconds. The user has to to wait about 4 minutes.

A solution : using an API in java to ask the Hive metastore if it exists (it may be an other tab in the In database configuration). Our cluster admin has an example of a Thrift API in java that we can give you.

Result : 2 seconds for a 38700 tables in more than 500 databases !!

 

Alternative data sources are key for enriching data. one source is social media.I believe Alteryx lacks in social media analytics.

 

  • I would like to propose a YouTube connector...
  • Crawl comments and video definitions (useful for text analytics)
  • Impression and likes/dislikes... (time-series data)

 

If you are into #media, #advertising, #marketing analytics, #influencer analytics please support the idea by seconding...

 

There is an API called YouTube DATA API

https://developers.google.com/youtube/v3/getting-started

Picture1.png

 

 

 

Alternative data sources namely #altdata are key for enriching data. One source is social media.

I believe Alteryx lacks in social media analytics.

 

  • I would like to propose a Instagram connector...
  • Crawl comments, tags(useful for text analytics)
  • Impression and likes... (time-series data)

 

If you are into #media, #advertising, #marketing analytics, #influencer analytics please support the idea by seconding...

 

https://www.instagram.com/developer/authorization/ is the link for the graph API updated after the latest acebook scandal... now fixed...

Picture2.png

 

Picture3.png

 

Picture4.png

 

Picture5.png

 

 

 

Create new connector to pull Salesforce Reports

 

We are a large company with tens of thousands employees using Salesforce on a daily basis. Over the years, we have worked with Salesforce to make many customizations and create many reports to provide data for various reporting needs. However, we have increasingly found it inefficient and prone to error to download the reports manually. We have many teams using the Salesforce reports as a base to create additional business insights.

 

Alteryx is a great tool to manage data ETL and workflows, but it does not support pulling data from Salesforce reports directly. Instead, it only offers connectors to pull data from base Salesforce objects. The data from Salesforce objects such as tables can be useful, but do not necessarily offer the logical view of Salesforce reports, and may require a lot of efforts to reconcile the data consistency against the reports our users are used to. Sometimes, it may be impossible to repeat producing the same data from Salesforce tables as those from Salesforce reports. That in turn would cause a lot of efforts spent by the reporting teams, their audience, and users of the Salesforce reports to match things up.

 

Salesforce does not have any out-of-box solution to schedule downloading the reports. At our request, their support team did some research and have not found a good 3rd-party solution in the Salesforce App Exchange ecosystem that supports this need.

 

I strongly believe this is a great opportunity for Alteryx. Salesforce already has an API that allows for building custom applications to pull Salesforce reports. However, most Salesforce users are more business oriented and do not necessarily have the appetite to engage with their IT staff or external resources provide to develop such apps and bear the burden to main them.

 

I have attached the Salesforce Reports and Dashboards API Developer Guide for your reference.

 

Sincerely,

Vincent Wang

Our company is implementing an Azure Data Lake and we have no way of connecting to it efficiently with Alteryx.  We would like to push data into the Azure Data Lake store and also pull it out with the connector.  Currently, there is not an out-of-the-box solution in Alteryx and it requires a lot of effort to push data to Azure.

Where it stands now, only a file input tool can be used to pull data from Google BigQuery tables. The issue here is that the data is streamed and processed locally, meaning the power of BigQuery processing isn't actually being leveraged.

Adding BigQuery In-Database as a connection option would appeal to a wide audience. BigQuery is also standard SQL compliant with the SQL 2011 standard, so this may make for an even easier integration.

Hello,

 

I had a business case requiring a cost effective and quick storage solution for real time online sourced survey data from customers.  A MongoDB instance would fit the need, so I quickly spun up a cluster on Mongo Atlas.  Atlas was launched by MongoDB in 2016 as a database-as-a-service deployed on AWS.  All instances for Atlas require TLS/SSL to connect.  Currently, the Alteryx MongoDB connector does not support TLS/SSL connections and doesn't work against Atlas.  So, I was left with a breakdown in my plan that would require manual intervention before ingesting data to Alteryx (not ideal).

 

Please consider expanding this functionality on all connectors.  I am building Alteryx out in my agency as a data platform that handles sensitive customer information (name, address, email, etc.).  Most tools I use to connect to secure servers today support this type of connection and should be a priority for Alteryx to resolve. 

 

Thanks,

Mike Schock

 

 

 

 

  • Category Connectors

When you right click on a Macro tool (e.g. Google Analytics) within a workflow, you can choose the version of the tool to use. However, it does not indicate which version of the tool is already in use. 

 

Why is this an issue for me?

I have a workflow with 15 instances of the Google Analytics tool.  (I needed to use the API for each month fo GA data and then use a join. I built it this way due to the restriction on the number of records.)

 

So when I update the Google Analytics tool I have to do it 15 times. I'd like to be sure the update is needed before I start. 

 

Alteryx Support confirm that there is no way to tell which version of the macro is in use. 

 

Very simple. Use the wheel button on the mouse to reconfigure connections between nodes. You click on the origin or end and drop into the new anchor point.

Top Starred Authors