The development and management of Oracle-based applications is becoming an increasingly complex and tedious task. ClearDB 3 enables you to solve these tasks faster and more efficiently by providing a powerful and easy-to-use interface to create Oracle database documentation.

ClearDB 3 documents a complete set of 54 schema and non-schema object types for Oracle up to version 11gR2:

Additionally, the user may include PUBLIC SYNONYMs, PUBLIC DATABASE LINKs and RECYCLE BIN objects in
the documentation.

ClearDB 3 helps to keep PL/SQL source code of stored objects (procedures, functions, packages, package bodies, object types, object type bodies, triggers) reliable, testable and manageable. Industry accepted complexity measures (McCabe, Halstead and Maintainability Index, MI) are used. The code review module catches over 60 common coding mistakes and gives suggestions for good programming practices. Its PL/SQL Parser supports up to 99% of SQL and PL/SQL keywords and reserved words. A set of quality control metrics about the code is generated to identify possible error prone procedures based on complexity, size and modularity.

ClearDB 3 empowers its users with a wide range of features to work with generated documentation such as: actualize the content of documentation by synchronizing it with the database; extract database DDL from the documentation with the ability to select object types to be extracted and to specify a number of output settings; extract a subset from documentation offline (no database connection needed) with the ability to remove database objects and to change documentation options; convert documentation offline to another format (HTML/CHM); generate new documentation based on the content and options of source documentation.

ClearDB 3 compares documentation against other documentation or against a database and vice versa and produces a detailed comparison report included as part of the resulting documentation. The comparison report highlights differences between Source and Target; lists the objects that exist in the Source but are missing in the Target and vice versa; lists objects that have major or any differences in their definitions and properties; lists objects that are identical in the Source or Target. Additionally it includes differences in database instant options and initial parameters in object differences.

ClearDB 3 automates documentation generation via its integrated scheduled jobs or via its command (batch) files scheduled in third party schedulers. Create jobs for complex, time consuming and long lasting documentation generations and schedule their executions in ClearDB 3 during non-working hours. Alternatively, it’s possible to save a job as a batch file and schedule it in a third party scheduler or execute it manually via the Windows Command Line. Each documentation generation job is widely customizable in terms of generation, documentation and Code Analyzer options.

• Generates complete and detailed database documentation for any Oracle database; supports
  Oracle 7 --> Oracle 11g
• Support for a complete set of 47 schema and non-schema object types for Oracle version up to 11gR2
• Analyzes and documents PL/SQL objects, their source codes, statuses, references and dependencies
• Automated code review reports parser observations (syntax errors, PL/SQL warnings, and more...)
• PL/SQL Parser (Analyzer) supports up to 99% of SQL and PL/SQL keywords and reserved words
• Includes PL/SQL code diagrams (Flowchart, Call Tree, CRUD1, CRUD2) in the database documentation
• Includes Code Metrics information of PL/SQL code
• Includes a "Code Audit" page for each stored object
• Includes a database observation report with Parser and Database errors, alerts and warnings
• Includes a complex report about Database errors or Database anomalies
• Compares documentation against other documentation or against a database and vice versa and produces a detailed comparison report
• Extracts ready-to-use database DDL from documentation with a variety options
• Automates documentation generation via its integrated scheduled jobs or via its command (batch) files scheduled in third party schedulers
• Actualizes the content of documentation by synchronizing it with the source database
• Extracts a subset from documentation with the ability to remove database objects and to change documentation options
• Converts HTML documentation offline to CHM format and vice versa
• Generates new documentation based on the content and options of source documentation
• Generates documentation in HTML (default format) and CHM formats
• Sends a single or a selection of documentation from History by Email, zipped
• Provides an easy-to-use graphical interface that is based on step-by-step wizard technology
• 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 last connections for later reuse

 

Conquest Software Solutions keeps busily working to improve the functionality and quality of ClearDB 3.

Conquest Software Solutions offers powerful kits to extend the reach of ClearDB 3. They provide features to automate documentation generation via scheduled jobs and to compare two sets of documentation or documentation and a database and vice versa.