Schema Explorer v0.1

The tool comprises of:

* A Qlik Sense and QlikView all-in-one app

The tool can be run in two modes:

Mode 0 : Data extraction of a configurable sample size from each database table present in one or more defined database schemata. The data is cached in an equivalent QVD layer.

Mode 1: A load of a configurable sample size of data from any QVD layer into a front-end tailored for searching across both actual data and meta data.

Typical use cases:

• Reverse engineering where data lives from a front-end report by trawling for hits in the back-end data.

• Reverse engineering relationships between tables of data by looking for common content, common key values and common field names

The tool has been effectively used in a live customer scenario where a back-end database behind a third-party workflow system contained critical data that had not been extracted for general use before.

Enjoy!

For enhancement requests, bugs or commercial application considerations, please get in touch by email or LinkedIn. Contact details found in the site footer.

- Jonas Valleskog

Note: Some aspects of the code, such as the row count restrictions applied against different databases has not been fully tested. Use at your own risk.