v3.x
New features with v3.6.10 [24-Mar-2020]
- JSON Data preview: enhanced validation for numbers with exponential notation
- Command-Line Interface: added tolerance for broken relationships when obfuscating model
- MongoDB script: included enums when multiple data type
New features with v3.6.9 [19-Mar-2020]
- Added prompt for UUID if required, plus additional logging
- Added documentation timeout and uncaught error
New features with v3.6.8 [6-Mar-2020]
- Added horizontal scrollbar in Object Browser
- Fixed event handling (undo/redo conflicting with typed letters "z" and "y" if Ctrl+Tab had been pressed inadvertently)
- Undo no longer Closes all in Object Browser
- When updating external references for refresh button, a dialog now offers option to refresh all external references in the model
- Avro: added subtype and logicalType properties to extended JSON Schema
- Cassandra/ScyllaDB: added handling of nested UDTs
- Many Swagger/OpenAPI improvements:
-- documentation no longer lists unused structures
-- documentation: fixed ERD image
-- added validations for semantic and structural conditions
-- added visual mark for nested references in hierarchical schema view, plus option to Go to definition
-- extended structure pre-creation for request body/response content
-- added dropdown for media types, plus option to create not-listed values in hierarchical schema view
-- added description and tooltip for response codes in Properties Pane dropdown
-- fixed inconsistent contextual menu for definitions/componenents in Object Browser
-- added possibility to add and remove responses from Properties Pane of request
-- removed the naming convention "couple" button for media-type name
-- fixed copy/duplicate-paste validation errors
-- added layout options to display request/responses structure horizontally
New features with v3.6.7 [26-Feb-2020]
- ScyllaDB: added new plugin
- CLI: added spinner
- Plugin Manager: suppressed Remove button for native targets
- Plugin Manager: propose to save model prior to restart
- MacOS: performance improvement for slow URL opening on Mojave
- JSON Preview: fixed tab persistence in localStorage
New features with v3.6.6 [24-Feb-2020]
- backward compatibility for JSON and Couchbase models
New features with v3.6.5 [22-Feb-2020]
- CLI obfusc command: added statistics report at end of process, plus fine-tuned nested properties handling
- Naming conventions conversion: apply changes no longer requires default coupling to be modified
- Added capture of exception if collectionId is null
- Added re-calculation of container size when pasting entities
- ArangoDB: added foreign-key relationship cardinality display in graph view
- ArangoDB: added FK and edge relationship selection in object selection menu
New features with v3.6.4 [19-Feb-2020]
- Soft release of ArangoDB plugin, without forward- or reverse-engineering
- Fixed paste function in license validation modal for some Mac versions
- Added paste icon in license validation modal
New features with v3.6.3 [17-Feb-2020]
- Added Migrate button if native target customProperties plugin is not in plugin registry
- Added Migrate button if native target customProperties plugin is not installed
- Changed description of native target customProperties plugin
- Changed order of plugin listing in Plugin Manager
New features with v3.6.2 [15-Feb-2020]
- All plugins: separated customizations from corresponding plugin, to facilitate plugin updates
- Link to show plugin directory removed from Help menu and moved to customization of each plugin of Help > Plugin Manager > Installed tab
!!!! if you have defined custom properties for Hackolade targets, you should read these instructions: https://hackolade.com/help/Migrationtoenhancedcustompropert.html
New features with v3.6.1 [13-Feb-2020]
- Avro: added forward-engineering of namespace for references
- Mongoose: fixed handling of default value conflicting with eval() suppression for Electron security
New features with v3.6.0 [11-Feb-2020]
- Tech refresh of Electron (v6.1.4), NodeJS (v12.4.0), Chromium (v76), and Electron-related modules, plus MongoDB, Couchbase and DynamoDB drivers
!!!!! Discontinued support for 32-bit Linux (https://electronjs.org/blog/linux-32bit-support) !!!!!
!!!!! Discontinued support for MacOS X 10.9 (Mavericks) or before (https://github.com/electron/electron/pull/15357) !!!!!
!!!!! For Linux upgrade, it is advised to delete first the directory where Hackolade is currently installed, prior to unzipping the new version
New features with v3.5.11 [4-Feb-2020]
- Avro: added support for reverse-engineering from AWS S3, Azure Blob Storage, Google Cloud Storage
- Cassandra: added support for materialized views
- AWS DocumentDB: adjusted MongoDB connections to also support the SSH/SSL combination needed for AWS DocumentDB: https://docs.aws.amazon.com/documentdb/latest/developerguide/connect-from-outside-a-vpc.html
- Parquet: added support for reverse-engineering from Google Cloud Storage
New features with v3.5.10 [22-Jan-2020]
- 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 [16-Jan-2020]
- 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 [11-Jan-2020]
- 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 hierarchical schema view
- Fixed Kerberos library for Hive on Mac
New features with v3.5.7 [6-Jan-2020]
- Fixed reverse-engineering from database instances
New features with v3.5.6 [3-Jan-2020]
- Added display of index info in hierarchical schema 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 [13-Dec-2019]
- 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 [30-Nov-2019]
- Graph plugins: implemented force-directed layout algorithms with spring-like attractive forces
- 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 [21-Nov-2019]
- 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 <dbs> to script
- Swagger/OpenAPI: add validation prior to reverse-engineering
New features with v3.5.2 [15-Nov-2019]
- 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 [30-Oct-2019]
- 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 hierarchical schema 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 [20-Oct-2019]
- 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 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 hierarchical schema 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
- Hierarchical schema 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 definitions (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 hierarchical schema 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 Key Store
- Avro: default must match enum values
- Avro: display warning in ERD and hierarchical schema 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 hierarchical schema 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 hierarchical schema 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 hierarchical schema 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 hierarchical schema 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 hierarchical schema view
New features with v3.1.2:
- Allowed multiple selections in reverse-engineering of JSON documents, JSON Schema, DDLs, and XSDs
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
- Fixed uncaught error in repetitive reverse-engineering of JSON documents
- Added Unique Items in Cosmos DB collection properties (SQL API)
- 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: added LDAP authentication support