ClearDB Documenter 4.7 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.7 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 630 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.
Open Sample Docus Online
Release HistoryCompany Flyer
- sample Docu incl. 2 schemas
- comparison sample Docu and DB
ClearDB Documenter 4.7 Screenshots
ClearDB Documenter output documents
ClearDB Documenter produces three different types of output documents:
Docu — database documentation — documents and illustrates a database
and 59 Oracle database object types
Docu Comparison Report compares two
Docus or a Docu
and a Database and creates a detailed report
Docu Summary Report (beta) summarizes multiple
Docus and links them to a summary report
The Docu Overview page represents Docu
content at a glance. It is a permanent root node of a Docu.
The content is grouped by schema and non-schema object types. The database objects are shown
with their current database object statuses and Code Analyzer statuses.
Database Security Audit totals are shown in a separate table, grouped by severity levels.
For better representation, the summary information is also shown in graphs.
Database, Analyzer, and Security Observations
ClearDB Documenter has a set of features to
detect possible error prone procedures and unsafe places in your database,
gives recommendations for a better coding style, helps to keep PL/SQL
code more reliable, etc., outlining all detected issues in an output
Docu (database documentation).
DB Object relationships in diagrams
ClearDB Documenter has a feature to illustrate a
database as R&D (References and Dependencies) and ER (Entity-Relationship)
diagrams at three levels: Database -> Schema -> Object. All clickable.
Supported formats: GIF, PNG, JPEG, and vector SVG.
A Docu Comparison Report
consolidates in one document comparison information on two previously generated Docus
or a Docu and a Database. Comparison is performed by
three categories: Database Properties, Database Objects, and DB Security Audit.
A hierarchically structured Report Tree allows viewing comparison results at all levels:
database -> schemas -> object types -> objects.
Including detailed Docus in the report is optional and can be defined
in the generation settings in ClearDB Documenter:
Docu vs. Docu: both previously
generated Docus will be included
Docu vs. DB: the previously generated
Docu will be included along with a new Docu
of the database that will be generated at the time of generating the comparison report
Docu Summary Report (beta)
A Docu Summary Report (beta) is a perfect aid when it
comes to dealing with loads of previously generated Docus (database documentation).
This one page summary report provides information about all database object types, existing in any
of the summarized Docus, including the following details:
- their DB Status; e.g. valid, invalid, disabled
- their PL/SQL Parser Status; e.g. errors and alerts
- Code Metrics information of PL/SQL source code
Naming Rule violations for 59 Oracle database
object types (12c)
- DB Security Audit Report information grouped in four severity groups (over 630 security checks)
The summary report has the same structure and look&feel as a standard Docu
and can include summary information for an unlimited number of previously generated Docus.
Start ClearDB Documenter — Welcome
ClearDB Documenter is a powerful and easy-to-use graphical interface
for producing three different types of output documents — Docu,
Docu Comparison Report, and Docu Summary Report (beta)
— in a few clicks. For ease of use, its GUI is based on step-by-step wizard technology.
On the Main page, displayed on application startup, you can choose
what to do in ClearDB Documenter:
- generate a new Docu
compare two Docus or one Docu
and a database and vice versa
automate output document generation by using integrated scheduled jobs
actualize the content of a Docu by synchronizing it with
- extract database DDL from a Docu
- extract a subset from a Docu
generate a new Docu based on the content and options
of a source Docu
- view and manage Docu templates in the Template Manager
view and manage previously generated output documents in the
open an integrated tool docuVIEWER
Automate Docu generation using integrated scheduled jobs
ClearDB Documenter automates output document
generation via its integrated scheduled Jobs. Create Jobs for complex, time-consuming,
and long-lasting document generation, and schedule their execution in ClearDB Documenter during non-working hours.
Each document generation Job is widely customizable in terms of Docu
content, generation, and Code Analyzer options.
Previously generated documents with their descriptions and generation details are
displayed in the Docu table on the Docu
Manager page. The list is synchronized with the Docu list in
on the Docu Explorer tab.
Online Support Desk (OSD) — Contact us & Update software
OSD — Online Support Desk — is a built-in tool that gives
ClearDB Documenter users an easy way to automatically update
the software (OSD Updater) and directly contact Technical Support
(OSD Messenger) for help*).
*) Please be aware that customers with AMS (Annual Maintenance & Support)
coverage benefit from priority technical support and guaranteed minimum
response time to their OSD and email messages. The support team commits
to a response within 2 business days at the latest. In general, help can
be provided much more quickly. AMS customers also benefit from software
updates and new version releases at no additional cost.