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. Currently lineage is traced for data that data exists in External source connected to Qlik, for example, in Table located in PostgreSQL database:
In Dataedo Portal, users can view which Analytic Apps references given table.
Known limitations
- Lineage between Qlik Data Files (e.g. CSV files) and Application tables is currently not created
- 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 Stream 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.