Relationships View
You can view a summary of the enterprise discovery results in the Relationships view including entities. Entities are groups of data objects represented as circles. Entities include related, self-related, and unrelated data objects from the multiple connections and schemas of the source databases.
A self-related data object has columns within the data object that have relationships. An unrelated data object neither has relationships with other data objects in the source database nor has a relationship between columns within the data object. The entity relationship diagram of data objects in enterprise discovery results is based on inferred relationships and not the documented relationships in the data sources.
Searching for a Data Object
You can search for a data object in the Relationships view or the Foreign Key Profiling view. You can use an asterisk (*) as a wild character to find data objects.
1. Verify that you are in either the Relationships or Foreign Key Profiling view.
2. Type in a part of the data object name you are searching for and add the * wild card character to the beginning or end of the search string based on the search requirement. For example, to search for all data objects starting with the string "CA", type in "CA*" and press the Enter key. To search for all data objects that have the string "ZIP" in their names, type in "*ZIP*".
The search is case-sensitive.
Navigating to the Foreign Key Profiling View
The Foreign Key Profiling view displays a consolidated view of foreign key relationships across multiple data objects that you ran the profile on. The circles in the view represent entities, self-related objects, and unreferenced objects.
1. Verify that you are on the Relationships tab.
You can view the foreign key profile link in the right pane.
2. Click Foreign Key Profile to open the view.
The view appears in a new tab. The view displays data objects in different sets of circles based on their relationship type. You can also see the total number of data objects that are a part of the consolidated foreign key view.
3. Optionally, you can click the Relationships link to go back to the Relationships view.