Exporting Lineage Reports to a Comma-Separated-Values File
All of the information represented in the tree view and the graph view of the dependency report can be exported to a comma-separated-value (csv) file.
To export dependency reports to a csv file
1. Display the resource lineage graph.
2. Make sure that the lineage graph has the resource focus that you want.
The lineage report in the csv file is based on the current resource which is shown with a blue title bar.
Note: It does not matter if the lineage graph is expanded or collapsed. Column information is included in the exported file, regardless. If you hide dependencies or references in the lineage graph, they are not included in the exported file.
3. On the lineage button toolbar, click the Save To File button.
4. In the Save dialog, navigate to the location where you want to save the information.
5. Name the file that will contain the dependency information.
6. Click Save.
7. Open the file in Excel or other similar application.
The lineage report contains one row for every connecting line in the lineage graph. A connecting line represents a dependency or reference. The information for each dependency or reference is as follows:
SourcePath | SourceType | SourceColumnName | ReferenceByPath | ReferenceByType | ReferencedByColumnName |
The path to source | The source type: TABLE, DATA_SOURCE, PROCEDURE, MODEL, and so on | For column dependencies, the name of the column. | The path to the reference. | The resource type: TABLE, DATA_SOURCE, PROCEDURE, MODEL, and so on | For column references, the name of the column. |
Sample lineage information:
