When you run the catalog source job, if the catalog source references another source system, a reference catalog source and connection get created that point to the reference source system. To view the complete lineage for your catalog source, you can perform connection assignment from the reference catalog source connection to the objects in the reference source system. A referenced source system might be a database, such as IBM Db2 for LUW. You must first create and run an endpoint catalog source that connects to the reference source system.
Before you assign a connection, ensure that you have created and run an endpoint catalog source for each reference source system.
Note:
If the source schema contains case-sensitive tables or if the reference objects contain multiple objects with the same name in different cases, perform case-sensitive connection assignment to get correct lineage.
If you enabled the lineage discovery capability for your catalog source, you can either curate the CLAIRE recommended endpoint objects on the Related Catalog Sources tab or assign connections manually.
For more information about related catalog sources and lineage discovery, see Lineage discovery.
1On the Configure page, select the Lineage tab, and then select the Lineage Discovery tab. On the Catalog Sources panel, select the required catalog source and click the Assign Connections tab.
The Assign Connections tab displays a list of assigned and unassigned connections along with details for each connection. Use filters to view the connections based on the connection names. Click the Add Filter menu to add filters.
2Select the connection to the reference source system and click Assign.
The connection name appears prefixed to the reference catalog source name on the Hierarchy tab of your catalog source in Data Governance and Catalog.
The Assign Connection dialog box appears with a list of recommended objects from the endpoint catalog sources. Click All to view all endpoint catalog source objects.
3In the Assign Connection dialog box, select one or more catalog sources to assign to the selected connection and click Assign.
You can assign an IBM Db2 for LUW source system as a referenced source system. To create a connection assignment, the catalog source must belong to the Schema class type.
When you click Assign, Metadata Command Center creates links between matching objects in the connected catalog sources, and it calculates the percentage of matched and unmatched objects. The higher the percentage of matched objects, the more accurate the lineage that you view in Data Governance and Catalog.