SQL - CMS - BOXIR2SP1

Hi Guillaume,

It is not possible or recommended to directly query the BO XI repository.

BO has created a tool named the Query Builder (available in the admin launchpad), which is a web application available at this URL capable to query the BO XI repository:

- Access on JAVA: http://<SERVER>:<PORT>/businessobjects/enterprise115/adminlaunch/
- Access on .NET: http://<SERVER>:<PORT>/businessobjects/enterprise115/WebTools/

It is not possible to use other SQL statement that SELECT.

You can find some interesting information about the Query Builder in the following post:
Repository tables in XI

The only way to rename and/or delete a document is to build your own application (using BusinessObjects XI R2 SDK) or to use:

  • CMC (Central Management Console)
    or
  • InfoView

Regards,
:twisted: NoNoDiabolo.


nonodiabolo :fr: (BOB member since 2006-09-12)