Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
What's the best way of searching through all our Enterprise Qlik Sense code to identify which apps use specific Oracle database tables, as we have a requirement to replace some with newer tables?
We can easily identify data loader apps which build qvd files from the table as these are named the same as the table, but not the apps which use SQL to extract data from the table directly.
Ideally, we'd like a straightforward method, but any advice is appreciated.
Thanks
Hi, depends on how much apps are in your portfolio and how often you use Oracle DB as source in them. To narrow down list of apps,I would use 'Data Connection Analyzer' app ( https://adminplaybook.qlik-poc.com/docs/tooling/data_connection_analyzer.html ).
Other suggestion would be to run loop load from 'ServerLogFolder../Script/*.log' all log files of app load executions and search specific string in them.