info on connection to Universe

[abhi900]

hi,

wanted to know what is best way to connect to BOBJ universe through 3rd party dashboard reporting tools which has a facility to connect to a datasource via ODBC connections or so?

i guess BOBJ provides SDK kit or through its API's to let you connect to their universe? is this correct and if anyone can please please provide any links or articles or documentation on doing so ? just for starters, it would be awesome awesome awesome

regards
abhi

 

[hilfy]

This type of question is more likely to be answered in the Business Objects solution forum as the forum here is specifically for Crystal Reports.

Having said that, here is some info.

The universe handles the connection to the database, so you can't use ODBC to connect to it. A universe is not a database, it is a meta-data layer between the user and the database that hides the complexity of the tables and how they're linked together. In the BO tools, users can drag and drop fields and filters from the universe into a query panel and the tool will use the information from the universe to build the SQL query for the report.

There are ways to use the SDK to update the universe but I don't know of any way through the SDK to connect to a universe and use it to build a query.

-Dell

A computer only does what you actually told it to do - not what you thought you told it to do.