After the transformation, a relationship is established between the logical data model layer, which is represented by the ER model, and the physical data model layer, which is represented by a SQL model respectively. It is possible to navigate between the connected elements in the forward (ER -> SQL) and backward (SQL -> ER) directions using the dedicated submenu - Go To - on the element’s shortcut menu.

To go to the corresponding element in the forward direction

  1. Right-click the element.
  2. On it’s shortcut menu, click Go To > Traceability > Model Transformations > Transformed To.


To go to the corresponding element in the backward direction

  1. Right-click the element.
  2. On it’s shortcut menu, click Go To > Traceability > Model Transformations > Transformed From.

The same tracing information is visible in the element’s Specification window and Properties panel under the Traceability tab. This information is also reflected in the Entity-Relationship and SQL Report using navigable references between the report section. Traceability information can also be depicted in a relation map or in a tabular format using the capabilities of the custom dependency matrix feature.