How to identify which ODBC connections are being used on Server

[ebalmelli]

Is it possible to identify which database or ODBC connections are being used on the QlikView Publisher server? We have many qvw tasks which run nightly. The qvw files are created by several different groups and we manage scheduling the tasks in QMC.

We are looking for a log that identifies which ODBC connections are being used. Is it even possible?

Thanks!

[Miguel_Angel_Baeyens]

You would need to set all QVWs to write a reload log, then, you can load them and see which document is using which CONNECT string. This is set opening the QVW file with QlikView Desktop > Settings > Document Properties > check Generate logfile. Resulting logs are stored along with the QVWs, with the same name.

Or do a different logging and see which connections are open when, but I would go for the QlikView way here unless you have a security incident or something you need to look into more carefully.

[rwunderlich]

You could scan all the script and look for connect statements.

Qlikview Cookbook: Script Repository http://qlikviewcookbook.com/recipes/download-info/script-repository/

-Rob

http://masterssummit.com

http://qlikviewcookbook.com

[ebalmelli]

I was able to find the DB connection information using the Lineage tab of the  Governance Dashboard.

Thanks to those who responded.

[bnichol]

Hi Rob,

Thanks for creating another great tool.

Is there a simple way to pull in scripts from any referenced import statements (.qvs files)?

Regards,

B