Relationship views are available for technical assets in the catalog source. You can connect assets to each other using different types of relationships.
A relationship between assets shows how the assets relate to one another. When data from a source system is ingested into the catalog, Data Governance and Catalog can automatically create relationships among the technical assets of that source system.
For more information about viewing relationships, see Relationships in the Data Governance and Catalog help.
View relationships at catalog source level
The Relationships tab of an asset page displays the relationships between the selected asset and other business and technical assets in Data Governance and Catalog.
The IDERA ER/Studio Data Architect catalog source reads metadata from the input data model and creates reference assets in the model. You can view the relationship with reference objects without performing connection assignment. After connection assignment, you can view the relationship between the actual objects extracted by the IDERA ER/Studio Data Architect catalog source and database assets that already exist in the catalog.
To view relationships at the catalog source level, search for and open a IDERA ER/Studio Data Architect catalog source, click the Relationships tab and expand the catalog source.
Note:
Only the physical model allows you to view data sets, data elements, and reference resources.
The following image shows the view to view relationship between the IDERA ER/Studio Data Architect asset and the referenced data set before connection assignment:
The following image shows the view to view relationship between the IDERA ER/Studio Data Architect View_Emp_Address asset and the Oracle view after connection assignment:
View relationships at data set level and data element level
The relationships at the data set level and the data element level show how the technical assets such as tables and columns are related to the selected asset.
Data sets are technical assets that contain sets of data. For example, a table in a source object. Data elements are objects upstream or downstream of a data set. For example, a column in a source object.
View relationships at the data set level
The relationships at the data set level show how the technical assets such as tables are related to the selected asset. To view relationships at the data set level, open a technical asset such as a table, click the Relationships tab, and then expand the data set.
The following image shows the table-to-table relationship between the IDERA ER/Studio Data Architect Employee asset and the referenced data set before connection assignment:
The following image shows the table-to-table relationship between the IDERA ER/Studio Data Architect Employee asset and the Oracle table after connection assignment:
View relationships at the data element level
The data element level displays details of the data set level. The relationships at the data element level show how the technical assets such as columns are related to the selected asset. To view relationships at the data element level, open a technical asset, click the Relationships tab, and then expand the data element.
The following image shows the view column to view column relationship between the IDERA ER/Studio Data Architect Address ID asset and the reference data element before connection assignment:
The following image shows the view column-to-view column relationship between the IDERA ER/Studio Data Architect Address ID asset and the Oracle view column after connection assignment:
The following image shows the table column-to-table column relationship between the IDERA ER/Studio Data Architect Address ID asset and the reference data element before connection assignment:
The following image shows the table column-to-table column relationship between the IDERA ER/Studio Data Architect Address ID asset and the reference data element after connection assignment:
