Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!
The Product Idea boards have gotten an update to better integrate them within our Product team's idea cycle! However this update does have a few unique behaviors, if you have any questions about them check out our FAQ.

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

Hello Alteryx team,

 

Can you please includeSAP Crystal Reports loader in the Connect for Future Release.

 

Thanks

Sri

Hi Alteryx team,

 

I understand that tags applied in the Alteryx Gallery are a completely different tags from the tags within Connect.

 

Would it be possible to sync these two and when loading Gallery metadata into Connect (workflows), load and apply also the tags?

 

Thank you

Michal

The current "File_Loader" only pushes data to the Data Sources section in connect. We have a number of reports that are stored in a file location. Our current option is to bring the report into connect under 'Data Sources' and manually move them to 'Reports'. We have to do this every time the file_load is ran. Additionally, the are currently shown as inputs to workflows when they should be outputs.

 

Having a file loader for Reports would be greatly beneficial to document within the Connect Platform.

A lot of information is not captured when colleagues run numerous SQL codes on server. Oracle, SQL Server, Azure and others...

Would there be a clever way of capturing and archiving all this queries run?

 

It may be wise to collect these for several reasons;

  1. SQL code profiling is an important matter especially for DB admins. You can see the most required tables and fields etc.
  2. Also have a grasp on most frequent and time consuming joins to enhance DB performance
  3. Figure the queries that can be replicated in Alteryx and deployed to a server so that no business user needs to run SQL code instead  they will be reverted to the gallery.

 

So found out a similar feature is now available in SQL Server 2016 -->  https://docs.microsoft.com/en-us/sql/relational-databases/performance/monitoring-performance-by-usin...  

 

 

Hello All,

 

We are new to Alteryx and we could see that the Supported Data Sources from IBM are of below :

  • IBM DB2
  • IBM Netezza/Pure Data Systems
  • IBM SPSS

How about adding IBM Sterling to this?

We want Alteryx to support connection with IBM Sterling OMS which will help the Business requirements

Can anyone post some suggestions on this? How we can connect to Sterling?

 

Thanks,

Praveen C

 

0 Likes

Hello!
I have a potential feature enhancement for the database-based Metadata Loaders. This has been tested with the PostgresSQL loaders, however I suspect this is something that is reflected across all database loaders.

This suggestion is simply for constraints of the fields to be brought into connect, with the names of the fields. So for instance the following:

TheOC_0-1625747415376.png



is visible in Connect as:

TheOC_1-1625747429390.png



What would be nice is two additional columns, 'Not Null' and 'Primary Key'. Or alternatively, a 'constraints' column, that contains these constraints, so that it does not have to be documented manually following an import.


Thanks,
TheOC

0 Likes

It would be great if the File loader could recognize the SQL file extension to read and display the SQL script in Connect. An example would be similar to how the DDL is visible when you look at views in Data Sources. This would provide a large benefit when researching overall data usage and mapping to other data sources and workflows.

0 Likes

It would be very useful to have a standard metadata loader for chained workflows or apps.

 

Currently the Crew Macro Conditional runner or the Alteryx Event/CMD based workflow/app chaining or the chaining from interface designer do not have a corresponding metadata loader. 

 

At the moment the only option of creating a nexus for chained apps or workflows is to manually create the links between various assets and workflows. This can be highly tedious depending on the number of workflows/apps being chained, inputs and outputs involved in each workflow and also error prone.

 

This creates a sort of blindspots in terms of end-to-end metadata management and showing true lineage when using chained Alteryx apps/workflows.

 

As the chaining of workflows and apps is a major timesaver and helpful tool to break down larger jobs into smaller manageable jobs it would be massively useful to have a corresponding metadata loader.

 

Many thanks,

Gourab

0 Likes

The Alteryx Connect loader (found under help / sample workflows etc...) is set up to be run in interactive mode as an analytical app.

However; on any installation of a reasonable size - these loaders will be scheduled to run without user intervention.

 

Given the fact that Analytical Apps are not easy to schedule (given the interactive nature of the inputs) - it makes sense to provide a version of the loader that is ready out-the-box to be scheduled and run hands-free (built and tested as a yxmc file).

 

Many thanks

Sean

0 Likes

Hi Alteryx team,

 

Currently, Alteryx Server loader is pulling quite a several different types of information (e.g. date uploaded, number of runs, last run date, published version etc.).

 

Would it be possible to add the information about the workflow schedule? It would contain the frequency of how often it is scheduled to run on the server (if applicable), for others, it can be "not scheduled" or something.

 

Thank you

Michal

0 Likes

In the Alteryx Gallery we have the ability to place workflows in Districts or Collections. This structure should be maintained in Connect. Similar to how Data sources are managed, instead of Data Source Servers, you have an area to select and filter by the various collections and districts in which workflows are contained.