Right now, we only have 5 users, and all of us are Root Admins.
Each time one of us creates a connection in the hub, our usernames are automatically added to the end of that connection.
If we each create the same connection, it will be in the QMC 5 times. If we change the name of one of them in the QMC, the name change is not reflected in the hub.
We can only use the changed connection name when the app is closed. If we want to reload the data when the app is open, we have to use an existing connection name in the hub.
Is this something that can be avoided?
How can we add the connection name that was changed in the QMC into the Hub?
Mike this is how Sense works when it comes to connections. More than likely, you would really only want to define the connection once. Once it is created, go into the QMC and edit the connection to remove (UsernameA) from it's name. Now you have it defined once and it will be available to all 5 of you. No need to define it 5 times! This also allows each user to define connections. Sense just appended the username to keep the connection name unique.
This is so that you can add security around connections. For example, in the future, you may not want to grant every user the ability to create ODBC connections. You may create a rule that allows just 'power users' to create ODBC connections but your everyday users can create folder connections if they have the ability to create applications.
So when you had Extract QVDs (UsernameA) and Extract QVDs (UsernameB), etc, you could have renamed Extract QVDs (UsernameA) to Extract QVDs and deleted the other connections. This would have been available to all 5 of you, no need to define the same connection more than once and then all your LIB statements will be using the same connection.
It just takes a little planning upfront but will end up saving you time in the long run.
Hope this helps.