We are working on development of Data Lineage application in QlikSense which will help end user to answer below use cases
Database tables used to build QVDs
Mapping between database column name and QVD column name
QVDs used to build a QlikSense App
Mapping between QVD columns and Application columns
We are looking for ways to automate metadata extraction but are facing some challenges as mentioned in below cases
Case 1 :
Is there any way to automatically fetch list of database tables used to build a QVD and mapping between database column and QVD column
Note :We tried reading QVD script in XML format but this method is not of great help. Reason being, sometimes the extracted script is not complete or it does contains irrelevant code
Case 2 :
Is there any way to automatically map QVD columns with application columns, provided we have list of application dimension and metric fields
Please do help with your suggestions within QlikSense scope or outside of it.
