is Qlikview support Data Discovery?

[#1]

My question here is, Can I use Qlikview to find some sensitive data from my database where I have around 10,000 tables. Basically I want to do something similar to the below url, Please suggest

http://www.darkreading.com/views/what-data-discovery-tools-really-do/227700889

[#2]

Can someone suggest something on this? Basically is the url displayed in my comment is possible to implement in Qlikview?

[kaushiknsolanki]

Hi,

     Every Database keeps a metadata information. For example Oracle stores all the table information in.

     Sys Schema and All_Tables table, like wise there are so many system tables which stores meta information.

     You can get the data from "All_Tables" table and then you can search the proper table information out of it.

Regards,

Kaushik Solanki

[#4]

Hi Kaushik,

So does Qlikview help me to write some script to do this? can you give me some sample code on how to implement the same in Qlikview? Please suggest.

[kaushiknsolanki]

Hi,

     There is no specific script for this.

     It just a table.

     So first of all you will need an ODBC connect to that database and then below query to get the data in QlikView.

     Sql Select * from all_tables;

Regards,

Kaushik Solanki