Method of extracting lost / forgotton credentials from Designer.
ExtractConnections.xls (c) J.Huntley 2011 Version History --------------- V1.0 November 2011 Description ----------- In an large Business Objects installation, connection credentials can often get lost or forgotton. Usually, the only way to resolve this is to reset the database password. Unfortunately, this may cause additional problems, particularly if the account is shared by another application or other BO connections. As a result, there may be a legitimate need to recover lost credentials. The encryption scheme used by Business Objects XI appears to be secure. Universe Designer, however, as part of the process of displaying the connections dialog box queries the CMS for connection objects and creates a class instance internally to hold all the details should the user wish to view or change them. It appears from examining the heap of the designer process directly after the connections window is displayed that each connection instance holds an XML fragment containing all the connection properties including the cleartext password. I summise that this XML is probably what is used to exchange connection data with the CMS and that instance variables may be used to interact with the GUI. As Designer has helpfully filled its heap with easily identifiable cleartext credentials, it is relatively easy to to extract these details and populate a spreadsheet with the connection properties. Limitation: Connection name is not available. If you need this, InfoObjects is probably the best source.
Tested on XI3.1 SP3, may well work on other versions.
ExtractConnections.xls (99.0 KB)
RHuntley (BOB member since 2011-08-12)