We are trying to implement a QlikView app in our environment and we are struggling with one thing,
In the QVD generating QVW's we have to connect to an ODBC that has a username and password on it, so we type that in. However, our system requires us to change our password every 90 days. When everything is said and done we plan on having 4 QVD generators that we schedule to run (daily, weekly, monthly, and quarterly).
What do you think is the best way to handle the password situation? We would prefer to not have to go into all 4 and change that string every 90 days. Surely we can automate this someway? We thought about passing UserID and Password to all 4 from an Excel file, however then we have to push that Excel file to the server and that's a security risk because that Excel file cannot be encrypted in order for QlikView to use it. Could we somehow get it from an encrypted file? Just throw ideas at me, because this is a new development environment for us, I'm open to all suggestions.
We've also talked about automating the change on our side with Windows Scheduler or some kind of similar macro that runs on a back-machine. We are just now dabbling in that realm too, is anyone familiar with it and how well it would work with QlikView?
Any ideas/suggestions/thoughts/examples of how you handle something similar?
-Neil
