topic Re: SQL Tables Used by QVD in QlikView

SQL Tables Used by QVD

Johnnyg248 — Fri, 20 Mar 2020 18:53:26 GMT

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!

Re: SQL Tables Used by QVD

afurtado — Fri, 20 Mar 2020 22:08:42 GMT

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 ....

Re: SQL Tables Used by QVD

afurtado — Fri, 20 Mar 2020 22:26:34 GMT

I forgot to create a SQL script (txt).

The txt output must be changed yet.

Re: SQL Tables Used by QVD

Johnnyg248 — Mon, 23 Mar 2020 14:15:07 GMT

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!

Re: SQL Tables Used by QVD

Brett_Bleess — Tue, 14 Apr 2020 19:55:04 GMT

Couple of articles that may help with your last questions:

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

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

Regards,
Brett