Ever wonder about the source of data of some view and what tables are used to define it ? Using Dataedo you can easily make sense of data flow between objects in Oracle database by visualizing it using Data lineage functionality.
What to expect
Views
Dataedo analyzes SQL scripts defining database views with built in SQL Parser and builds column-level lineage from tables/views to views (both materialized and not) queried by them. To learn more about parsing PL/SQL dialect visit: PL/SQL Parsing.
Known Limitations
Troubleshooting
I don't see data lineage for views
- Make sure you have selected right SQL dialect - in this case PL/SQL (SQL Dialect field at Data Source level).
- Rerun import of the source - maybe schema was imported in older version or configuration was incorrect.
- If your view uses a link to other database, make sure you have that database documented in your repository. Then make sure that you have created a Linked Source object that is named same as the alias used in the link creation. Source Database field in that Linked Source must point to the linked database documented in your repository.