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.