SQL Tables Used by QVD

[Johnnyg248]

I have a folder of about 50 qvd's which were created from sql server table data.

I have been asked to 'reverse engineer' the qvd's to get a list of the sql server tables that were used for each qvd

I know the QVD files are xml files and browsing through them there is the query information

Just wondering if any has had any occasion to have done this and if so would mind sharing an example

Thanks!

[afurtado]

I was intrigued and made this model by reading SQL tables, generating the QVD files and then reading these QVD and mounting the SQL, reading again and saving the new QVD in another folder.

You must have lineage enabled before the SQL is already within the QVD to be read  (settings.ini   AllowDataLineage=1)

Otherwise, this approach will not work.

And also remember that I did a small test (4 files) just to show that works. It may require adjustments ....under your responsibility ....

[afurtado]

I forgot to create a  SQL script (txt).

The txt output must be changed yet. 

[Johnnyg248 · Accepted solution]

Thanks so much for the response!

I am a bit new to qvd's so apologize if the following questions are a bit basic

Not quite sure what the lineage flag set to 1 does exactly

why wouldn't this be the default ?

also the file you provided appears to be qliksense and I am using qlikview

Thanks again!

[Brett_Bleess]

Couple of articles that may help with your last questions:

https://support.qlik.com/articles/000003493 

https://support.qlik.com/articles/000003491 

Regards,
Brett