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 database, such as Oracle. 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.
Preview Notice:
Effective in the April 2023 release, creation of connection assignments for a
Microsoft SharePoint Online
catalog source is available for preview.
Preview functionality is supported for evaluation purposes but is unwarranted and is not supported in production environments or any environment that you plan to push to production. Informatica intends to include the preview functionality in an upcoming release for production use, but might choose not to in accordance with changing market or technical circumstances. For more information, contact Informatica Global Customer Support.
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.
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.