BusinessObjects Board

Details of universe connections from query builder

security CMC
#1

I wonder if it is possible to have the full details of universe connections using query builder tool.

Actually I can have the list of connections with the following sql statement

SELECT * 
FROM CI_APPOBJECTS 
Where SI_KIND = 'MetaData.DataConnection'
Order by SI_NAME

but I do not see any detail like connection username, db, etc

and apparently, according to web documentation, I only can query 3 tables: CI_INFOOBJECTS CI_APPOBJECTS CI_SYSTEMOBJECTS
Connection details seem to be stored in some other table…

Is this correct?
Thanks

F.Zavatarelli :it: (BOB member since 2002-08-23)

#2

All the below mentioned tables are Virtual tables and doesnt exist physically. You have to write a SDK code to achieve this.

Use this utility from BOB downloads.

The below link would be useful for you to get more knowledge about Query Builder.

http://blogs.hexaware.com/business-objects-boogle/business-objects-query-builder/

http://blogs.hexaware.com/business-objects-boogle/business-objects-query-builder-part-ii/

Regards,
Mani

Manikandan Elumalai :us: (BOB member since 2009-10-23)

VBA to extract connection username