ExtractCMS is a toolbox to analyze the content of your Business Objects XI repository. Since XI, there is no way to easily report on your BOXI metrics : documents, users, groups, security...
ExtractCMS allow you to get all of this, and drop it in a classical relational database. ExtractCMS is provided with a basic set of universe, and some standard reports. Then you can customize universe & reports to adapt ExtractCMS to your needs.
ExtractCMS is a program, you just need to add it to the platform (via the CMC) ; and then you just need to schedule the program execution. It's not a real time solution, but you can for example refresh your repository twice a day.
|Business Objects Compatibility||
|To install, need access to||
|Features||Lite Edition||Basic Edition||Enterprise Edition|
|Extract all types of objects (users, groups, universes, overloads, connections, WebI reports, Deski reports, Crystal Reports, Hyperlinks, folders, privates folders, inboxes, categories...) and the corresponding relations.|
|Extract most of metadata for each type of object (size of reports, CUID, ID, description, dates...)|
|Extract all explicit security applied on any type of objects above.|
|Comprehensive schema, with pre-build universe (customizable) ; and basics WebI reports.|
|Extract up to :||500 objects per table||100 000 objects per table||No limit|
|Compare CMS capability ? (Compare 2 or more CMS)|
|Historise results ? (View the progression of your platform)|
|Impact analysis between WebI reports and universes|
|Support (Need more support ?)||No support included||No support included||2 months of support included|
How analyze the BOXI repository ?
Since XI, there is no easy way to report on the CMS data. When you are managing a BOXI platform, your need to follow metrics, for example :
- How many documents are on my system, in favorites folders, in public folders ?
- How many MB my users are using on the FRS ? Get a TOP 10 ?
- Can I get a matrix table of my security (folder x group or universe x group) ?
Business Objects is providing an Audit tool, but it provide only events. There is no global solution to analyze the actual content of your full platform. It's why we have created this product. With ExtractCMS, you can easily answer the above question, and much more...
We are also providing you a basic universe, easy to understand, and fully customizable to your needs. Basics reports are also mainly expendable. You can then use the full power of the Business Objects tools to get the best of the data extracted by ExtractCMS !
With the Enterprise version, you have the possibility to extract several repository to the same database. For example, with 3 servers : DEV, ACP and PRD, you can extract all of them in the same export database.
Once done, you've got the opportunity to compare data between CMS. For example :
- Check the CUID of objects between platforms
- Check the security levels of objects
It can be an useful help to restore a platform at the state of another.
With the Enterprise version, it's also possible to save several extract of the same CMS in one database. But who needs that ?
Imagine you have to follow the performance of your platform. Performance is depending of number of users, number of documents... You've got some metrics in the Audit database. But you can complete this audit by some 'snapshot' of the CMS at different period of time. Program ExtractCMS to save a version each month ; and you've got an historical version of the CMS.
Caution ; this option can generate lots of data in the database. Please check and setup a rolling purge of old data.
The last option of the Enterprise version is an Impact Analysis tool between universe & Web Intelligence documents.
Imagine you need to remove objects from the universe. You will need to check every documents on the Production platform to check the object is not used before remove it. And when you've got a 10,000 documents (public & private) platform, it could be time-consuming...
We are providing an easy solution to answer this issue : ExtractCMS can inspect each Web Intelligence document on the platform (in public folder, private, inbox...) ; and retrieve all universe objects used. Then, when you need to check the usage of an object, you just need to refresh a query with the corresponding object.
The universe has been designed to allow easy reporting on the CMS. But in case of specific need, you can choose the alter the original design. There is no impact on the ExtractCMS tool (except on the Webi report you have designed).
Here is the report list :
Contact us to get a quote on this product.