New features with v3.5.10: - DDL: allowed SQL syntax from LucidChart (i.e. without CONSTRAINT keyword for PRIMARY KEY) for Oracle, SQL Server, MySQL, and Postgres - DDL: allowed reverse-engineering of business names with spaces - Excel: allowed import of Excel without container GUID - Parquet: added support for reverse-engineering from Azure Blob Storage New features with v3.5.9: - Consistent positioning of dialog OK/Cancel buttons according to Windows UI standard - CLI model comparison no longer requires a container - Cassandra: reverse-engineering filters out system tables - Cosmos DB with SQL API: support for Control Pane via REST API in addition to Data Pane via new SDK - Glue: added Set data type, classification property, SerDe parameters, and table properties - Hive: NoSasl connection no longer requires Kerberos modules on Mac - Parquet: added possibility to reverse-engineer files from AWS S3 - Swagger/OpenAPI: added possibility to de-activate resource/request/response so it appears commented in documentation file New features with v3.5.8: - Added collapse/expand all options to Object Browser contextual menu - Fixed width of keys in ERD for Cassandra when partition key is also a foreign key - Respect sequence keys in Cassandra tree view - Fixed Kerberos library for Hive on Mac New features with v3.5.7: - Fixed reverse-engineering from database instances New features with v3.5.6: - Added display of index info in tree view - When generating JSON Data numeric with no sample, now uses pseudo-random function so data does not change each time - Created plugin for Apache Parquet - Cassandra: added connection to DataStax Apollo on Constellation - Neo4j and TinkerPop plugins: added reverse-engineering of JSON documents and JSON Schema - Swagger/OpenAPI: added possibility to reference another API file New features with v3.5.5: - Created plugin for AWS Glue Data Catalog - Added reverse-engineering of DDLs, XSDs, JSON docs, and JSON Schema as model definitions (in case of OpenAPI as schema components) - Added CLI command revEngDDL for reverse-engineering of DDLs from command line - Swagger/OpenAPI: added reverse-engineering of definitions/components not referenced in API New features with v3.5.4: - Graph plugins: implemented force-directed layout algorithms with spring-like attractive forces, see example: https://bit.ly/341x5l0 - Graph plugins: enhanced orthogonal distribution of ERD view - Avro: added support for namespaces in data types - Avro: corrected name of record data type - OpenAPI: improvement of components reverse-engineering for ISO20022 Payment Processing APIs - DDL: added support for Informix dialect New features with v3.5.3: - Graph plugins: added graph toolbar toggles to View menu - Implemented Electron security recommendations for framework foundation - Oracle DDL: improved handling of Foreign Keys so as to allow importing of Informix DDLs as well - Excel: fix 'cannot read property reduce of null' error on import - MongoDB: add use to script - Swagger/OpenAPI: add validation prior to reverse-engineering New features with v3.5.2: - Command-Line Interface: added command to reverse-engineer JSON Schema and JSON documents - CLI: added argument to reverse-engineer script files (MongoDB validator, Cassandra CQL, Hive HQL, Avro schema, Neo4j Cypher, Swagger documentation, etc...) - CLI: added argument to forward-engineer JSON Schema or sample JSON document. For JSON Schema, included choice to reference or resolve definitions, and optionally to update external references - ERD view: increased size of of horizontal and vertical scroll bar handles - Avro: added possibility to display and forward-engineer schema or encoded for Confluent Registry - Avro: added possibility to display and forward-engineer schema with standard indentation or minified - Avro: added handling of Java-generated classes - JSON Schema: added possibility to display and forward-engineer schema with standard indentation or minified - Graph plugins (Neo4j and TinkerPop): added possibility to reverse-engineer: DDLs, XSDs, and Excel template - Graph plugins: implemented separate positioning of objects for graph view and ERD view New features with v3.5.1: - Added possibility to duplicate a node/vertex label to represent recursive relationship/edge type as a line instead of a loop - Added decorative symbols (annotation) to the graph diagram (Neo4j & TinkerPop) - Added copy/paste of related relationship/edge labels when copying/pasting node/vertex labels - Added toggle to display relationship type names along the lines vs always horizontal - Added ability to select all node labels to move to another database - All targets: added indicator in ERD when an attribute is a reference to a definition: i for internal, m for model, and e for external - Improved rendering performance of tree view for large models - Added refresh button in Properties Pane for external reference - Added support for custom $schema - Fixed release of concurrent seat in case of orphan processes - All plugins: mapped plugin data types to standard JSON data types for JSON Schema forward-engineering - Avro: fixed field order of Avro schema in case of complex data types with choices - Avro: JSON data sample: now takes into account logicalTypes - Avro: JSON data sample: when null is first data type, take into account next data type, including in case of complex data type - OpenAPI: fixed deletion of resource/request/response - TinkerPop: added support for SSL and SSH in reverse-engineering New features with v3.5.0: - Added support for TinkerPop graph computing framework with Gremlin graph traversal - Many graph database UI enhancements, for Neo4j and upcoming TinkerPop, Amazon Neptune, and others... - Display node label controls on mouse hover only - Added tooltips to node label controls - Added relationship type highlight and controls on hover - Added control to reverse relationship direction - Added focus on relationship type name in properties pane when creating - Added possibility to create node label together with relationship type by clicking on relationship button then clicking again in workspace - Fixed centering of relationship type name - Added selection of relationship type by clicking on its name - Added default node label size, node label color, and relationship type line thickness in Tools > Options - Added checkbox "Apply to all in model" to the popups for node label size, node label color, and relationship type line thickness - Added toolbar button to toggle opening of all property boxes - Added independent opening/closing of properties boxes - Added toolbar button to toggle showing of all relationship names - Added graph diagram to Print Diagram - Added opening of properties boxes with fit to content - Added easy copy/paste of all properties between 2 node labels - Added decorative symbols to the graph view - Avro: changing data type maintains description and comments - Avro: added precision and scale to script New features with v3.4.12: - Enhanced undo/redo performance, handling in Object Browser, moving containers in graph view - Added handling of undo/redo in reference definitions - Added handling of copy/paste of external definitions - Improved performance opening large models and rendering ERD with large number containers and nested structures (still needs improvements on tree view) - Added last 10 actions of undo stack to uncaught error reporting - Fixed an issue when a simple JSON Schema data types reversed with properties - Fixed multiple copy-pasted collections haven’t colors from source collections - Avro: added forward-engineering of logicalType when multiple data types - Avro: filtered redundant pattern property in forward-engineering - Cassandra: split table options blob into separate properties New features with v3.4.11: - JSON Schema reverse-engineering: added handling of array items with empty objects - JSON Schema/JSON Doc/DDL/XSD/Mongoose reverse-engineering: extended error modal with log information - Tree view: fine-tuning of right-click for contextual menu - Avro: added display of non-null data type sample in JSON Data New features with v3.4.10: - Print Diagram: made generation independent of Windows DPI display settings (scale and layout) - MongoDB: updated view pipeline when referencing a definition - Swagger: use example property to generate Swagger samples New features with v3.4.9: - Added scrolling for long lists of definitions - Avro: removed false positive on validation of records - Avro: enhanced JSON Data sample generation logic - Avro: replaced spaces by underscore during reverse-engineering of JSON Schema title and field names - Excel: adjusted import logic of definitions when target is Swagger/OpenAPI New features with v3.4.8: - Print Diagram: added headers and footers to PDF - Print Diagram: added selection and/or range of pages to print - Print Diagram: added zoom control and fit to single page - Excel: improved handling of entity/attribute name split New features with v3.4.7: - Enhanced error logging to include undo actions - ERD: added text decorative symbol - Avro: added data type mapping when forward-engineering JSON Schema New features with v3.4.6: - Added contextual menu on multiple selections - Object Browser: added single level expansion for relationships, and definitions - Undo/Redo: added handling of copy/paste of views and graph node labels - Avro: added handling of required property for choices - Avro: adjusted mapping of data types when reverse-engineering of JSON Schema - Avro: automatically make default property null when null data type is first of multiple data types New features with v3.4.5: - Object Browser: added single level expansion for containers, entities, attributes, and views - Avro: added mapping of JSON Schema string formats to corresponding Avro logical types New features with v3.4.4: - Avro: enhanced approach for nullable fields by re-introducing null data type, see Avro schema for more info - Avro: added handling of multi-type fields during reverse-engineering of JSON Schema and JSON documents New features with v3.4.3: - Added Undo (Ctrl+Z) and Redo (Ctrl+Y) functions - Added AutoSave toggle switch (OFF by default) with parameter in Tools > Options > General to control time interval in minutes - Added recovery of new unsaved model - Added release notes in application update dialog - Enriched error details in reverse-engineering connection dialog - Hive: support for http transport mode for LDAP and Kerberos authentication - Swagger: added handling of null data type during reverse-engineering of JSON/JSON Schema, and converting to string with default = "null" - OpenAPI: added handling of null data type during reverse-engineering of JSON/JSON Schema, and converting to string with nullable = true New features with v3.4.2: - Extended drag & drop capability to multiple selections - Enhanced Find function to add match case, match whole word, beginning/end/anywhere in word, type of object, next/previous navigation, session history - Added Find-and-Replace function - Mongoose reverse-engineering: added handling of sub-documents as internal definitions - Mongoose reverse-engineering: added support for Buffer and Decimal128 data types - License key status: added refresh button - MongoDB: added generic processing of different SRV record formats - MongoDB: replaced deprecated document counts method impacting performance - Mac: fixed selection of reverse-engineering files - Hive: added support for Kerberos Quality of Protection (QOP) values auth-int (integrity) and auth-conf (confidentiality) [https://tools.ietf.org/html/rfc1964] New features with v3.4.1: - Save/Open: use default path locations first time only in a session, then remember last location used in session - Fixed reverse-engineering of JSON data when special symbols are present - Mongoose forward-engineering: added handling of definition (reverse-engineering will be available in the next version) - Mongoose forward- and reverse-engineering: added choice to output in object notation New features with v3.4.0: - Added multiple selection in Object Browser, ERD and tree view for more productive copy/paste and delete: Shift+Right-click for contiguous, Ctrl+Right-click for non-contiguous - Added drag-and-drop from/to complex data types at a different level - Added lineage (aka impact analysis, aka where-used) for references plus denormalized keys and denormalized attributes - Added ERD visual for denormalized keys (targets of foreign keys) and denormalized attributes (targets of foreign masters) - Reformatted attribute path in JSON Preview validation pane - Added check for plugin updates at startup - Excel: split name of attribute in a column for entity name and a column for attribute name - Cassandra: added authentication through Java Key Store - Cassandra: filtered CQL script in documentation generation if table not selected - Hive: added authentication through Java Keystore - Avro: default must match enum values - Avro: display warning in ERD and tree view if default value does not match data types New features with v3.3.2: - Added target script (CQL, Avro Schema, etc.) to documentation, with toggle in Options - Added possibility to perform Reverse-Engineering from Menu in Overview screen - MongoDB: added possibility to import URI with SRV record - Excel: added merging of nested fields - Excel: converted erroneous boolean values to false - Excel: handled empty technical names during reverse-engineering - Avro: handled inline comments in configs - Avro: correctly handled spaces in attribute names during forward-engineering - Avro: enhanced logic for required fields with null allowed - Neo4j: fixed bug when right-click on node in tree view New features with v3.3.1: - Object with a validation error (default or example not respecting data type, invalid names, etc...) appear in red in Object Browser, ERD and tree view - Avro: integrated Avro schema validator to Avro Schema tavb - Avro: added 'Null allowed' property to complex types - MongoDB reverse-engineering: added logging and default for read preference parameter New features with v3.3.0: - Added support for OpenAPI 3 (plugin download required) - Excel: handling of column title for empty sheets - Avro: added styles for "null allowed" properties in ERD and tree view New features with v3.2.3: - DDL reverse-engineering: allow that Create Table statements are absent and that only Alter Table statements are present - When multiple data types, there should only be a single default property - Avro: added a property 'null allowed' so multiple data types (scalar) are not necessary to allow for backward/forward compatibility. For multiple data type with complex types, it even simpler: no Choice necessary - Avro: added handling via definitions for named types (records, enums, and fixed) New features with v3.2.2: - Excel export/import: added support for definitions (internal, model, and external) plus references to definitions - Swagger: added ERD toggle of details to filter out unused structures New features with v3.2.1: - Excel export: added checkbox for each config section - Excel import - Cassandra: added handling for primary and clustering keys - Added handling for collapsed nodes in tree view and model definitions - Cassandra: fixed losing keys separator - Swagger: removed CommonMark in extension values New features with v3.2.0: - Added generic export/import with Excel for all targets - Added multiple file selection in Reverse-Engineering of JSON documents, JSON Schema, DDLs & XSDs - Added using technical model name for file name in Forward-Engineering of JSON documents, JSON Schema - Fixed picking from field list on definitions tab - Cosmos DB w/ Mongo API: added reverse-engineering support for unique items, TTL indexes, stored procs, and UDFs - Cosmos DB w/ Mongo API: added reverse-engineering from Azure Cosmos DB Emulator via REST API - Filtered GUIDs from pattern properties in forward-engineering of JSON Schema - Single click to collapse expand complex structures in tree view New features with v3.1.1: - Added support for CommonMark (a.k.a. Markdown) in description and comment properties - Fixed handling of custom-defined properties in native targets - Allowed multiple selections in reverse-engineering of JSON documents, JSON Schema, DDLs, and XSDs - Fixed uncaught error in repetitive reverse-engineering of JSON documents - Added Unique Items in Cosmos DB collection properties (both SQL and MongoDB APIs) - Fixed Neo4j uncaught error New features with v3.1.0: - Hive: added LDAP and Kerberos authentication support, plus SSL - Elasticsearch: added specialized and range datatypes - Swagger: added Interactive API pane to Swagger Definition tab - Added visuals in ERD for required and indexed attributes New features with v3.0.2: - MongoDB: added support for LDAP roles - MongoDB: added handling of replica read preference - Elasticsearch: added handling of default index options - Cassandra: fixed generation of CQL script for only selected tables - Neo4j: fixed actions menu for graph view tab New features with v3.0.1: - Sync with v2.5.7 New features with v3.0.0: - Added support for REST APIs, starting with Swagger 2 (openAPI 3 will follow in a few weeks) - Added zoom on container when selected from picker - Cassandra: LDAP authentication support New features with v2.5.8: - MongoDB: added support for LDAP roles - MongoDB: added handling of replica read preference - Elasticsearch: added handling of default index options - Cassandra: fixed generation of CQL script for only selected tables - Neo4j: fixed actions menu for graph view tab New features with v2.5.7: - Allow upgrade to v3 New features with v2.5.6: - Added set zoom toolbar choice for ERD and tree view - Improved zoom speed for ERD and tree view - Added focus on ERD object when selected in Object Browser - Added user-friendly message when corrupted plugin zip - Added error-handling for loading of plugin configurations New features with v2.5.5: - Added ability to collapse container list - Elasticsearch: fixed denormalization when relationships stored inside container-level keys - Postgres DDL: detect UUID data type New features with v2.5.4: - Avro: added description and comments properties at choice level - Avro: added support for doc and default properties for choices - Avro: forward-engineering of complex types (enum, fixed) inside node when multiple data type - Avro: handling of undefined field after changing field alias - Avro: proper handling of naming convention technical name in forward-engineering - Command Line Interface: handled recursive creation of non-existent folders in forward-engineering - DynamoDB; fixed reverse-engineering uncaught error - Fixed Daylight Savings bug - Handled reverse-engineering of JSON Schema inside JSON document - Fixed JSON Schema validation error after reverse-engineering New features with v2.5.3: - Added error handling in CLI obfuscate command - Added forward- and reverse-engineering of Cassandra set, list, and map with UDT New features with v2.5.2: - CLI: added command to obfuscate technical and business names, and remove value of description, comments, and enums - CLI: added command to forward-engineer schema creation/alter scripts - Avro: reverse-engineering of doc and default properties in case of polymorphism - Avro: maintain field order when multiple oneOfs within an allOf choice - Cassandra: possibility to add a UDT as child of list, map or list data type - Fixed generation of JSON sample if an object accidentally contains an array item New features with v2.5.1: - Handled forbidden characters in filenames of container forward-engineering - Added "OR REPLACE" to forward-engineering of Cassandra UDA alter script - Fixed disappearing characters in business name property - Avro: added type name property to complex types, and added handling for it in reverse- and forward-engineering New features with v2.5.0: - Detection of pattern fields during reverse-engineering - Enabled pasting of model definitions - Avro: added technical name to the array items with complex types - Avro: allowed multiple union types at same level through JSON Schema allOf choice - Avro: allowed names for union types - Avro: fixed naming convention of records - Avro: fixed technical name of containers when business-to-technical naming conventions enabled - Avro: handling of union data type with logical types - Avro: handling of enum data type - Avro: resolution of referenced definitions in forward-engineering - Cassandra: added button to apply CQL script to db instance (provided user has proper rights) - Cassandra: added ALTER TABLE CQL script to Command-Line Interface model comparison - Changed saving path of an external reference model using RFC 3986 specification (https://tools.ietf.org/html/rfc3986) - Adjusted warning to take relative path of external references into account - Enhanced handling of reverse-engineering of gigantic schema with extremely deep nesting - Fixed resolving external references when opening model - Reverse-engineering of MySQL DDL: take time data type into account - Changed spinner to appear sooner during plugin installation - Preserve original ERD layout after reverse-engineering if model was previously not empty - Elasticsearch: set default container keys plus reverse-engineer JSON and JSON Schema under _source - Added license re-validation attempt after maintenance expiration - Hive: suppressed forward slash in http transport mode path New features with v2.4.4: - Changed from backslash to forward slash in forward-engineering of path for external definition on Windows - Relaxed constraint of error message when opening a model which was created with a newer application version - Fixed creation of JSON Schema from a collection with extended MongoDB data types ( ISODate(), Timestamp(), ...) - Fixed reverse engineering of a sample for date data type New features with v2.4.3: - Proper handling of $ sign in Naming Convention's case conversion - Added period in front of the relative path of external definition - Added link to sample models page in to Welcome pane - Added support for nesting beyond 100 levels during Reverse-Engineering - Filtered GUIDs in standard view of JSON Schema preview and forward-engineering - Added reverse-engineering of MongoDB indexes on array items - Improved handling of multiple data types in Properties Pane - Fixed error message during CLI reverse-engineering if erroneous model path New features with v2.4.2: - Added validation and auto-fixing of ERD settings when opening model - Added target and plugin information to the uncaught error report - Fixed distribution of graph relationships - Fixed handling technical names for graph node labels New features with v2.4.1: - Added warning after Reverse-Engineering when Naming Conventions coupling set to Business-to-Technical, to avoid conflict in case of non-symmetric conversions - Added button to clear Technical Names if user inadvertently enabled Business-to-Technical coupling, and now wants it disabled. - Display real data type of attribute when appearing in a view - Added handling of Naming Conventions for views - Adjusted handling of indexes in DynamoDB Table Create Script after copy table New features with v2.4.0: - Introduction of Naming Conventions to maintain both a ‘business name’ and a ‘technical name’ for objects, and keep them synchronized and transformed based on a set of user-driven parameters, and optionally based on a conversion file maintained outside of the application. Name conversion can go both directions: Business-to-Technical, or Technical-to-Business. - Added handling access error when saving to root on Mac - Added default paths parameter options for new installations - Added tolerance for absent container complex type in XSD reverse-engineering New features with v2.3.7: - Mapped DateTime data type in MS SQL Server DDL reverse-engineering to Hive timestamp - Mapped BIT data type in MySQL DDL reverse-engineering to JSON boolean - Eliminated false positive document validation in JSON Preview for recursive external references - Clear search box of Object Browser when opening a new model - Restored full list of entities in JSON Schema forward-engineering - Fixed error in cancellation of MongoDB reverse-engineering - Fixed error in Command Line Interface documentation generation - Fixed in keeping order of attributes during Cassandra reverse-engineering - Fixed error in cancellation of Cassandra reverse-engineering - Fixed rendering of keys at the entity level New features with v2.3.6: - Support for proxy server in plugin installation - Support for proxy server in Command-Line Interface reverse-engineering New features with v2.3.5: - UUID change for concurrent licenses - Fixed section numbering in documentation when partial entity selection - Tolerance for empty complexType in XSD import - Hive: fixed forward-engineering when dependencies are present - various minor fixes New features with v2.3.4: - Avro: support for logical types - Couchbase: prompt user to choose document type if confusion by INFER or empty string - MongoDB: updated mongodb-core library - MongoDB: added timeout handling - MongoDB: moved enableSharding from model to database level and added to script if enabled - JSON: removed isRestfulApi in forward-engineering if disabled - fixed generating JSON sample for complex type in case of recursive definitions - fixed spinner if install plugin from zip is cancelled - XSD reverse-engineering: added support for xsd: tags to xs: - Hive: keep order of JSON when inferring schema in reverse-engineering New features with v2.3.3: - Added option for manual network proxy parameters, for license key validation and software update check - Fixed so subscription licenses don't require re-validation when renewal has been paid New features with v2.3.2: - Kerberos authentication protocol support for HBase plugin - Better handling of deletion of a field that is a key in a MongoDB index - Warning dialog when an attribute is deleted - Fixed definition resolution when array contains null - DDL reverse-engineering: convert varchar to varchar instead of string if the target supports it - DDL reverse-engineering: convert decimal to double instead of integer if the target supports it - Oracle DDL reverse-engineering: be tolerant of non-official BIGINT, SMALLINT, TINYINT, and STRING and convert to equivalent if the target supports it - Hive HQL script forward-engineering: fix error when source is erwin model - XSD reverse-engineering: convert DateTime data type to timestamp instead of string if the target supports it New features with v2.3.1: - Disabled option in contextual menu of a model definition that allowed conversion of attributes into an internal reference - Allowed expanding a model definition with a reference to an external model - Fixed bug in some plugins when changing container for an entity New features with v2.3.0: - Support for Avro schema - Support for Apache Hive - Warning about Couchbase Community with missing schema service - Handling of missing Elasticsearch index type - Display warning if attempting to reverse-engineer CosmosDB w/ MongoDB API without corresponding plugin New features with v2.2.4: - Ability to use field list properties in plugin field-level config - Additional Elasticsearch mapping parameters for v6.4 - Handling of PDF Print and Documentation Generation with Acrobat Reader version 2019 New features with v2.2.3: - Normalization of file path in external definition with relative path - Default JSON Schema preview to referenced definitions - Fine-tuned JSON Schema definitions conversions with cascading references - Fixed HTML documentation opening of diagram in new tab for Chrome 69, plus link to container/database/bucket - Fixed CLI compMod merge container visual - Fixed reverse-engineering of XSD schema for Cassandra and Hive plugins New features with v2.2.2: - Added identifier in License Key Validation dialog for customers with multi-seat keys - Added automatic release of previous key when validating a new one - Added indentation for documentation titles - Elasticsearch: renamed container-level key from index to _index and defaulted index property to true - XSD reverse-Engineering: added handling of types anyURI, boolean, double and float. And when possible: base64Binary and hexBinary - Added search capability in both field picker and external definition picker - Added possibility to load external models by relative path - Added prevention of combining scalar and complex types in multiple data types -- if involves complex types, must use Choice - Added generation of default data in case of references in an array - Added optional resolution of definitions in JSON Schema preview and reverse-engineering - Fixed handling of relationships when copy/paste between instances - Fine-tuned merge of models after CLI compMod when renaming a container, an entity, or an attribute New features with v2.2.1: - Graph zoom fine-tuning - Change of relationship line size New features with v2.2.0: - Graph view with familiar circular node labels in Neo4j plugin - Adjusted MongoDB reverse-engineering when specified database and SSH - Fixed reverse-engineering of Excel template for MongoDB target - Fixed installation on Windows when conflict between envirnment variables New features with v2.1.1: - removed caching of modal content - saving models of native targets - handling JSON in plugin reverse-engineering - fixed reverse-engineering for Cosmos DB if container-level key is named 'id' New features with v2.1.0: - forward- and reverse-engineering of Cassandra & Datastax (requires plugin update), including inference of JSON structures if detected in text or blob - using getCollection instead of brackets in forward-engineering of MongoDB index for better encoding of special characters in collection names - suppressed extraneous warning when Saving As - fixed forward-engineering of MongoDB script after PostgreSQL DDL import New features with v2.0.8: - encoding of special characters in index names when forward-engineering of MongoDB script - fixed anomaly in Object Browser menu toggle - fixed check of Windows10 Registry if user has no rights - better handling of internal references in JSON Schema import - encryption/decryption of database connections - added mapping of date and time string types in XSD reverse-engineering - documentation list of types when multiple New features with v2.0.7: - enhanced instructions in uncaught exception dialog - added system info in email report of uncaught exception - fixed exception when MongoDB view uses field with an external reference - added filtering of property names in documentation when section is empty - added filtering of field properties (including hierarchies) when user option is 'none' New features with v2.0.6: - enhanced handling multiple types in JSON schema validator of MongoDB - enhanced merging validator of MongoDB and the JSON schema from the probabilistic schema - added handling uncaught error on main process - updated mongodb driver New features with v2.0.5: - fixed behavior of external definitions when references or fields containing references are deleted - fixed copying of external references New features with v2.0.4: - relaxed syntax restriction for regex pattern in string property and allow ^urn:uuid: - better handling of foreign key relationships on reference definitions - support for MongoDB 4.0 and SCRAM-SHA-256 - improved display of uncaught error details New features with v2.0.3: - allow offline connection to local MongoDB instance on Windows - changed license message for expired maintenance - fixed v2 license validation when no maintenance plan New features with v2.0.2: - enhanced reverse-engineering of extremely large documents - added parsing of DDL table comments - fixed parsing of MySQL DDL composite foreign keys - added filters for some extraneous DDL fields New features with v2.0.1: - software key validation screen: added maintenance status and expiration - fixed regression when creating a foreign key from properties pane - added logging of schema validation during model opening - improved plugin installation when previous plugin already installed New features with v2.0.0: - support for Neo4j graph database New features with v1.12.20: - fixed anomaly in Object Browser menu toggle - fixed check of Windows10 Registry if user has no rights - using getCollection instead of brackets in forward-engineering of MongoDB index for better encoding of special characters in collection names - better handling of internal references in JSON Schema import - encryption/decryption for database connections - added mapping of date and time string types in XSD reverse-engineering - suppressed extraneous warning when Saving As - fixed forward-engineering of MongoDB script after PostgreSQL DDL import New features with v1.12.19: - enhanced instructions in uncaught exception dialog - added system info in email report of uncaught exception - fixed exception when MongoDB view uses field with an external reference New features with v1.12.18: - enhanced handling multiple types in JSON schema validator of MongoDB - enhanced merging validator of MongoDB and the JSON schema from the probabilistic schema - added handling uncaught error on main process New features with v1.12.17: - allow offline connection to local MongoDB instance on Windows - changed license message for expired maintenance - improved display of uncaught error details - better handling of foreign key relationships on reference definitions - fixed behavior of external definitions when references or fields containing references are deleted - fixed copying of external references New features with v1.12.16: - enhanced reverse-engineering of extremely large documents - added parsing of DDL table comments - fixed parsing of MySQL DDL composite foreign keys - added filters for some extraneous DDL fields New features with v1.12.15: - better handling of update download when expired or no maintenance New features with v1.12.14: - fixed handling of MongoDB collection options during reverse-engineering - fixed handling of DynamoDB indexes during reverse-engineering New features with v1.12.13: - enhanced MongoDB connections to support MONGODB-CR credentials for older versions (deprecated with v3.6) - fined-tuned parsing of MongoDB Atlas URI to suppress test database - added conversion of internal definition to attributes when pasting into a model definition - added Tools> Options > Documentation parameter to limit number of attribute tree views with large models for documentation generation performance - prevented JSON Schema "id" attribute from being boolean New features with v1.12.12: - set default to 'Maintain field order' when reverse-engineering - fixed license check for AWS Marketplace Workspaces - fixed Bluebird module issue for Elasticsearch mappings preview - fixed rare issue with UUID generation not accessible New features with v1.12.11: - GDPR privacy policy consent - plugin for MarkLogic for data modeling only: no forward- or reverse-engineering yet - preserve field order during reverse-engineering of JSON file New features with v1.12.10: - optimized performance of Object Browser search - encoded collection names in MongoDB index script when using restricted characters - better handling of attribute type in documentation when set to multiple scalar types - fixed documentation handling of MongoDB indexes depending on collation flag - not displaying unselected sections in documentation - better tolerance in reverse-engineering of JSON Schema for ordering of fields and missing properties of choices - handling of v2 upgrade licensing New features with v1.12.9: - Elasticsearch: added properties number of shards, number of replicas, alias, and dynamic in Properties Pane, forward- and reverse-engineering - moved installation of node modules in plugin reverse-engineering to plugin installation - new user parameter to reduce documentation length by filtering attribute tree view - added collapsible table of content pane in HTML documentation - fixed link generation in HTML documentation for some large models - 50% performance improvement in documentation generation - added toggle in JSON Schema preview for standard vs extended (internal) JSON Schema - added storageEngine property to collection creation script in MongoDB - fixed creation of new connection settings in DynamoDB - change default of pattern fields to "^[a-zA-Z0-9_.-]+$" throughout (plugins require installation of update) - fixed complex data type for some targets when referencing external definition New features with v1.12.8: - parsing of auth source from MongoDB Atlas and mlab URI - fixes case of empty Object Browser at startup after first install - persistence of unique array items in MongoDB New features with v1.12.7: - forward- and reverse-engineering for Elasticsearch and HBase - reverse-engineering of JSON file takes multiple documents into account - added date and time as JSON Schema string formats -- not in draft v4 but tolerated by validators then introduced in v6 - fixed forward-engineering of JSON document when same name for model, group, and document - filter some extraneous properties in forward-engineering if false - performance improvements in Object Browser for large models by use of virtual lists - support of AWS Workspaces for Desktop Applications New features with v1.12.6: - ERD display of field type mode when present instead of field type - fine-tuning reverse-engineering of XSDs in case of substitutionGroup - fixed handling of embedded array items in CLI model comparison New features with v1.12.5: - skipped New features with v1.12.4: - reverse-engineering of XSD to import models from erwin, ER/Studio, PowerDesigner, and others - improved documentation generation performance - possibility to print diagram to PNG - display of nested fields in MongoDB views pipeline - enhanced handling of model opening when corresponding plugin is absent - ability to handle multiple oneOfs in reverse-engineering of JSON Schema - fixed handling of multiple types with Null and sub-docs - ability to handle probabilistic schema for large sets of documents New features with v1.12.3: - user-defined parameter for Couchbase reverse-engineering pagination - display progress details during Couchbse reverse-engineering New features with v1.12.2: - allow A0, A1, A2, Ledger formats in Print Diagram - more accurate entity box resizing in ERD after reverse-engineering - allow reverse-engineering of MongoDB NULL type fields - allow opening of model file corrupted with a prior version - workaround for Couchbase error: "An unknown N1QL error occured. This is usually related to an out-of-memory condition" New features with v1.12.1: - reverse-engineering of PostgreSQL DDLs - improved reverse-engineering of Oracle DDLs for processing of alternate syntax - increased logging for reverse-engineering process New features with v1.12.0: - enhanced support for MongoDB v3.6, including generation of $jsonschema validator, plus reverse-engineering of $jsonschema validator when present - added MongoDB Replica set and Sharded cluster connection type, including choice of Read Preference - added MongoDB X.509 authentication protocol - fixed conversion of probabilistic schema inference when multiple simple types New features with v1.11.1: - fixed mishandling in CLI compMod when combination of --ignoreGUIDs and array items with no name - fixed when creating a MongoDB index key on a field that is part of the reference to a definition - fixed when deleting a field that is also a MongoDB index key New features with v1.11.0: - complete tech refresh of dependent libraries - performance improvements in UI navigation - possibility to view and maintain attributes' properties pane from within ERD - map DynamoDB field types to JSON Schema compatible types during JSON Schema forward-engineering New features with v1.10.4: - removed filter of default Couchbase bucket - fine-tuning Cassandra plugin - fixed encoding of regex expression in MongoDB validator script New features with v1.10.3: - updated Couchbase reverse-engineering connection New features with v1.10.2: - fixed message when releasing floating license - fixed issue with registration on new instances New features with v1.10.1: - offline license validation in case of no internet connection - reverse-engineering of DB2 DDLs - batch forward-engineering of files with selection dialog - fixed bug of disappearing Object browser pane - fixed JSON Schema validation of MongoDB data types in Cosmos DB - minor adjustments in Elastisearch and Cassandra plugins New features with v1.10.0: - support for Microsoft Azure Cosmos DB with MongoDB API - latest version of the Cosmos DB DocumentDB SDK version - next command in Command Line Interface: model comparison with option merge - enhanced toolbar to combine alignment icons and add reverse-engineering icon - plugins for Elasticsearch and Apache HBase for data modeling only: no forward- or reverse-engineering yet!! New features with v1.9.3: - enhanced DDL reverse-engineering to deal with optional syntax - fixed pasting objects into arrays and sets New features with v1.9.2: - fixed Object Browser issue with object type in JSON target - removed unnecessary properties in JSON integer data type - added Comments property column to documentation - close application when downloading update New features with v1.9.1: - proper handling of MongoDB indexing for deeply nested fields - handling of Cosmos DB reverse-engineering when multiple databases in same Azure Account ID - Command-Line Interface enabled for Cosmos DB New features with v1.9.0: - support for Microsoft Azure Cosmos DB with DocumentDB API - handling for MongoDB indexing of nested fields New features with v1.8.6: - fixed installer issue with some anti-virus programs - fixed duplicate browser objects in some DynamoDB models - fixed font size in documentation ERD for some wide models New features with v1.8.5: - allow polymorphism in reverse-engineering in case of arrays embedded in arrays - allow more than 100 tables in DynamoDB reverse-engineering - allow documentation generation when Model ER diagram option is OFF - allow up to 100k document in sampling via Command-Line Interface reverse-engineering - better handling in MongoDB collation strength - allow spaces in directory names for default file path - removed duplicate tables in DynamoDB Object Browser New features with v1.8.4: - reading of persistent schema - tooltip for drag-and-drop relationship creation for definitions - more improvements for handling of reference definitions New features with v1.8.3: - improved handling of reference definitions - improved handling of 2-way referencing in denormalization - more accurate numeric type handling in DDL reverse-enginerring in case of JSON target - proper rendering of changed custom attributes for JSON and native DB targets New features with v1.8.2: - documentation generation for attributes referencing definitions - CR/LF in forward-engineering of JSON document and JSON Schema on Windows platform - defect fix in node-ipc module log New features with v1.8.1: - enabled reverse-engineering of DDLs for plain JSON target - moved reverse-engineering from front-end to back-end to allow larger sampling size - relaxed sampling size for Command-Line Interface reverse-engineering to 100k documents - several new filtering options to configure/trim down documentation New features with v1.8.0: - Command Line Interface with: generation of documentation, and reverse-engineering. (comparison of models due in subsequent release) - user-defined custom properties for MongoDB, DynamoDB, and Couchbase objects via plugin - improved document kind field proposals for Couchbase without N1QL service New features with v1.7.2: - improved handling of bucket authentication via REST API for Couchbase 4.x - reverse-engineering of Mongoose schemas in plain JSON, plus handling of keywords "required" and "default" - improved handling of "required" property in forward-engineering of MongoDB scripts New features with v1.7.1: - fixed several minor anomalies New features with v1.7.0: - introduction of affordable Personal edition - copy/paste between multiple instances of Hackolade - ability to perform joins with $lookup in MongoDB read-only views New features with v1.6.2: - fall back to all documents when Couchbase localRandomKey fails - fixed licensing release when multiple consecutive trial keys New features with v1.6.1: - URI encoding of Couchbase non-N1QL REST call for Reverse-Engineering - new layout Software Registration New features with v1.6.0: - plugin extensions for additional database targets (no reverse-engineering yet - coming soon) - references to other Hackolade models via external definitions - reverse-engineering of Couchbase 3.x and other instances not running N1QL service - support for Couchbase 5.x security - significant performance improvements in ERD New features with v1.5.3: - improved handling of collapsed nodes in hierarchical tree and Couchbase ramQuota - display of password-protected Couchbase buckets in document selection dialog of Reverse-Engineering New features with v1.5.2: - reverse-engineering from MongoDB secondary (does not include validator rules as they are not replicated by MongoDB to secondaries) New features with v1.5.1: - fine-tuned Couchbase authentication - enhanced processing of MongoDB DBRefs when combined with other field types New features with v1.5.0: - MongoDB v3.4: read-only views (single collection only -- reference to multiple collections is coming soon), collation, improved indexing, sharding - connection to MongoDB Atlas - move fields via drag-and-drop in hierarchical tree view (only at same level with this release -- more flexibility to come later) New features with v1.4.2: - fixed installer issue with some anti-virus programs New features with v1.4.1: - drag-and-drop attributes in collection tree view - undo/redo with Ctrl+Z/Ctrl+Y New features with v1.4.0: - support for Couchbase Server and Mobile, including specific terminology, forward-engineering scripts (Ottoman ODM) and reverse-engineering protocol for both local and hosted instances - MongoDB: possibility to maintain multiple databases in same model, and define different groups of collections - DynamoDB: possibility to maintain multiple regions in same model, and define different groups of tables - JSON: possibility to maintain multiple groups in same model New features with v1.3.2: - auto-detect type when opening a JSON file: JSON document, JSON Schema, or Hackolade model. The first 2 trigger reverse-engineering. - display error details when opening an invalid Hackolade model file - application overview presentation at startup - OS-specific shortcut keys New features with v1.3.1: - fix for licensing server change New features with v1.3.0: - library of re-usable definitions - reverse-engineering of MS SQL Server DDL - documentation logo personalization New features with v1.2.5: - additional controls for database/collection selection in Reverse-Engineering and documentation - refinements when using MongoDB validator in Reverse-Engineering - better use of field attributes and constraints in auto-generation of JSON samples New features with v1.2.4: - support for concurrent licensing New features with v1.2.3: - in contextual menu, ability to pick from list of previously created fields - fix for suggest denormalization New features with v1.2.2: - ability to import model and fields info from an Excel template - ability to create relationships with drag-and-drop - button to add timestamp to comments - leverage validator info in db.getCollectionInfos() during reverse-engineering (MongoDB v3.2+) - DynamoDB: support for composite fields in GSI primary key New features with v1.2.1: - support for MongoDB DRBrefs at model creation, and during reverse-engineering - detection of version of MongoDB during reverse-engineering - possibility to edit field name and type in field box of hierarchical tree view - possibility to (de)select objects in documentation generation New features with v1.2.0: - support for Amazon DynamoDB, including specific terminology, forward-engineering scripts and reverse-engineering protocol for both local and hosted instances - possibility to select objects to be included in documentation New features with v1.1.3: - more precise logging for reverse-engineering and license registration processes - improved reverse-engineering of multi-type fields when combining scalar and complex types New features with v1.1.2: - SSH connection to MongoDB instances (for example at cloud locations) - definition of composite indexes and forward-engineering of indexes - 2-way referencing in denormalization assistance - ERD collection box color-coding - extended host connection string format to directly access specific db New features with v1.1.1: - re-architecture to allow multiple 'targets', and support DB vendors other than just MongoDB - support for plain JSON, with pure JSON Schema draft v4 validation - collection tree diagrams in HTML documentation can now be zoomed in when opened in separate browser tab New features with v1.0.12: - Fixed licensing issues for first-time users New features with v1.0.11: - Reverse-Engineering of MySQL Data Definition Language files - orthogonal distribution of ERD shapes - contextual menu in Object Browser New features with v1.0.10: - fine-tuning of DDL reverse-engineering and denormalization New features with v1.0.9: - Reverse-Engineering of Data Definition Language (DDL file from Oracle RDBMS) - Suggestion of denormalization New features with v1.0.8: - logging of Reverse-Engineering process steps - increased usability of relationship deletions and opening of collections New features with v1.0.7: - Kerberos connection to MongoDB - Tools > Compare Models - HTML documentation - fixed PDF header and footer issues - many reports improvements - progress dialog in Reverse-Engineering of MongoDB New features with v1.0.6: - field order in reverse-engineering > JSON Document, JSON Schema, and Mongoose schema - fixed several minor cosmetic issues New features with v1.0.5: - LDAP authentication - Tools > Options for user parameters - field order in reverse-engineering > MongoDB Collections - capped collection parameters for db.createCollection script New features with v1.0.4: - licensing: replaced MAC address with UUID for more stable desktop identification - added X.509 TLS/SSL connection to MongoDB, with options: -- none: do not use SSL for anything -- unvalidated: use SSL but do not perform any validation of the certificate chain -- server: the driver should validate the server certificate and fail to connect if validation fails -- all: the driver must present a valid certificate and validate the server certificate. New features with v1.0.3: - authentication to local and remote instances of MongoDB (without SSL, LDAP, Kerberos, X.509, or SSH) - fixed relationships in copy/paste of fields - added validationLevel and validationAction to MongoDB validator script New features with v1.0.2: - forward-engineering > Mongoose schema - fixed documentation generation on Mac - finished documentation formatting - diagram print preview - letter and tabloid formats in diagram printing - lots of other improvements New features with v0.9.2: - documentation generation (except on Mac) - diagram and schema printing - forward-engineering > MongoDB Script - ability to change order of relationships - enabled several more shortcuts on Mac - lots of other improvements