Qlik Sense On-Prem - Automatic Data Lineage
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, analyzes 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 associated with App Tables, allowing users to trace the origins and locations of their data. Currently, lineage is traced for data that exists in an External source connected to Qlik, for example, in a Table located in a PostgreSQL database:
In Dataedo Portal, users can view which Analytic Apps reference a 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 a Linked Source with a correctly assigned database. If you don't see any Linked Sources, check if you belong to the Stream to which the given app is added and have the Can edit role, which is required to view the app script by Dataedo where metadata regarding external connections is located:
You can also assign Linked Sources by hand.
-
Rerun the import of the source - maybe the schema was imported in an older version or the configuration was incorrect.
