New features

• Compare two sets of documentation or documentation with a database!
  Compare two sets of documentation or documentation and a database and vice versa and produce a detailed comparison report included as part of the result documentation. The comparison report highlights differences between the Source and the 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 the Target. Additionally, it also includes differences in database instant options and initial parameters in object differences.
• Automate documentation generation by using integrated scheduled jobs!
  Automate 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 generation and schedule their execution in ClearDB Documenter 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.
• Actualize the content of documentation by synchronizing it with the database!
  Actualize previously generated documentation with a few steps to ensure that its content is always up-to-date and synchronized with the database. It updates properties, DDL source, references, dependences, etc. of database objects included in the selected documentation and produces a new updated version of the selected documentation. You will not be able to change neither the documentation object selection nor the documentation, Code Analyzer or generation options.
• Extract database DDL from documentation!
  Extract database DDL from documentation (included optionally) with the ability to select object types to be extracted and to specify a number of output settings. In case of a database crash, ClearDB Documenter gives you a chance to recover the database by using the database DDL extracted from the documentation. Object DDL for each object is included in the documentation by default. DDL inclusion can easily be enabled or disabled at the documentation or object type level.
• Generate new documentation based on the content of source documentation!
  Generate new documentation based on the content and options of source documentation. After selecting the source documentation, at the next step, all of its database objects and documentation and Code Analyzer options will be loaded to the GUI. You can easily change the database object selection as well as documentation, generation and Code Analyzer options in the appropriate steps. This feature dramatically speeds up the documentation setup and definition process.
• Convert documentation to another format!
  Convert documentation to another format (HTML/CHM) offline. If the selected documentation was generated in HTML format, using this feature, you can easily convert it to CHM format and vice versa. You will not be able to change neither the documentation object selection nor the documentation, Code Analyzer or generation options.
• Extract a subset from documentation!
  Extract a subset from documentation offline (no database connection needed) with the ability to remove database objects and to change documentation, Code Analyzer and generation options.
• New GUI and wizard layout with its handy Feature Navigator!
  A new, easy to use, graphical user interface (GUI) for simplifying drilling down the features and accelerating navigation in step based wizard pages. A new tree-like Feature Navigator exposes the main features and their steps, highlights the active feature and its completed and not completed steps, showing them with specific icons. For ease of use, access to the main features is also available via nice, visible large buttons in the Main page.
  

Other significant enhancements and improvements:

• Support for a complete set of 54 database object types up to Oracle DB 11gR2:
  CLUSTER, CONTEXT, DATABASE DESTINATION, DATABASE LINK, DIMENSION, DIRECTORY, EDITION, EVALUATION CONTEXT, FILE_WATCHER, FLASHBACK ARCHIVE, FUNCTION, MATERIALIZED VIEW, MATERIALIZED VIEW LOG, RULE, RULE SET, INDEXTYPE, GROUP, JAVA CLASS, JAVA SOURCE, JOB, LIBRARY, OPERATOR, OUTLINE, PACKAGE, PACKAGE BODY, POLICY, POLICY GROUP, PROCEDURE, PROFILE, QUEUE, ROLE, REFRESH GROUP, RESOURCE CONSUMER GROUP, RESOURCE PLAN, RESTORE POINT, ROLLBACK SEGMENT, SCHEDULER CHAIN, SCHEDULER CREDENTIAL, SCHEDULER JOB, SCHEDULER JOB CLASS, SCHEDULER PROGRAM, SCHEDULER SCHEDULE, SCHEDULER WINDOW, SCHEDULER WINDOW GROUP, SEQUENCE, SYNONYM, TABLE, TABLESPACE, TRIGGER, TYPE, TYPE BODY, USER, VIEW, WINDOW GROUP
• New option to break the generation process on any error.
• The state of documentation generation, documentation comparison, extraction of database DDL and a subset of documentation, etc. displayed in the progress window is also shown in the Windows 7 Taskbar.
• Improved content of DB Link and External Table types objects properties.
• DB Link type objects include synonyms to dependencies.
• Highlights Java Source code using Java code syntax highlighter.
• A call tree invoked from the CRUD matrix shows all analyzed objects which use the selected dataset object.
• Added support of the following database object types: RULE, RULE SET, EVALUATION CONTEXT, GROUP
• New option to include objects DDL in documentation at global non-object type and individual object type levels.
• Documentation Manager displays a ClearDB Documenter version number used for documentation generation.
• New option that controls inclusion of documentation options in a log.
• The Database Object Tree saves database object selection to file for later re-use.
• A number of generation, documentation content and GUI bugs fixed.

• Supports a complete set of 47 schema and non-schema object types  for Oracle versions up to 11gR2:

  CLUSTER	POLICY	FLASHBACK ARCHIVE
  CONTEXT	POLICY GROUP	MATERIALIZED VIEW
  DATABASE LINK	PROCEDURE	MATERIALIZED VIEW LOG
  DIMENSION	PROFILE	REFRESH GROUP
  DIRECTORY	QUEUE	RESOURCE CONSUMER GROUP
  EDITION	ROLE	RESOURCE PLAN
  FUNCTION	SEQUENCE	RESTORE POINT
  INDEXTYPE	SYNONYM	ROLLBACK SEGMENT
  JAVA CLASS	TABLE	SCHEDULER CHAIN
  JAVA SOURCE	TABLESPACE	SCHEDULER CREDENTIAL
  JOB	TRIGGER	SCHEDULER JOB
  LIBRARY	TYPE	SCHEDULER JOB CLASS
  OPERATOR	TYPE BODY	SCHEDULER PROGRAM
  OUTLINE	USER	SCHEDULER SCHEDULE
  PACKAGE	VIEW	SCHEDULER WINDOW
  PACKAGE BODY		SCHEDULER WINDOW GROUP

• Includes PUBLIC SYNONYMs, PUBLIC DATABASE LINKs and RECYCLE BIN objects to documentation.
• Incorporates NEW PL/SQL Parser Generation. Analyzer now supports up to 99% of SQL and PL/SQL keywords and reserved words.
• Generates documentation in HTML format (default format) through a new setting to define the preferred HTML browser to open documentation.
• Generates CRUD2 type matrix on schema level.
• New Documentation Options is split into Object Options, Code Analyzer and Observation Report sections. The new tree-like object type options navigator simplifies access to the options of a specific object type. For easier navigation the Object Type Options tree is sorted in the same way the Database Object Tree is sorted.
• Sends one or a selection of documentation from  History by Email, zipped. It simplifies sharing of multi-file HTML and «suspicious» CHM format documentation.
• Logs on to a database by using LDAP and Direct connections.

• New and significantly improved graphics engine generates flowchart and call tree diagrams and CRUD matrices faster and more accurately.
• New optional «Overview» page explains documentation structure to help new users accelerate learning.
• New option (enabled by default) to show Code Audit information (Code Review, Structure View, Code Metrics, Flowchart, Call Tree, CRUD1) in object sub-nodes.
• New options to sort the Database Object Tree logically (enabled by default) or alphabetically. To be consistent, the setting is automatically applied to the Object Type Options Tree and Output Documentation Tree.
• New connection setting «DB type» helps the users organize their DB connections in groups; e.g. DEVELOPMENT, PRODUCTION, TEST and others. Assigns background and foreground colors to easily identify them while working with the contents of a mission critical database.

• Added a prompt on enabling the "Generate Observation Report Only" setting
• Hides unused options if the "Generate Observation Report Only" is enabled
• Added a "Documentation content" line to the Log window
• Adds file extension to documentation file if missed
• Prompts on documentation file overriding
• Displays a warning message if the user is about to expand the whole object tree
• Disables the "Hide system schemas" and "Hide empty items" settings when the "DB properties only" option is enabled
• Disables all unused "Documentation Options" tabs when the "Generate DB only" option is enabled
• Displays "SYSDBA/SYSOPER" in "Connection String" of the Documentation Summary page
• Does not show unused documentation options in Log and in the documentation settings summary page
• Error number of Code Audit is a link to the object source code
• Extended the list of system schemas
• Displays a long template name as shortened with the full name in the tab's hint
• A table width of list of objects and observations fits to the documentation page width
• Sorts the Metrics list by subroutine's name with the GLOBAL line at the first line
• Adds "CREATE OR REPLACE" to the stored object source code
• Improved Observation Report object type nodes names and captions

• Raised an "Access violation" error on Step #5 if connection to a database was skipped on Step #2
• Sometimes standalone programs and functions in the flowchart page were wrongly treated as a package subroutines
• Could raise an "Access violation" error while frequently clicking the "Next" button
• Did not make a backup copy of the unlock key on applying the changes in Preferences
• The Statistic pane on Step #3  did not show info if not all objects of a type folder were selected
• An invalid object's icon was not red in the 'Problem Observations' page
• A schema name was missing in Total of the object summary table
• Renaming documentation file to the same filename removed it from the Doc. History list
• Could not rename documentation file in the Doc. History list when it was open
• Wrong source code of a schema trigger
• Sorting by file size worked incorrectly in the Doc. History list
• Template file name was shown without full path in the settings summary page
• Some GUI controls were displayed incorrectly on 120 dpi mode
• The newly saved template was not become opened and active
• If no template is loaded don't show any template name on the templates tab
• System schemas were selected when the user disabled the "Hide system schemas" option
• The last lines of Log were hidden under the bottom border of the Log window after generation
• Removed odd highlighting and underlining effects in the Object Tree
• The newly saved template was not saved in the template list
• Template deletion did not close the deleted template
• Wrongly generated "Observation Report" when the "Generate DB only" option was enabled
• All Object Tree nodes were collapsed after disabling the "Hide System Schemas" option
• Documentation generation failed on Instant Client and XEClient