Complete database documentation. Just 5 clicks away.
Analyze the complete database structure and create insightful reports. It's a profound security audit tool, too.
generating database documentation and creating reports

Smart. Secure.
Geekfully visual.

ClearDB Documenter is a revolutionary platform to generate comprehensive database documentation. And it's an audit tool, too. We included the database security audit engine right into the core, so now keeping your database secure and compliant is easier than ever.
ClearDB Documenter
Simplicity and detail you'll love.
  • Every detail counts
    Documenter analyses and reports on a complete set of 59 schema and non-schema object types with all their properties, DDL, privileges, synonyms, references, dependencies and source code.
    Database instance properties, options, and initialization parameters for Oracle versions up to 19c are included in the report, too.
  • create Visual Insights
    Documenter creates beautiful visual deliverables: R&D (references and dependencies), ER (entity-relationship), CRUD matrices, Flowcharts and Call Tree diagrams.
    Now you can take the generated reports offline to work on-the-go, together with all the visual contents. You can even collaborate securely — all Documenter reports are protected to avoid unauthorised access.
  • Locate the weak spots
    A Database Security Audit checks for over 630 potential security risks and generates a comprehensive Database Security Audit Report, summarizing all violated checks. The output is grouped into POLICIES and CHECKS and provides detailed information about observed issues. The report is structured to provide maximum insight into the most critical aspects of database security.
The light-bulb moments enabler.
ClearDB Documenter instantly delivers some truly professional insights for many different roles in a company. See how it can benefit you and enable you to perform better, deliver faster and manage risks.
System architects
Understand the database structure to boost the design of a new functionality, easily find ways to optimize existing instances and re-factor procedures, visualize tech processes for other stakeholders.
Database consultants
Save weeks analysing and documenting customer databases. Instantly create reports and assessments, pinpoint performance and scalability bottlenecks, deliver insightful roadmaps.
Information Security Officers
See the full picture of the database and its parameters, control orphaned accounts and privileges, regularly track exposures and use industry best-practices to fix the vulnerabilities found.
Let your inspiration flow.
Discover more amazing tools for Oracle professionals from Conquest.
  • SQLDetective
    A Swiss-army-knife of a PL/SQL developer. The smartest Oracle IDE out there.
  • ClearSQL Analyzer
    An ultimate validator and quality improvement tool for your code.

ClearDB Documenter 5

FEATURE TOUR

Getting under the hood.
Documenter analyses and reports on 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. Database instance properties, options, and initialization parameters for Oracle versions up to 19c are included in the report, too.
Make your code shine.
ClearDB Documenter visually indicates some important code quality stats: Cyclomatic Complexity (McCabe v(G)), Maintainability Index, Halstead Volume, Interface Complexity. These are the industry standards to measure your code, instrumental in improving large projects with many lines of code.
Manage the requirements.
ClearDB Documenter checks your PL/SQL code, its quality, format, compliance with standards and intelligently detects poorly written code. Tailor it to meet your company's requirements or use the presets from industry leaders.
It can fix errors in your code automatically, too.
Shed some light on changes.
Compare the generated report to the source database to see changes that took place in a database since you last documented it. The comparison runs at all levels: DB - Schema - Object Type - Object. The report is fully clickable, so your source code is always at hand.
"A-ha!" at first sight.
Documenter creates beautiful visual deliverables: R&D (references and dependencies) and ER (entity-relationship) diagrams, CRUD matrices, Flowcharts and Call Tree diagrams. Now you can even take the generated reports offline to work on the go, together with all the visual contents. All Documenter reports could be protected to avoid unauthorised access.
Code it. Then audit.
A Database Security Audit checks for over 630 potential security risks and generates a comprehensive Database Security Audit Report, summarizing all violated checks. The output is grouped into POLICIES and CHECKS and provides detailed information about observed issues. The report is structured to provide maximum insight into the most critical aspects of database security, with explanations and fixing instructions.
YOUR OWN PROOFREADER.
ClearDB Documenter looks for areas in your code that require additional user attention. These include invalid, disabled, and wrapped DB objects, as well as alerts, errors, flagged code metrics, and naming rule violations. Detected issues are outlined in a separate section with a justification and improvement hints. Learn, see impact, take action! -- It has never been that easy.
For your eyes only.
ClearDB Documenter password-protects and encrypts its reports, so your analysis is kept under wraps. Full protection of the generated document is optional, while the DB Security Audit Report is always password protected.
And there's a free companion tool — docuVIEWER, so that your team and partners could collaborate. It's great for managing and exploring documentation offline and allows disconnected use of database and security audit reports. It generates stunning instant diagrams, creates report summaries, and has many more features to increase your productivity.
All docs in one basket.
ClearDB Documenter can store any files right within the report. No more lost mails, missing accounts or forgotten docs. Make all the corresponding files instantly available to the team by including them in a report.

ClearDB Documenter 5

Learn about the latest updates for ClearDB Documenter.
  • Custom rules editor
    Easily create your own code review rules with XPath syntax in a Code Insight-powered editor.
  • 170+ built-in rules for code analysis
    Expert-crafted set of rules based on industry's best practice. The richest rules selection out there.
  • Attachments and comments
    Attach any files or text comments to objects in generated reports. Attachments are stored inline in the report.
  • Standalone DB security report
    Database security audit report is now available in the standalone mode. This is extremely helpful for GDPR-reporting activities.
And more

  • Tabbed interface for reports implemented. It's now easier to work with several sections of report at once.
  • Object List mode is now available for reports, dramatically decreasing loading time with sorting and filtering.
  • Added the ability to define severity levels for the rules: Critical, Major, Minor, and Trivial.
  • Option to extract DDL using Oracle's DBMS_METADATA.
  • Revamped UI and visualization engine.
  • ClearDB Documenter is now available in 32- and 64-bit.

Even more details on the release are available in ClearDB Documenter 5.0.1.467 release notes.

Published date: December 20, 2018
    Documentation
    See the manuals, instructions and whitepapers.
    1
    SYSTEM REQUIREMENTS: WORKSTATION
    free space
    250 MB free space
    Microsoft Windows
    Microsoft Windows 7 and above
    Browsers
    IE 9.0+, Firefox, Chrome
    administrator privileges
    administrator privileges
    Redistributable Packages
    Microsoft .Net Framework 4.0+, Visual C++ 2008 and 2015 Redistributable Packages (will be installed if missing)
    2
    SYSTEM REQUIREMENTS: ORACLE ENVIRONMENT
    Oracle Client
    32- or 64-bit Oracle Client 9+
    Oracle Database
    Oracle Database 9i-19c