CMS DBX (ADMINTOOLS 2.0)

Problem:

Query CMS DB:

CMS DB is encrypted and can't be queried by conventional SQL tools.

BOBJ SDK (AdminTools) doesn't support full ANSI SQL, partly compensating it with proprietary syntaxis. Still, many things can't be queried.

AdminTools output is a tree-like table HTML, which is unsuitable for efficient analysis, especially for bag stored properties.

No simple interface to perform custom actions (delete, enable, reset passwords…) on a custom set of objects from the above query.

No simple interface to run RESTful calls.

Features and usage:

Query CMS DB from BiWhy and get results in an automatically generated object tree or table.

Use one of more than 20 templates (growing list) for a quick start or learn about BOBJ-specific syntaxis. Where required, templates are provided with comments and links for further readings.

Filter in place and analyze results in tree/table/char views.

Convert to a flat table and export to excel (in the process).

Interface allows quickly adding custom actions for one or mass object processing. We will be adding them on demand.

RESTful actions.

Derivative properties, calculated on the fly. Example: Duration for WEBI reports.

Example:

A customer wanted to fetch a list of disabled users. They were doing it manually, as they haven’t found a way to filter it in AdminTools.

The process took hours (small system and there are systems with hundreds of thousands of users).

With BiWhy it took only a few seconds, without any development.