CMS Query Builder

CMS Query Builder is a tool for building CMS queries, running them against the database and exporting the result to excel spreadsheet.

  • Running queries and exporting result to Excel and CSV.
  • Predefined templates of SQL queries.
  • Placeholders for <kind>, <object>, <folder> are automatically replaced with a selected item.
  • List of object kinds.
  • Easy selection of an object or a folder from a tree.
  • Word auto-completion for key words, field names, and table names.
  • Possibility to customize┬átemplates, words for auto-completion etc in configuration files.
  • Command line interface.

Prerequisite:

You need to have SAP BusinessObjects 3.1/4.x Client Tools on your machine.

Downloads:

CMS Query Builder for BO 4.x (cmsquerybuilder-bo40sp1-1.4-20170819.zip)

CMS Query Builder for BO 3.1 SP5+ (cmsquerybuilder-bo31sp5-1.4-20170819.zip)

CmsQueryBuilder.pdf

Support:

Discussion

support@biclever.com

Screenshots:

CMS Query Builder - Login

CMS Query Builder - Main panel

CMS Query Builder - Template Selection

CMS Query Builder - Object Selection