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
- Right-click the element.
- On it’s shortcut menu, click Go To > Traceability > Model Transformations > Transformed To.
To go to the corresponding element in the backward direction
- Right-click the element.
- 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.