The Topology Relational Model Transform generates a special transform that produces a data structure used by Topology Visualizations. The current Topology Relational Model assumes a relationship between multiple tabular datasets. By describing these relationships, the model produces parent and child linkages that Topology Visualizations can consume to display.
The “Choose a Transform” dialog will appear, showing the available transforms in the system. Select the “Topology Relational Model” option. This will launch the Relational Model Wizard:
A graphical editor for defining the relationships between multiple tabular datasets. The instructions to use this editor are provided below.
The Link Definitions Editor is seeded with the node from which you created the Relational Model transform.
The illustration above is a self-referential example, where parent and child nodes can be in the same dataset. In other cases, different datasets can be the parents and children in the relationship.
When configuring a link definition, select two data sets:
The two datasets must contain an attribute with values that link the two datasets together. This is similar to choosing foreign keys in a SQL Join statement. Both attributes MUST be of the same data type.
The Arrow in the middle is a clickable button. This button allows you to change the direction of the relationship, or to select non-directional.
To make changes to a relationship that already exists, click a Link between two nodes in the relational model, and then click the edit button or double click the link.
To make changes to a data set’s unique columns, click a node in the relational model, and then click the edit button or double click the node.
Reachability options determine how nodes are discovered. By default, the nodes that are displayed include:
For the purpose of node discovery, “down” is in the direction of the “Target Data Set” nodes as defined in the “Link Definitions”, and “up” is in the direction of the “Source Data Set”.
The reachability options provide the following customizations:
Details about this step can found here: Satisfy Upstream Node Variables Wizard Step
The last step of the wizard allows you to manage Variables and is also a preview. It shows a simple diagram of nodes and links that represent the relationships you just defined. If you are familiar with the data you are trying to show, it can be useful in seeing if you correctly described the relationships. You would also use the sidebar of this wizard to modify upstream variables if needed.