You can translate the question and the replies:

Data Lineage Report in Excel

I have created and SOAP Service using through multi step approch creating multiple derived views from Database base views. However, I would like to capture all the linege(all intermediate steps) and Base View to Service View mappings in a spreadsheet. Can you please help me extract this information.
user
14-09-2017 19:39:17 -0400
code

1 Answer

Hi, For exporting the data lineage and mappings between fields of different views, I would use the following stored procedures that come out-of-box with Denodo Platform. * [VIEW_DEPENDENCIES](https://community.denodo.com/docs/html/browse/6.0/vdp/vql/stored_procedures/predefined_stored_procedures/view_dependencies#view-dependencies) * [COLUMN_DEPENDENCIES](https://community.denodo.com/docs/html/browse/6.0/vdp/vql/stored_procedures/predefined_stored_procedures/column_dependencies#column-dependencies) I would run these stored procedures in VQL shell and store the results in a CSV file by clicking on 'Save' button in 'Query results' window. Alternatively, I would [create a view](https://community.denodo.com/docs/html/browse/6.0/vdp/vql/defining_a_derived_view/defining_a_derived_view) from one of these stored procedures, then use Excel to query these views [using ODBC connection](https://community.denodo.com/docs/html/browse/6.0/vdp/developer/access_through_odbc/access_through_odbc) and save the results. You can also find a similar QA '[Auto documentation/Lineage GIF](https://community.denodo.com/answers/question/details?questionId=9060g000000XdJ3AAK&title=Auto+Documentation%2FData+Lineage+Gif)' for other possible options. Hope this helps!
Denodo Team
15-09-2017 08:25:38 -0400
code
You must sign in to add an answer. If you do not have an account, you can register here