Does anyone know where WEBI stores the User Name/Password for the database it is accessing? Currently, on the web server we have WEBI installed on we have UDB as our client to access our DB2 database. Our security group is concerned that if someone hacks into our server they will be able to get the User Name/Password to our database. If we knew how and where this is stored we would be able to protect it better. Thanks.
The connection is stored encrypted in the *.key file (for accessing the Business Objects security repository). All other connection info is stored in the Business Objects security repository (encrypted) I believe.
Thank you for the response. However, I probably did not state my question correctly. We have two different databases, one which holds the repository and one that houses all of our data. I believe the connection to the repository database, the user name/password, is stored on the *.key file. However, is the connection information for our “data” database also stored in that file (not the repository)? Our repository database is on SQL Server, and our “data” database is on DB2. Again, I believe BO uses DB2 connect to retrieve data from our “data” database. What I needed to know what does it store the user name/password that was entered in DB2 connect anywhere in the application? Thank you.
The user ID and password for your data connection - whether it is BOuser or a proxy ID - is not stored in any key file. That is stored in repository as was stated before. It is not stored in DB2 Connect either, even tho you may enter it in the Client Configuration to test the connection.