ClearDB Documenter is an all-in-one tool for documenting Oracle Databases that includes robust code analysis capabilities and a security audit engine.

ClearDB Documenter supports 59 schema and non-schema object types and can collect information such as object properties, DDL, their source code, database instance properties, parameters, and more. It works with data at four system levels: Database, Schema, Object Type, and Object.
In addition to its robust documentation capabilities, ClearDB Documenter includes a built-in Code Analyzer that serves multiple purposes. Code Illustration draws diagrams and matrices based on relations between code elements (Flowcharts, Call Trees, CRUD) and DB objects (R&D, ER diagrams). Code Review checks PL/SQL against predefined rules, detecting syntax and logical errors, poor programming practices, orphaned objects, legacy code, and more while providing recommendations on how to improve the code. Code Metrics calculates systems maintainability and complexity based on industry-standard measurements.
ClearDB Documenter also runs a policy-enforced security audit of an Oracle database, scanning it against 630 potential risks. The audit results are outlined in a report, always password protected on a mandatory basis. ClearDB Documenter also compares two database reports or an existing instance snapshot with its current state to indicate differences and changes. The comparison is carried out at four levels (DB, Schema, Object Type, Object) and includes Security Audits as well.
To optimize user experience, ClearDB Documenter comes with docuVIEWER. docuVIEWER is a tool that allows users to open password-protected reports and draw instant diagrams. It is also available as a FREE standalone app.
Overall, ClearDB Documenter is an essential tool for any Oracle database user concerned with documentation, code quality, security, and efficiency. Its numerous features make it one of the best software tools available for Oracle database documentation and security auditing.
Version 5.0.1.467: N/A