Meta data extraction Automation

Mani123 — Mon, 20 Dec 2021 21:08:46 GMT

Hi Experts,

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.

Thanks in advance!

topic Meta data extraction Automation in App Development

Meta data extraction Automation