Documentation

No results
    gitHub

    v5.x

    New features in v5.4.13 [18-Apr-2022]

    - Tech refresh of Electron (v17.4.0)

     

    New features in v5.4.12 [08-Apr-2022]

    - Tech refresh of Electron (v17.3.1), NodeJS (v16.13.0), Chromium (v98.0.4757.141), and Electron-related modules.  Addresses Chromium V8 CVE-2022-1096 vulnerability

    - MongoDB Field-Level Encryption: added rule to linter so as to identify cases when encryptMetadata keyId is missing in parent

     

    New features in v5.4.11 [31-Mar-2022]

    - Added ability to alpha sort attributes from contextual menu of Object Browser, ERD, and schema tree view

    - Delta Lake: added cluster state logs, and improve logs for each API request

    - Delta Lake: made keywords in revers-engineering grammar case-insensitive

    - MariaDB forward-engineering of ALTER scripts from delta model: added a flag to explicitly un-comment DROP statements, signifying the understanding of the possible consequences

    - SQL Server forward-engineering of ALTER scripts from delta model: added a flag to explicitly un-comment DROP statements, signifying the understanding of the possible consequences

     

    New features in v5.4.10 [25-Mar-2022]

    - Mac: mapped shortcut Cmd+W to Close Data Model, and Alt+Cmd+W to Add View

    - Added auto-fix of existing circular external references when opening model

    - Compare and Merge: added spinners

    - Cassandra: when adding a column to an existing search index, use the more efficient script statements ALTER SEARCH INDEX SCHEMA followed by RELOAD SEARCH INDEX and REBUILD SEARCH INDEX, instead of the previous DROP/CREATE SEARCH INDEX statements

    - Delta Lake: adjusted error messages when cluster id or workspace URL does not exist

    - Delta Lake: added responseBody to reverse-engineering logs

    - MongoDB Field-Level Encryption:added generation of JSON Sample with BinaryData level 6 sample for encrypted fields

    - MongoDB Field-Level Encryption: added script linting messages when FLE not appropriately configured

    - Oracle, PostgreSQL, Snowflake forward-engineering of ALTER scripts from delta model: added a flag to explicitly un-comment DROP statements, signifying the understanding of the possible consequences

    - Protobuf: added reverse-engineering of top-level messages into User-Defined Types/model definitions

    - Protobuf: added handling ofr choices in definitions during forward-engineering

    - ScyllaDB: added forward-engineering of ALTER scripts from delta model, including flag to explicitly un-comment DROP statements, signifying the understanding of the possible consequences

     

    New features in v5.4.9 [18-Mar-2022]

    - Compare & Merge: added flag to allow excluding container ALTER statements, useful when dealing with multiple environments: dev, test, prod, etc.

    - Command-Line Interface forwEng command: added argument --exclude-container-alter-statements

    - Polyglot: changed conversion of object data type to struct for Delta Lake/Databricks, Glue Data Catalog and Hive

    - Polyglot: added automatic deriving of model definitions/UDTs when referenced, even if not actually selected

    - MongoDB: improved relationship inference during reverse-engineering when small sampling value in large collections

    - MongoDB: added field-level encryption support in data model and $jsonschema validator script creation

    - Redhift: added support for interleaved sort keys

    - all SQL-based databases: improved parser for SELECT statements of views

    - Swagger/OpenAPI/EventBrdige: changed conversion of decimals and integers with high capacity to nearest possible data type

     

    New features in v5.4.8 [11-Mar-2022]

    - Compare & Merge: eliminated false positives with choices and array items when comparing by name

    - Cassandra forward-engineering of ALTER scripts from delta model: added a flag to explicitly un-comment DROP statements, signifying the understanding of the possible consequences

    - Command-Line interface: added argument --apply-drop-statements to forwEng command when generating DROP statements out of a compMod delta model.  The default is false so the user is required to explicitly activate the generation of DROP statements, signifying the understanding of the possible consequences

    - Model-driven API generation: added handling of custom properties for other targets than JSON

    - MongoDB: added option to use indexed columns in sort criteria during reverse-engineering

    - MongoDB: added dialog with instructions when encountering MongoDB error "operation exceeded time limit"

    - MongoDB forward-engineering: added handling of technical name when index is a nested field inside a reference

    - MongoDB script tab: added a linter with warnings and errors to identify missing necessary statements: use database, missing index keys, etc.

    - MongoDB reverse-engineering: improved optional inference of relationships when FKs are inside arrays

    - OpenAPI/Swagger: added tolerance for user mistakenly choosing reverse-engineering from JSON Schema instead of from OpenAPI/Swagger file

    - PotsgreSQL: enhanced creation of connection pool for sslTypes <allow> and <prefer>

     

    New features in v5.4.7 [04-Mar-2022]

    - JSON Schema: added tolerance for reverse-engineering of Swagger/OpenAPI "example" keyword into proper "examples" property

    - Compare and merge: multiple enhancements: property-level only changes, references in model definitions, relationships when compared by name, metadata (indexes, constraints, triggers, ...) when compared by name

    - Excel import: enhanced import of groups and blocks custom properties controls

    - Avro: added filtering of nested references

    - Cosmos DB with SQL API: enhanced reverse-engineering when documents are nullable

    - Cosmos DB with SQL, MongoDB, and Gremlin APIs: allowed field names starting with an underscore, except for metadata system fields

    - Delta Lake/Databricks: enhanced DDL parsing during reverse-engineering to accommodate truncated output 

    - MongoDB: added support for version 5.2

    - MongoDB: disabled MMAPv1 as possible engine for v4.2 and above

    - MongoDB: only declare storageEngine if configString is not null

     

    New features in v5.4.6 [25-Feb-2022]

    - Documentation generation: added possibility to see very long entity names in documentation ERD

    - Excel export: added warning when content of a property exceeds Excel's cell limit of 32767 characters

    - Excel import: added button to view log file saved to disk

    - DynamoDB: added detection of required fields when inferring schema of JSON in String attributes

     

    New features in v5.4.5 [18-Feb-2022]

    - Custom properties: enabled possibility to create custom tabs at model level and attribute level

    - Properties Pane: added possibility to extend width to 800px

    - Cosmos DB Core API: added choice of Capacity Mode, to choose between provisioned throughput or serverless 

    - MongoDB: added MQL validation of query in Collection selection dialog of reverse-engineering

    - DynamoDB: added inference of schema for JSON payloads in attributes of String data type

    - DynamoDB: allowed possibility to change the Sort Key for LSIs

    - PostgreSQL: changed reverse-engineering of triggers in case user is missing the USAGE role

     

    New features in v5.4.4 [11-Feb-2022]

    - Reverse-Engineering: added progress bar during parsing of views' SELECT statement

    - Confluent Schema Registry: added possibility to specify a cookie name-value pair to be inserted in during forward-engineering the HTTP header, for example to address BlueCoat SSL inspection re-encrypting with an internal certificate

    - Cosmos DB Gremlin: added choice of Capacity Mode, to choose between provisioned throughput or serverless

    - DynamoDB: added support for JSON structures in attributes of String data type

    - DynamoDB: added property for Table Class to support Standard-IA (Infrequent Access)

    - DynamoDB: added handling of Capacity Mode (aka Billing Mode) for Provisioned Throughput or On-Demand (aka Pay-per-Request)

    - DynamoDB: added possibility for views (aka facets) to have different Primary and Sort keys than their underlying table in single-table design

    - DynamoDB: added primary and sort keys when deriving from Polyglot

    - MongoDB: added handling of missing property in projection of read-only views during reverse-engineering of pipeline

    - Neo4j, version 4.3 and above: added IF NOT EXISTS for CREATE CONSTRAINT statements

    - Oracle: added handling of quotes in comments during reverse-engineering

    - PostgreSQL: changed reverse-engineering to leverage connection pooling

    - PostgreSQL: added checkbox to control whether to include partitions in table selection dialog, default unchecked

    - PostgreSQL: added handling of table triggers (maintenance, forward- and reverse-engineering)

     

    New features in v5.4.3 [04-Feb-2022]

    - Confluent Schema Registry: added possibility to specify a cookie name-value pair to be inserted in during reverse-engineering the HTTP header, for example to address BlueCoat SSL inspection re-encrypting with an internal certificate

    - Hive: Added if not exists property for databases, tables, and view

    - Hive: Added forward-engineering of row format serde when stored as input/output format

    - OpenAPI: added validation during reverse-engineering, plus display of warning dialog

    - Oracle: added generation of ALTER statements from delta model

    - Oracle: added possibility to fetch system schemas in table selection dialog

    - PostgreSQL: added connection with ssl modes allow, prefer, require

    - PostgreSQL: added handling for empty body in views and procedures

    - PostgreSQL: added reverse-engineering of functions when user is not their owner

    - Snowflake: added wrapping of role with double quotes when it contains special characters

     

    New features in v5.4.2 [28-Jan-2022]

    - Software Key Validation dialog: pre-fill of optional Identifier field with Computer Name + OS username.  Can be cleared or overwritten if desired

    - ERD: added more display options to hide attributes with specific properties (non-primary keys, non-required attributes, nullable attributes, etc.)

    - Polyglot: when deriving into Swagger/OpenAPI, added possibility to merge with a template, like with model-driven API generation

    - Avro: added possibility to reverse-engineer multiple record schemas in single .avsc file

    - Databricks: enhanced context creation, plus added Runtime 9 support

    - Oracle: added config to allow connection to Amazon RDS

    - Oracle: added connection by SID

    - Oracle: added possibility to narrow scope of discovery of instance to a single user schema

    - Oracle: added reverse-engineering of table and column comments

    - PostgreSQL: adjusted reverse-engineering of indexes and functions when version 10

    - Snowflake: added timeout from tools options, plus used warehouse auth by credentials

    - Snowflake: added handling of cross-schema views

    - Snowflake: added possibility to apply DDL script to instance

    - Snowflake: added generation of ALTER statements from delta model

    - Snowflake: added snippets for GeoJSON geometries in data type geography

     

    New features in v5.4.1 [21-Jan-2022]

    - Custom properties: ability to mark a custom property with a star (*) to indicate a required entry, optionally with validation.  Consult https://github.com/hackolade/plugins#26-property-controls for more details

    - Model-driven API generation: added choice to keep Swagger/OpenAPI linked to source data model for synchronized evolution, with absolute or relative path

    - Collibra: added publishing of Hackolade custom properties

    - Couchbase: adjusted logic to display dialog to choose document type prompt even if INFER statement returned flavors

    - Delta Lake/Databricks: stopped linking partition keys to primary keys, and detached PARTITION BY statement from column declaration

    - Oracle: added possibility to apply DDL script to instance

    - Snowflake: added GeoSpatial data types

    - SQL Server & Synapse: added IF NOT EXISTS property for schemas, tables, and views with DDL handling via wrapping of CREATE statement in begin...end and a SELECT to check existence of object

    - all Graph targets when exchanging with Excel: do NOT use a template generated with a previous version of the plugins.  Make sure to export model to Excel first, as some of the tab names have been adjusted.  

     

    New features in v5.4.0 [14-Jan-2022]

    - Oracle: soft release of a new plugin with full support for forward-engineering of DDL, and reverse-engineering including inference of schemas in JSON data types (Oracle 21c and above) and of JSON documents in VARCHAR2, CLOB and BLOB data types (12c, 18c, and 19c) -- many improvemens still to come...

    - Polyglot: added possibility to modify properties of attributes in target model, and hence deviate from the polyglot model (deactivate an attribute, or change constraints,...)

    - Polyglot: enhanced documentation in case of relationships or custom tab of properties 

    - JSON Schema reverse-engineering: added dialog to save model when external recursive external references have a relative path

     

    New features in v5.3.5 [11-Jan-2022]

    - Added help button with link to online documentation in Connection Settings dialog of various targets

    - JSON Schema reverse-engineering: enhanced list of missing external definition files for unresolved recursive references

    - Added handling for external references to root of JSON Schema, for example "$ref": "party.json#"

    - Collibra: enhanced reverse-engineering to maintain coupling of business and technical names

     

    New features in v5.3.4 [31-Dec-2021]

    - JSON Schema reverse-engineering: display warning dialog if missing external reference files

    - Cassandra/ScyllaDB: harmonized path and file name for ALTER script CQL file from compMod delta model

    - OpenAPI: added possibility to choose between resolution of references when converting to Polyglot, or save as model definitions (UDTs)

    - PostgreSQL: added CLI command to generate ALTER script DDL from compMod delta model

    - SQL Server: added support for SSL and SSH connections

     

    New features in v5.3.3 [24-Dec-2021]

    - Naming conventions: added tooltips to = signs for coupling of business and technical name

    - Collibra: added Technical Name characteristic and changed mapping of Full Name to use technical name if present

    - JSON Schema reverse-engineering: added tolerance for $ref with OpenAPI structure "/components/schemas/..."

    - JSON Schema reverse-engineering: added tolerance for $ref at root level

    - Avro: added handling of multiple types inside choices

    - Delta Lake/Databricks: refactored reverse-engineering process 

    - SQL Server: automatically attempt to reconnect without encryption if localhost set with encryption

     

    New features in v5.3.2 [17-Dec-2021]

    - Avro: added logicalType object generation for definitions

    - Delta Lake/Databricks: implemented support for decimal type precision and scale

    - Delta Lake/Databricks: added handling for truncated output response of the Databricks API

    - MarkLogic: filter out non-JSON documents during reverse-engineering

    - SQL Server: added handling for empty DEFAULT during reverse-engineering

    - all RDBMS targets: enabled choices for JSON data types in JSON columns

     

    New features in v5.3.1 [10-Dec-2021]

    - Model compare and merge: increased consistency between CLI and GUI outputs

    - Avro: added logicalType property generation for local-timestamp-millis and local-timestamp-micros

    - BigQuery: added string literals with quotes and new lines in DDL forward-engineering

    - Cassandra/ScyllaDB: adjusted handling of of CQL for columns with data type map

    - Confluent Schema Registry with Avro Schema, JSON Schema, and Protobuf: added ability to attach a Trust Store (.jks) file for connection

    - Hive: added string literals with quotes and new lines in DDL forward-engineering

    - MariaDB: added string literals with quotes and new lines in DDL forward-engineering

    - MongoDB: improved reverse-engineering when empty collections are in instance

    - MongoDB: improved reverse-engineering when views have unsupported pipeline stage

    - PostgreSQL: improved reverse-engineering to retrieve only columns data types json and jsonb for sampling

    - SQL Server: added handling of additional table options in temporal tables

    - Synapse: added handling of views with binding errors during reverse-engineering

    - all RDBMS targets: improved warning to list names when reverse-engineering choices from JSON Schema or XSDs

     

    New features in v5.3.0 [03-Dec-2021]

    - JSON Schema: added support for undefined data types marked "any" 

    - Amazon DocumentDB: added support with a new plugin with full support for forward-and reverse-engineering including inference of schemas in collections

    - Network proxy: added a Test button with log

    - Confluent Schema Registry with Avro Schema, JSON Schema, and Protobuf: added an option for unvalidated SSL connection

    - Avro: adjusted forward-engineering of nested logicaTypes

    - PostgreSQL: added handling when user has insufficient rights to read view select statement from information_schema

    - PostgreSQL: added handling of column encoding in forward- and reverse-engineering

    - SQL Server: added support for temporal tables

     

    New features in v5.2.13 [29-Nov-2021]

    - Polyglot: when deriving into an RDMBS target and normalizing, enhanced handling to use existing primary keys

    - Polyglot: when converting from Swagger/OpenAPI model, convert component schema definitions into polyglot entities

    - License key validation and concurrent seat activation/release: added option to switch to disaster recovery license server if primary server is down

    - Network proxy: enhanced handling of basic auth

    - Avro: added possibility to edit references to external Avro schemas

    - Avro: enhanced validator to handle external references

     

    New features in v5.2.12 [23-Nov-2021]

    - Avro:added handling of multiple references to same definition in schema generation

    - Avro: added handling for external schema references 

    - Delta Lake/Databricks: added reverse-engineering of binary subtypes to complex data types

    - SQL Server: added possibility to disable connection encryption with the SQL Server auth method (to match SSMS options)

    - all RDBMS targets: added warning and handling of choices in reverse-engineering of JSON Schema or XSDs, by picking only the first subschema

     

    New features in v5.2.11 [19-Nov-2021]

    - Polyglot: added handling of edges (with properties) in the context of graph databases

    - Polyglot: disabled and cleaned technical names in definitions

    - MariaDB: adjust API for MySQL driver

    - OpenAPI: added handling of empty properties in reverse-engineering of file

     

    New features in v5.2.10 [12-Nov-2021]

    - Replaced the .hackolade.json filename extension when saving a model with a shorter .hck.json filename extension.  Also reduces ambiguity with other .json files

    - ERD: added possibility to select multiple objects via mouse shift+click+drag if clicking inside a container, or or new toolbar button

    - Object Browser: added contextual menu option to alpha sort containers

    - Custom properties: added orderedList capability in group control

    - Collibra: changed REST API channel to accommodate Zscaler proxy with SSL inspection

    - Collibra: allowed publishing of polyglot models

    - Collibra: allowed publishing of models when out-of-the box system attribute types have been edited

    - JSON Document reverse-engineering into RDBMS targets: added detection of ISO 8601 date/time/timestamp/duration in JSON strings, and convert them to best matching data type

    - Polyglot: added warning and handling of choices in reverse-engineering of JSON Schema or XSDs

    - Hive: enabled optional normalization of complex data types when reverse-engineering JSON Data, JSON Schema, or XSDs

    - OpenAPI/Swagger: added control to easily reorder tags

    - PostgreSQL: added forward- and reverse-engineering of PostGIS data types

    - Protobuf: adjusted field numbering in case of oneOf, plus added bool data type as a key type of map

    - SQL Server DDL reverse-engineering: added tolerance for spaces in index declaration

    - SQL Server/Azure SQL: added Azure Active Directory options: username/password, integrated, and with MFA

    - all RDBMS targets: when reverse-engineering JSON Schema with null data type while such type is not available in target, added conversion of field into a string-like data type with null allowed

     

    New features in v5.2.9 [05-Nov-2021]

    - ERD: enhanced placement of new entities inside visible area

    - Model compare & merge: added option to match by business name or technical name when matching by ID is not possible

    - Model compare & merge: use naming conventions display choice when matching by ID, or respective name matching choice

    - Polyglot: added Examples property to allow multiple examples for OpenAPI

    - Polyglot: added primary key for "id" columns during automatic normalization of complex objects when deriving into RDBMS targets

    - Polyglot: added checkbox to disable automatic normalization of complex objects when deriving into RDBMS targets

    - OpenAPI file tab: enabled Cmd+C on Mac

    - OpenApi & Event Bridge: updated request parameter style prop options

    - PostgreSQL: added sslmode support

    - PostgreSQL: added advanced DDL parsing

    - PostgreSQL: added PostGIS data types

     

    New features in v5.2.8 [29-Oct-2021]

    - PostgreSQL: added support with a new plugin with full support for forward-engineering of DDL, and reverse-engineering including inference of schemas in JSON and JSONB data types

    - Protobuf: added support with a new plugin with full support for forward-engineering of Protobuf schema, and reverse-engineering, including files on Cloud storage or Schema Registries (Confluent and Pulsar)

    - Added a check when attempting to reverse-engineer a data model instead of just opening it

    - Replaced the .json filename extension when saving a model with a .hackolade.json filename extension to reduce ambiguity with other .json files

    - Added an option in the OS Open dialog to filter files by .hackolade.json extensions

    - Added possibility to define a non-default path for custom properties in Toots > Options > Default Paths, for example to align with different development branches

    - Added styling for relationship lines: thickness and color

    - Added possibility to resize textarea dialogs (description, comments, ...)

    - Enhanced line break handling in names of nodes/vertices in graph targets

    - Added logic to auto-select relevant entities of ERD Views when generating documentation

    - Added obfuscation of annotations

    - Collibra: added CLI command to reverse-engineer or synchronize Collibra domain into a Hackolade data model

    - Polyglot: renamed Not Null property to Required (fully understanding that the semantics are different...)

    - Polyglot: implemented conversion of not-required attributes without default for Avro into multiple data types with NULL as primary

    - Polyglot: enhanced the handling of primary keys when deriving from polyglot into Cassandra, Couchbase, and ScyllaDB

    - Polyglot: adjusted conversion of nvarchar data type for MariaDB into varchar with national = true

    - Polyglot: added back the  technical name property, but disabled, to clarify that it is not missing

    - Cassandra/ScyllaDB: ignore column moves in ALTER script

    - Snowflake: implemented dollar-quoted comments in DDL forward-engineering

     

    New features in v5.2.7 [22-Oct-2021]

    - JSON document: added detection of string length in nested objects when reverse-engineering into RDBMS targets

    - JSON Schema: added explicit forward-engineering of additionalProperties when set to false

    - Graph database plugins: added a graph view to the ERDV capability

    - Model Compare & Merge: added alpha sorting of objects in trees to facilitate comparison

    - Polyglot: added denormalization of embedded references when deriving from polyglot to an RDBMS target

    - Polyglot: added length decorators in ERD

    - Cassandra/ScyllaDB: added reverse-engineering of data center name, replication factor, and durable writes from CQL file for each keyspace, if present

     

    New features in v5.2.6 [15-Oct-2021]

    - Polyglot: added inclusion of Clustering Key in primary key when converting models from Cassandra/ScyllaDB

    - Polyglot: allowed primary on additional data types

    - Neo4j: added support for indexes on relationship types for version 4.3 and above

     

    New features in v5.2.5 [11-Oct-2021]

    - Graph databases: adjusted creation of nodes for missing relationships in ERDV

     

    New features in v5.2.4 [08-Oct-2021]

    - Command Line Interface: added --maxErdEntityBoxes argument to revEng, revEngJSON, revEngYAML, revEndDDL, and revEngXSD

    - JSON Schema: added handling of reference description in forward- and reverse-engineering for drafts 2019-09 and 2020-12

    - Polyglot data model: added sign in entity selection dialog next to objects not present in target models

    - Collibra reverse-engineering: added a target compatibility check and warning message

    - Avro: added resolution of UDT in choices, plus handling of arrays without items in union

    - Cassandra Datastax: added support for SASI custom indexes

    - Cassandra & ScyllaDB: added property to add IF NOT EXISTS in forward-engineering statements if desired

    - Cassandra: removed CREATE KEYSPACE from forward-engineering when applying to Atlas instance (as keyspace cannot be created via script)

     

    New features in v5.2.3 [04-Oct-2021]

    - RDBMS targets: adjusted normalization when reverse-engineering JSON Schema

     

    New features in v5.2.2 [01-Oct-2021]

    - External definitions: added possibility to reference model of any target.  Was previously restricted to JSON Schema or model of the same target.

    - External definitions: added resolution of custom properties in JSON Schema preview and forward-engineering

    - Model Compare & Merge: added on-click button to open each model in a separate instance

    - Plugin Manager: added update button in Available tab if a new version of an installed plugin exists

    - Tools > Options > Forwarded-Engineering: added preferred settings for JSON Schema specification, used on JSON Preview and in forward-engineering of JSON Schema

    - XSD reverse-engineering: added support for sql:datatype tag for erwin physical models

    - Cassandra: added different index abbreviations in ERD to distinguish Secondary (2Ix.y) from Search (SIx.y) indexes

     

    New features in v5.2.1 [24-Sept-2021]

    - JSON Schema: added support for latest draft 2020-12

    - Collibra: added possibility to reverse-engineer and merge into Hackolade data model.  Also helps truly sync content that may have been entered in Collibra

    - Introduced a Tools > Options > Display tab gathering all the display settings: moved some from the General tab, plus added more

    - Tools > Options > Forward-Engineering: added a JSON Schema section with preferred settings for compliance and definitions handling, used on JSON Preview and in forward-engineering of JSON Schema

    - JSON Preview and forward-engineering of JSON schema now use preferences set in Tools > Options > Forward-Engineering

    - JSON Schema reverse-engineering: adjusted handling of external references when schema only has definitions

    - Alternate keys: added ERD display of multiple constraints on same column

    - Avro reverse-engineering of JSON Schema: added handling of not-required arrays with oneOf choice

    - Delta Lake:added mirroring for table properties, refactored JSON formation, unbatched getting DDL command, refactored table properties parsing

    - Snowflake: added reverse-engineering of auto-increment property, fixed skipped columns during reverse-engineering

     

    New features in v5.2.0 [17-Sept-2021]

    - Polyglot data modeling: added the possibility to convert any physical target model into a technology-agnostic data model, and derive a physical target model - for any target - from a polyglot data model.  More info at https://hackolade.com/polyglot-data-modeling.html

    - Model Compare and Merge: added the possibility in the merge process to generate a delta model (similar to the CLI compMod deltamodel output)

    - Collibra: added batch synchronization for large models

    - Collibra: added possibility to fetch domains for an individual community, resulting in higher performance in large organization

    - JSON Schema: adjusted conversion of samples into examples when switching from one draft version to another

    - JSON Schema: adjusted conversion of exclusiveMin/Max when switching from one draft version to another

    - Cassandra and ScyllaDB: adjusted mapping of mapping of complex types when reverse-engineering CQL files

    - OpenAPI: adjusted display of Swagger UI interaction

    - all RDMBS targets: added support for Alternate Keys (MariaDB, Redshift, Snowflake, SQL Server, Synapse)

     

    New features in v5.1.8 [10-Sept-2021]

    - Object Browser: added possibility to alpha sort entities and views via contextual menu

    - Command-Line Interface: added possibility to open Model Compare & Merge in GUI from command line with --gui=true argument

    - Custom properties multi-select dropdown: added tooltip display

    - Custom properties dependency structure: added possibility to use an array of values in place of more convoluted "or" syntax

    - Custom properties: added "requiredProperty" for display of a red star next to label

    - DDL reverse-engineering: added support for views based on tables with aliases, select statements with wildcard, and unsupported references 

    - Delta Lake: refactored reverse-engineering for higher performance by batching Scala commands

     

    New features in v5.1.7 [04-Sept-2021]

    - BigQuery: added support with a new plugin with full support for forward-engineering of DDL scripts, and reverse-engineering

    - Command-Line Interface compMod command: added argument --mergeDeletesasDeactivated to deactivate merged object instead of deleting it

    - Custom properties fieldList control: added tooltip display

    - Model Compare & Merge: added options for flexible selection in case of multiple data types

    - JSON Schema preview and forward-engineering: added use of technical names and dot.notation in nested objects 

    - Hive: added read-on "view on" property to display multiple referenced tables

    - Mongoose reverse-engineering: added support for Map data type

     

    New features in v5.1.6 [27-Aug-2021]

    - Compare and Merge: added viewing of index differences, and other properties pane tabs

    - Added validation of file path and name input in model compare and API model template selection dialogs

    - XSD import for RDDBMS targets: use maxLength as char column length

    - Hive: added reverse-engineering of view columns with CAST function

    - Hive: added support for view columns with aliases

    - Synapse: implemented Azure Active Directory authentication with MFA

     

    New features in v5.1.5 [20-Aug-2021]

    - Excel: added import of views

    - XSD reverse-engineering: added conversion of keys with "XAK" prefix into unique keys for migration of models from erwin

    - Documentation: added handling of block controls inside group controls

    - MarkLogic: added collection name matcher option in reverse-engineering connection parameters

    - Synapse: added MFA support to the Active Directory authentication method

     

    New features in v5.1.4 [16-Aug-2021]

    - Tech refresh of Electron (v13.1.9), NodeJS (v14.17.0), Chromium (v91), React (v17), and Electron-related modules

    - XSD reverse-engineering: added support for import of <xs:keyref> into relationships, plus additional fine-tuning

    - Fixed unexpected closing of DDL worker on Mac

    - MarkLogic: added use of global query timeout, plus enhanced getting collection list if specified

    - Azure SQL: added login with email-like username

    - Synapse: added login with email-like username, plus added Azure Active Directory authentication method

     

    New features in v5.1.3 [10-Aug-2021]

    - Colors: added color picker on properties pane options tab for containers, entities, and views

    - Font style: added controls for italic and bold font for container, entity, attributes and views

    - Excel: added export/import of color hex codes and font styles for bulk edit or conditional formatting

    - Excel: improved error information to help troubleshooting when parent structure is missing in import of complex objects

    - Save As Obfuscated: added custom properties to process

    - Indexes: where applicable, added possibility to deactivate index so it does not appear in scripts or gets commented out, if possible: ArangoDB, Cassandra, Cosmos DB (Core SQL, Gremlin, and Mongo APIs), Couchbase, DynamoDB, Hive, JanusGraph, MariaDB, MarkLogic, MongoDB, Neo4j, ScyllaDB, SQL Server, Synapse, TinkerPop

     

    New features in v5.1.2 [30-Jul-2021]

    - Colors: added possibility to change color of attributes in ER Diagram and Object Browser

    - Added option in Tools > Options > Forward-engineering to disable structured path for JSON documents and JSON Schema

    - Added a warning dialog to enable lineage capture if reverse-engineering of DDL is for migration from RDBMS

    - Schema inference during reverse-engineering of JSON documents and databases: supplemented detection of pattern fields when using ID-like keys

    - Model API: greyed out deactivated entities in object selection dialog

    - Command-Line Interface: added forwEng arguments to allow publication of Avro and JSON Schema to schema registries (Confluent, Pulsar, Azure for Event Hubs)

    - Collibra: added publishing via Command-Line Interface to Data Dictionary

    - Collibra: added warning when not all entities are selected for synchronization

    - Collibra: enabled publishing of schema definitions of EventBridge, OpenAPI, and Swagger

    - Pulsar: added ability to forward-engineer schemas via Command-Line Interface

     

    New features in v5.1.1 [23-Jul-2021]

    - Model compare and Merge: added indeterminate state for partial uncheck of checkbox (now tri-state)

    - Model compare and Merge: adjusted trim of long path model names, plus added tooltip

    - Improved rendering of large ERD models

    - Collibra: added forward-engineering of foreign keys in subschemas

    - Pulsar: added Command-Line Interface reverse-engineering

    - SQL Server/Azure SQL: added support for forward-engineering of combined schemas,  and of all schemas into a single file

     

    New features in v5.1.0 [17-Jul-2021]

    - Collibra Data Dictionary integration.  Requires specific license option.  See more info at https://hackolade.com/help/CollibraDataDictionaryintegratio.html

    - Docker containers: for the purpose of running the Command-Line Interface in CI/CD pipelines.   Requires concurrent license key.  See full instructions at https://github.com/hackolade/docker/tree/main/Studio

    - Pulsar Schema Registry: added ability to forward- and reverse-engineer Avro and JSON Schema

    - Lineage capture: added container information to attribute lineage for reverse-engineering, Excel import, etc.

    - Custom properties: added defaultValue in configuration controls

    - DynamoDB: added logic to update table if it already exists when applying to instance

     

    New features in v5.0.8 [09-Jul-2021]

    - ERD drag-and-drop: enhanced tolerance for dropping into an empty entity for both move (drag-and-drop) and copy (Ctrl+drag-and-drop)

    - DynamoDB: added ability to apply forward-engineering scripts to instance

    - DynamoDB: added support for single-table storage, using views (a.k.a. facets in NoSQL Workbench.)  These views cannot be forward-engineered to DynamoDB, or derived through reverse-engineering, as the concept does not exist.  It however makes it easy to visualize and document access patterns

    - MongoDB: added read-only view pipeline edition after reverse-engineering from DDL

     

    New features in v5.0.7 [02-Jul-2021]

    - DynamoDB: added support for table groups

    - Postgres DDL reverse-engineering: added handling for ONLY keyword in ALTER TABLE statements

    - Cosmos DB-Gremlin: reverse-engineering of nested objects in JSON and JSON Schema now results in their normalization, given that the database does not support complex data types

    - Delta Lake on Databricks: modified message when cluster is unavailable

    - Neptune-Gremlin: reverse-engineering of nested objects in JSON and JSON Schema now results in their normalization, given that the database does not support complex data types

    - OpenAPI/Swagger/EventBridge: added tolerance for lines commented with # during-reverse-engineering

    - OpenAPI/EventBridge: removed empty requestBody for GET and DELETE requests during forward-engineering

     

    New features in v5.0.6 [25-Jun-2021]

    - Avro: added namespace property "Schema group name" for Azure Schema Registry

    - Azure Schema Registry for Avro: added ability to fetch Schema Groups 

    - Cassandra DataStax: removed WITH OPTIONS when creating SAI indexes if options are empty

    - Cassandra DataStax on Astra: disabled possibility to define search indexes which are not currently supported by Astra

    - Cassandra DataStax: added possibility to reverse-engineer custom and search indexes from .cql files

    - MongoDB: maintain field order in index creation script for deactivated fields

     

    New features in v5.0.5 [18-Jun-2021]

    - ERD drag-and-drop: added possibility to drop into an empty entity or an empty complex attribute (object or array)

    - Lineage capture: added container level information to event tracing

    - Azure Schema Registry: added possibility to reverse-engineer schemas created via Azure portal console

    - Avro: added validator in model level script tab prior to applying to schema registries

    - Cosmos DB Gremlin: improved error message when specified endpoint is incorrect during forward-engineering to instance

    - MariaDB: implemented possibility to apply DDL script to instance

    - SQL targets: re-ordered DDL scripts to ensure that Foreign Key creations relate to previously created tables

    - Snowflake: added possibility to select combined vs individual schemas from Tools > Forward-Engineering and Command-Line Interface

     

    New features in v5.0.4 [11-Jun-2021]

    - Neptune with Gremlin API: added support with new plugin, including forward-engineering of schema and sample graph via Gremlin script, plus traditional reverse-engineering

    - ERD: added handle to drag-and-drop attributes (can be hidden with Display Options toolbar icon of View menu).  Use ctrl+mouse click to move or copy multiple attributes

    - Tools > Options > Naming Conventions: added ability to refresh CSV abbreviation file without necessity to restart the application

    - Toolbar: grouped various display options under a new icon

    - View menu: grouped display options

    - MongoDB: removed filter for inclusion in JSON Schema full/extended of properties from properties tabs: users, indexes, sharding

    - Cassandra/ScyllaDB: removed filter for inclusion in JSON Schema full/extended of properties from properties tab secondary indexes

    - Cassandra on Astra: added possibility for token-based authorization

    - Snowflake: added possibility to forward-engineer all schemas so as to allow foreign keys across multiple schemas

     

    New features in v5.0.3 [07-Jun-2021]

    - Avro: added ability to forward- and reverse-engineer with Azure Schema Registry for EventHub

    - JanusGraph: added support with new plugin, including forward-engineering of schema and sample graph via Gremlin script, plus traditional reverse-engineering

    - Lineage: added tracking of Foreign Key relationships during denormalization

    - Cassandra: added filtering of invalid clustering keys during forward-engineering

    - Delta Lake: added retrieval of table BLOOMFILTER INDEX options and NOT NULL columns during reverse-engineering

    - JSON Schema draft conversion of Sample property in draft-04 to Examples in older drafts, and vice-versa

    - MongoDB pipeline views: use technical names when present

     

    New features in v5.0.2 [28-May-2021]

    - Compare and merge models: adjusted sizing of dialog with high-resolution screens

    - Added option "Start a New Application Instance" from the File menu

    - Properties Pane: added automatic scroll to focus on relationship selected in Object Browser

    - Reverse-engineering of DDLs and XSDs: no longer overwriting the model name after first file

    - Couchbase: adjust reverse-engineering of indexes with special characters in passwords

    - Couchbase: fine-tuned sampling query for Enterprise Edition instances with large buckets

    - Delta Lake: adjusted document sampling

    - Delta Lake: added forward-engineering of CREATE BLOOMFILTER INDEX statement to instance 

    - Glue Data Catalog: added possibility to reverse-engineer from .hql files

    - MariaDB: added reverse-engineering of unique and primary options from DDL file

     

    New features in v5.0.1 [21-May-2021]

    - Delta Lake on Databricks: added support with a new plugin (compatible with Azure Databricks, Databricks on AWS, and on Google Cloud), with full support for forward-engineering of HiveQL scripts, and reverse-engineering including inference of JSON in longtext

    - ERD and schema hierarchical view: added toolbar button to toggle between technical and business names; added documentation control and CLI genDoc command argument 

    - ERD zoom in: function now takes center of display instead of top left of canvas as reference for zoom operation, whether from toolbar button or ctrl+mouse wheel

    - Forward-Engineering of sample document, schema or script: added Toots > Options > FE parameter to skip folder when container level is undefined

    - Reverse-Engineering object picker dialog: added horizontal scrollbar for long file structures and names in cloud storage

    - Reverse-Engineering object picker dialog: added support for periods in file names

    - DDL reverse-engineering: added support for comment constraints on foreign key relationships (PostgreSQL and Redshift only, as not supported in other dialects)

    - Model Compare and Merge: added auto-selecting/deselecting child objects when their parent has added/deleted difference type

    - Cosmos DB (SQL API, and Gremlin API): added support for serverless instances

    - Redshift: added optional sessionToken connection

     

    New features in v5.0.0 [15-May-2021]

    - Full support for features of JSON Schema specifications draft-06, draft-07 and 2019-09, in addition of draft-04 upon which Hackolade was originally built

    - JSON: added reverse-engineering from cloud storage: Amazon S3, Azure Blob Storage, Google Cloud Storage

    - JSON: added support for forward- and reverse-engineering with Confluent Schema Schema Registry

    - Compare and Merge Models: added 2 distinct views: the compare view with 2 side-by-side panes, and the merge view which displays 3 panes including a merged model pane in between the left- and right-hand models