USER MANUALS


360 Graph (pka Reference Lineage)

The 360 Graph pill contains a graph that shows the relations with external elements between all involved entities: Reports, Datasets, Dataset Entities, Denodo Views and Custom External Elements. If an external element uses a Denodo View, the node of this view links with its Data Lineage diagram, which shows how this View is built based on other views and how data flows from the data sources into the view in each query.

The 360 Graph now offers two visualization modes —tree and network— improving data clarity and accessibility. Both supports basic operations like zoom in, zoom out, moving the diagram by drag and drop, collapsing nodes in the tree, exporting it as an image, etc.

360 Graph Tree View

The 360 Graph highlights the current external element as the root node. All other entities are connected as outgoing nodes, which can be leaf nodes or linked to a View node if this use a View to be built. If the external element is a Report, the graph shows three or four levels: the Report, the Datasets, the Dataset Entities and the Denodo Views (if used).

Tree view with the 360 Graph for an external element

Tree view with the 360 Graph for an external element

This tree structure is also applied to custom external elements:

Tree view with the 360 Graph for a custom external element

Tree view with the 360 Graph for a custom external element

360 Graph Network View

For more complex relationship scenarios, a network view is shown. Instead of following a strict tree structure, the graph expands into a network layout to improve data clarity. The root node remains highlighted, along with all the relationships originating from it. However, the option to switch back to the tree view remains available.

Network view with the 360 Graph for a custom external element

Network view with the 360 Graph for a custom external element

360 Graph Components

There are two types of nodes: one line nodes or two line nodes. Both show the left-icon, the type and the minus or plus icon, except for the leaf nodes. The two-line nodes also show a left-icon, the name, and a more-info icon, when the element has a details page. The nodes are classified in three different groups which are identified by a color code in the top-left icon.

In Reports his classification uses red for Denodo Elements, grey for Data Sources, and blue for External Elements. The group of external elements can also be identified by the icon representing its server type, such as Tableau or Power BI. In contrast, custom external elements offer more versatility, allowing you to configure their colors and icons as detailed in the Setup Guide

To obtain more information about some element click the node and a tooltip will appear with information about the element: Connection Type, Extracts, Dataset Type, Server Type, etc. You can click the more-info icon in the tooltip to get a popup with further information. The view nodes have an expand button which show the Data Lineage tree of this view. When this tree is loaded, the view node is updated with the Denodo’s information, showing more details of this element.

360 Graph for an external element and more info tooltip

360 Graph for an external element and the more info tooltip

Additionally, since the introduction of custom external elements you can obtain more information about the relationship between two elements by clicking on the connecting lines. Then, a tooltip will appear with information about the two elements and the kind of relationship between both. Furthermore, the direction of the relationship arrow indicates the data flow between the two elements.

360 Graph for an external element and more info relation tooltip

360 Graph for an external element and the more info relation tooltip

Note

You will only see the nodes in the tree view that you are allowed to, according to your privileges in Virtual DataPort:

  • For a data source to appear in the diagram, you need to be granted with the CONNECT privilege on its database and with the METADATA privilege on it. Otherwise, it will not appear.

  • For a view to appear in the diagram, you need to be granted with the CONNECT privilege on its database and with the METADATA privilege on it. Otherwise, it will be replaced with a node labeled with the text No Privileges.

  • For a custom external element appear in the diagram, you need to be granted with the Visualize privilege on its external element type configuration.

Add feedback