Trace and extract information on raw data connections

[sandramarq]

Hi all, 

We are trying to create a detailed data lineage for our apps and QVD Loaders. So far we have extracted and mapped key bits of data lineage from our Raw QVD Loader (Extract) to Final QVD Loader (Transform) to App. 

What is now being asked is to go even further and try to trace back the original sources in the database. So for example if we use Oracle they would like to see:
Oracle Owner --> Oracle Table --> Raw QVD Loader etc. 

Is it possible to trace the lineage that far back and if so, how can it be done?

[rwunderlich]

The lineage data in your Raw QVD Loader should identify the Oracle Table.  You can get information like table Owner from the Oracle catalog using the SQLTABLES script statement. 

https://help.qlik.com/en-US/sense/November2023/Subsystems/Hub/Content/Sense_Hub/Scripting/ScriptRegu...

-Rob

[adkins5]

What kind of chart? I know you can double click on each element (say, a bar in a bar chart) and it should extract that data.