ClearDB Documenter 4.6

ClearDB Documenter 4.6 is a unique Oracle database documenter. It generates complete and detailed documentation of Oracle databases up to 12c. It documents 59 database object types, their status and dependencies, the structure and source code modules.

The illustration of the database includes Entity Relationship (ER) and Reference & Dependency (R&D) diagrams as well as Flowcharts, Call Tree diagrams, CRUD matrices of PL/SQL code – all „clickable”.

ClearDB Documenter 4.6 performs a comprehensive and detailed Database Security Audit of the Oracle database. A comprehensive report, as part of a Docu (database documentation) with detailed description of vulnerabilities, their severity, and places where they were detected. 29 built-in policies and over 600 checks ensure your database is thoroughly examined and security issues are located.

No other tool currently on the market is capable of providing similar functionality. ClearDB Documenter sets a new standard for software generated database documentation of Oracle databases.


β€žIt is about creating a secure database and storing critical and valuable data securely!β€œ

Peter Finnigan, UK

Our Oracle Database Security expertise

Click here to
FREE docuVIEWER Download sample Docu
  • sample Docu incl. 2 schemas
  • comparison sample Docu and DB
Release HistoryCompany Flyer ClearDB Documenter 4.5
Oracle Magazine Sep/Oct 2015

ClearDB Documenter 4.6
Advanced Database Documenter for Oracle

ClearDB Documenter 4.6 easily and quickly documents a complete set of 59 schema (tables, views, procedures, functions, packages, types, triggers, etc.) and non-schema (contexts, directories, profiles, users, roles, etc.) object types with all their properties, DDL, privileges, synonyms, references, dependencies, source code as well as database instance properties, options and initial parameters for Oracle versions up to 12c.

  • easy navigation within the Docu (database documentation) - all is clickable; filter for specific information, extract part of a Docu and email it
  • performs a powerful and comprehensive security assessment of the Oracle database, checking for over 600 potential security risks; and generates a detailed report summarizing all violated checks
  • summarizes hundreds of previously generated Docus in a one page Docu Summary Report, providing information about DB Status, PL/SQL Parser Status, Code Metrics of PL/SQL source code, Naming Rule violations for 59 Oracle database object types (12c), etc.
  • updates the content of previously generated Docu by synchronizing it with its source database
  • compares two Docus or a Docu with its source database (or any other), generating a detailed comparison report
  • provides Code Audit and Code Metrics reports for stored objects; code errors, code review rule violations and other PL/SQL code anomalies
  • illustrates a database as ER and R&D diagram and its PL/SQL objects as Flowcharts, Call Tree diagrams, CRUD matrices; at all levels and clickable
  • applies user-defined templates to generate tailor-made Docu with a single click;
    database -> schemas -> object types -> objects
  • automates Docu generation via its integrated Job Manager
  • database documentation is created as interactive and portable HTML documentation and can be viewed using popular web browsers
  • views a Docu in a proprietary Docu viewer with an ability to open password protected Docus, generate and regenerate diagrams at all levels, and summarize numerous previously generated Docus

ClearDB Documenter 4.6 is bundled with a set of powerful features to automate Docu generation by using integrated scheduled jobs; update the content of a Docu by synchronizing it with the database; compare a Docu with a database or with another Docu and vice versa; extract database DDL from a Docu; extract a subset from a Docu; generate a new Docu based on the content and options settings of a previously created Docu.

ClearDB Documenter 4.6 checks an Oracle database for more than 600 potential security risks. A detailed report summarizes all violated checks. The output is grouped into POLICIES and CHECKS and provides detailed information about observed issues. The report can be filtered and sorted, e.g. by 4 SEVERITY categories.

ClearDB Documenter 4.6 is powered by a PL/SQL code Analyzer that reviews, measures, and checks the quality of Oracle PL/SQL used in stored objects and makes recommendations for a better coding style. Additionally, each stored object is analyzed for its structure and architecture. A set of industry standard quality control metrics about the code is generated to identify error prone areas based on complexity, size and modularity.

ClearDB Documenter 4.6 helps to keep PL/SQL code reliable, testable and manageable. Industry accepted complexity measures (McCabe, Halstead and Maintainability Index) are used in the application. The code review module identifies over 70 common coding mistakes and makes suggestions for good programming practices. Using ClearSQL's engine, a detailed database observation report is included in the Docu as well. It includes Parser and DB errors and anomalies, alerts, and warnings.

To learn more about ClearSQL and its Code Review rules, click here to open a description page showing all current Code Review rules in ClearSQL.

ClearDB Documenter 4.6 is the only Oracle database documenter known today that provides PL/SQL code analysis, visualizing Oracle databases creating R&D (references and dependencies), ER (entity-relationship), Flowcharts and Call Tree diagrams, CRUD matrices and, at the same time, creating advanced database documentation (59 object types). Oracle DBAs, developers or consultants may use it to quickly explore an Oracle database - its structure, database objects, code, and anomalies - offline using standard browser! (no database access is required).

Running an Oracle database without comprehensive, accurate and up-to-date database documentation is like trying to explore a large metropolis without a city map.