Sobre o ClearDB Documenter

Documentador de bancos de dados Oracle avançado.

ClearDB Documenter is a platform to generate comprehensive database documentation. It analyzes 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.

  • 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.
  • 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.
  • 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.
  • 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.
  • Documenter creates 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.
  • 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.
  • 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.
  • 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.
  • 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.