Michal Adamczyk
Using various data when creating reports in Qlik from many sources may make you feel uncertain about their origin. Fortunately Dataedo can help you by visualizing their flow process by Data Lineage functionality.
What to expect
Analytic Apps (Reports)
Dataedo imports metadata about Analytic Apps, analyses them and builds column-level lineage from them to App Tables that have been created in a given Qlik app.
App Tables (Dataset Tables)
Dataedo analyzes the metadata and associated with App Tables , allowing users to trace the origins and locations of their data. There are two possible options of data lineage.
Data flows from Dataset located in Qlik catalog:
The data exists in External source that is connected to Qlik, for example in Table located in PostgreSQL database:
In Dataedo Portal, users can view which Analytic Apps references given table.
Everything everywhere all at once
Going one step higher user can browse data lineage from the drom the database level. All data flows from single object (report, dataset table) can can be traced by clicking on it.
Known limitations
- Column level lineage between some computed measures and columns they use may not be created
Troubleshooting
I don't see data lineage from External source database
- Make sure the source object has Linked Source with correctly assigned database. If you don't see any Linked Sources check if you belong to Shared Space to which given app is added and have Can edit role which is required to view app script by Dataedo where metadata regarding external connections is located:
You can also assign Linked Sources by hand. - Rerun import of the source - maybe schema was imported in older version or configuration was incorrect.