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 reference source system might be a cloud service, such as Informatica Intelligent Cloud Services. 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.
3Select one or more objects from the endpoint catalog sources and click Assign.
You can connect to the following referenced source systems:
- Informatica Intelligent Cloud Services.
- dbt
- AWS Glue
- Informatica PowerCenter
The referenced catalog source must belong to the Database 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.