BusinessObjects Board

SQL / VBA SDK to get Universe DB connection details from CMS

sdk development
#1

Hi

Am trying to get Database Name and User Name from Universe DB connection, but it looks like these values are placed as a Property bag. So am looking for a VBA Code to get details from Property Bag or any direct Query Builder SQL for the same.

Please share your inputs!

Thanks in advance.

stvel (BOB member since 2007-10-04)

#2

See the following post. Dwanye posted an excel spreadsheet that has a macro to document universe connections.

jresendez :mexico: (BOB member since 2004-05-03)