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
WHAT IS ORACLE SECURITY?
„It is about creating a secure database and storing critical and valuable data securely!“
Pete Finnigan, UK
Our Oracle Database Security expertise
Click here to read more...
Release HistoryCompany Flyer
ClearDB Documenter 4.5
- sample Docu incl. 2 schemas
- comparison sample Docu and DB
Oracle Magazine Sep/Oct 2015
ClearDB Documenter 4.7
Advanced Database Documenter for Oracle
The development and management of Oracle-based applications is becoming an increasingly complex and tedious task.
ClearDB Documenter 4.7 enables you to accomplish these tasks faster and more efficiently by providing a
powerful and easy-to-use interface to create Oracle database documentation.
ClearDB Documenter 4.7 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 initialization parameters for Oracle versions up to 12c.
ClearDB Documenter 4.7 Key Features
Generates complete and detailed database documentation (Docu) for any Oracle database;
supports Oracle 9 -> Oracle 12c
Supports a complete set of 59 schema and non-schema object types for Oracle (= 12c)
Performs a powerful and comprehensive security assessment of the Oracle database, checking for over 630
potential security risks; and generates a detailed report, summarizing all violated checks
Provides Code Audit and Code Metrics reports for stored objects, code errors, code review rule
violations and other PL/SQL code anomalies
Includes a complex database observation report with Parser and Database errors, alerts and warnings,
and other database anomalies
Analyzes and documents PL/SQL objects, their source codes, statuses, references and dependencies
Reports Parser observations (syntax errors, PL/SQL warnings, and more...)
- Checks 59 Oracle database object types (12c) for Naming Rule violations
Illustrates a database as ER and R&D diagrams and its PL/SQL objects as Flowcharts, Call Tree diagrams,
CRUD matrices; clickable and supported at all levels: database -> schemas -> object types -> objects
Automates output document generation via its integrated scheduled Jobs (Job Manager); Templates are used
to generate a user-predefined Docu with a single click (Template Manager)
Excludes "heavy" time-consuming — perhaps not needed — items (e.g. Java Classes,
Public Synonyms, Recycle Bin, etc.) from the Database Object Tree and, therefore, from the
resulting document as well
Automatically refreshes the Database Object Tree with the actual content from the database to ensure
the resulting document is up to date
Ensures high security level for Docus by encryption and password
Compares a Docu against another Docu or
against its source (or any other) Oracle database and vice versa
Produces a detailed Docu Comparison Report, highlighting similarities
and differences of the compared Sources; easy filtering and content customization
Summarizes hundreds of previously generated Docus in a one page
Docu Summary Report (beta), providing
DB Status, PL/SQL Parser Status, Code Metrics of PL/SQL source code, Naming Rule violations
for 59 Oracle database object types (12c), etc.
Keeps records of retrieving/selection/loading of database objects
Updates the content of a Docu by synchronizing it with the source database
Extracts a subset from a Docu with the ability to remove database objects
and to change Docu options
Generates a new Docu based on the content and option settings of a
previously generated Docu
Views a Docu in a proprietary
with an ability to open password protected Docus, generate and
regenerate diagrams at all levels, and summarize numerous previously generated Docus
Generates output documents in an interactive and portable HTML format that can be viewed using popular web browsers
Sends a single Docu or a selection of Docus by email; zipped
- Provides an easy-to-use graphical interface based on step-by-step wizard technology
OSD (Online Support Desk) dramatically simplifies communication with Technical Support and keeps the
application up to date
Logs on to a database by using TNS, LDAP, and Direct type connections and remembers the
last connections for later reuse
- and much more…