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?
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.