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 like 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

Establish lineage/relationship between SAP HANA and Tableau (reports)

 

Issue

By default in Connect, we are unable to see data lineage between SAP HANA and Tableau. The standard Alteryx loaders (i.e. Tableau & SAP HANA) in version 2019.2 are unable to detect the HANA object link due to a misaligned naming convention (“::” vs “/”). This specifically occurs when Tableau dashboards are pointed to HANA synonyms (“::”) as opposed to the views (“/”).  

 

Background

In SAP Hana, there are two types of objects – views (which are present in relevant schemas, e.g. “_SYS_BIC”) and synonyms. The synonyms are created for each view by default and always appear to be in the schema “PUBLIC”, however, this is not actually an explicit schema. According to SAP, public synonyms are the official access interface for the system views.

 

When loading the objects from SAP HANA, the object names contain the package name as well as the object name (view etc.). These two are differentiated with a “/” when loaded from the “_SYS_BIC” schema (e.g. “GSTP_VALIDATION/CA_01_C_PDA_GRA_001”), however synonyms from the “PUBLIC” schema are loaded with a differentiator of “::” (e.g. “GSTP_VALIDATION::CA_01_C_PDA_GRA_001”). An example below, where first row is the view and the second row provides the related synonym:

 

clipboard_image_0.png

 

Thus, the lineage is not established when the SAP HANA objects from schemas are loaded (containing the “/”, and at the same time, the Tableau dashboards linked to the synonyms (“::”). This is because the object names are quite clearly different, and the loader doesn’t currently resolve the synonym to view translation (as per standard SAP HANA SQL parsing behaviour).

 

Loading problem analysis (using standard Alteryx loaders)

On SAP HANA side, when running the loader, user can (optionally) define schema name(s) they wish to load, however:

  1. When schema is set as “_SYS_BIC”, the loader only loads the views from this particular schema, with no synonyms.
  2. When schema is left as blank (i.e. no value entered), the loader loads everything, however in the “_SYS_BIC” schema, only synonyms are loaded and not the views.
  3. When schema is set as “PUBLIC”, the loader does not return anything - fails as there is no corresponding schema in SAP HANA (it is only virtual space, not an explicit schema)

The SAP HANA instance in question is very, very large and due to volume limitations, as well as the potential risk of performance degradation, it is not feasible to load everything.

When we’ve examined the H2 staging tables, we find that Connect has loaded (therefore is technically aware of) the synonyms from the “PUBLIC” schema but they are not ever loaded beyond the staging tables. This is obviously required if we wish to represent these relationships within Connect.

 

Idea/Fix:

  • SAP HANA loader – it seems there is a problem of loading synonyms from the “PUBLIC” schema and the loader should be adjusted in order to allow this.
  • Tableau loader – needs to be able to refer to synonyms defined in a SAP HANA data source, meaning whenever there is a “::” in object name and the schema name is blank (i.e. empty string representing the “PUBLIC” schema), then it should be defaulted to “PUBLIC”. This logic would ensure that a schema name is always present, even in cases where the schema name is retrieved as blank (which then would become “PUBLIC”).
  • In case the schema name is left blank for any reason, it should be populated as “PUBLIC”.
  • @DanH suggested to customize the Tableau loader as a temporary fix to replace the “::” with “/”, which is certainly possible but comes with a risk of incompatibility with future releases. Also the customers strong preference is to deliver a solution which only utilises standard loaders.

Hi,

 

In standard Alteryx Gallery loader (to Connect), would it be possible to implement an option of selecting the public workflows only and ignoring the ones stored in users' private studios?

 

Thanks

Michal

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

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

PowerBI Report Server is now offered as an on-prem solution. It would be great if there was a loader available to capture PowerBI reports not in Azure. If this could also capture SSRS reports which also reside on the PowerBI Report Server this would also be very beneficial.

Can't really tell if you've clicked the Like button already...

Seems like it goes from a dark grey to a light black. 

And the tooltip always shows "Like"

 

Please change the Liked object to blue; like when you hover over it. 

And also update the tooltip for Liked objects to say "Unlike".

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.

 

 

 

 

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! 😄 

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.

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.
 
 

 

@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. 

0 Likes

Hi, 

 

I understand it is possible to integrate the users from active directory into Connect but there is no functionality to import actual user groups. Is that something that can be added to the roadmap?

 

Thanks

Michal