Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Read about the latest Qlik Community enhancements on the Community News blog!
cancel
Showing results for 
Search instead for 
Did you mean: 
ebalmelli
Contributor II
Contributor II

How to identify which ODBC connections are being used on Server

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!

4 Replies
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
Contributor II
Contributor II
Author

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

Thanks to those who responded.

bnichol
Specialist
Specialist

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