Documentation

No results
    gitHub

    v6.x

    New features in v6.10.3 [26-May-2023]

    - Object Browser: added search by Regular Expression

    - Reverse-Engineering performance: refactored rendering to handle larger sample faster, as well as multiple JSON columns in RDBMS rows

    - Custom properties: allowed propagation when converting to Polyglot with external references

    - Custom properties: allowed custom tab at model level for Polyglot

    - Workgroup: added Merge & Push button to branch merge (other actions) screen to simplify process

    - Workgroup: added custom message with documentation link when attempting to push to a protected branch in Azure DevOps Repos

    - Avro: removed API command from .avsc file forward-engineered when Schema Registry is not empty

    - Delta Lake/Databricks: added forward-engineering of Primary Key and Foreign Key constraints in Runtime 11 and above

    - Delta Lake/Databricks: added handling of changes in PK and FK constraints in ALTER script generation of delta models

    - Delta Lake/Databricks: added property for relationships so they appear commented in DDL forward-engineering when isActivated property is disabled

    - OpenAPI: allowed change of OpenAPI version within 3.0.x range

     

    New features in v6.10.2 [19-May-2023]

    - Reverse-engineering: updated tree view in selection modals

    - Reverse-engineering conflict detection: adjusted behavior of "apply to all"

    - Avro: added property "default" to complex data types

    - Databricks: added option to forward-engineer .hql in separate file per database and per table

    - Databricks: adjusted reverse-engineering of views when naming conventions enabled

    - Databricks: added handling of map<txt> when converting from Polyglot

    - JSON Schema: added possibility to reverse-engineer JSON file with just an empty array

    - MongoDB: updated workload analysis parameter capture form for collections in light of feedback from MongoDB solution Architects team

    - Teradata: added property for relationships so they appear commented in DDL forward-engineering when isActivated property is disabled

     

    New features in v6.10.1 [12-May-2023]

    - Verify Data Model: added column in report for glossary synonyms

    - Verify Data Model: expanded list of rules by default

    - Polyglot data models: added possibility to mark a (composite) unique key as an Alternate Key, and display in ERD

    - XSD reverse-engineering into Polyglot target: added interpretation of structures declared with substitutionGroup as subtypes 

    - XSD reverse-engineering into physical targets: added interpretation of structures declared with substitutionGroup as inheritance tables

    - Documentation: fixed Windows 11 issue with schema tree diagram images

    - Delta Lake/Databricks: added handling of truncated responses in reverse-engineering with Runtime 11 and above

    - MongoDB: added workload analysis parameter capture form for collections

    - MongoDB: added cardinality parameter capture form for array data type

    - MongoDB: added reverse-engineering of text indexes

    - Protobuf: fixed conversion of object type when deriving from Polyglot

     

    New features in v6.10.0 [05-May-2023]

    - Verify Data Model: added tool to verify the consistency and quality according to a glossary of class and primary terms, and target-specific attribute rules such as precision/scale for numeric, and length for string data types

    - OpenAPI: added support for OAS 3.1

    - OpenAPI: updated SwaggerUI panel to latest library version

    - Properties Pane for relationships: added synchronization of entity order in dropdown lists with order of these entities in Object Browser

    - Model Definitions and UDTs: added logic to comment definitions in DDL forward-engineering if they don't have any activated references in model

    - Avro for Confluent Schema Registry: added logic to recursively reverse-engineer all references in a union schema, even if not explicitly selected

    - Redshift: added support for JSON arrays as root of payload

    - Teradata: added escaping of UDT names when used as types

     

    New features in v6.9.14 [02-May-2023]

    - ERD: allowed null values for relationship sides property in persistence schema

    - Print diagram: initialized diagram header and footer

    - Oracle: added support for JSON arrays and scalar types as root of payload

     

    New features in v6.9.13 [28-Apr-2023]

    - Avro for Confluent Schema Registry: added support for schema references (https://docs.confluent.io/platform/current/schema-registry/fundamentals/serdes-develop/index.html#schema-references), and so-called "union schemas"

    - BigQuery, Databricks, Hive, Redshift, Snowflake, Synapse, Teradata targets: added modeling methodology at model level plus dimensional table roles and Data Vault 2.0 components at entity level

    - MariaDB: enhanced reverse-engineering of composite Primary Keys and Unique Keys, plus indexes

    - MongoDB: added support for references to definitions in embedded objects when forward-engineering Mongoose schema

    - OpenAPI: added auto-detection of YAML file to trigger reverse-engineering

    - PostgreSQL: enhanced log messages when sampling rows for JSON/JSONB columns and alert user to reduce sample size if memory full

    - PostgreSQL: enhanced ALTER script generation from delta model to include comments for schemas, tables and attributes, views

    - Snowflake: updated vm2 library to latest

    - Teradata: added logic to comment deactivated database

    - YugabyteDB: enhanced ALTER script generation from delta model to include comments for schemas, tables and attributes, views 

     

    New features in v6.9.12 [21-Apr-2023]

    - ERD: improved rendering performance for models with large tables

    - Documentation: added handling of custom relationship lines in ERVs

    - Workgroup: added personal token authentication on Azure DevOps Repos when "Allow public projects" is disabled

    - Workgroup: added handling of revoked or renewed personal token on Azure DevOps Repos 

    - Oracle: added meaningful error message when user is missing SELECT_CATALOG_ROLE for reverse-engineering

    - PostgreSQL: added support in ALTER script for changes in check constraints

    - PostgreSQL: increased logging when fetching functions, triggers and procedures

    - PostgreSQL: added option to ignore reverse-engineering of functions, procedures, and triggers

    - Synapse: added logic to fetch table info when referenced in views

    - Teradata: changed library to fetch JAVA_HOME environment variables in Windows and get correct path

    - Teradata: added default port if user does not specify

    - Teradata: added escaping of paths

    - YugabyteDB: added generation ALTER script for changes of precision/scale in numeric and length in strings

     

    New features in v6.9.11 [14-Apr-2023]

    - Polyglot: added option to merge into an existing polyglot model when converting a target model

    - ERD and graph view in polyglot: added adapter to restore lost entity coordinates

    - ERD: fixed auto-scrolling of canvas when mouse button was not pressed

    - Excel export: added export of custom properties when common to different data types

    - Cassandra: added possibility to select multiple CQL files to reverse-engineer

    - Delta Lake/Databricks: enhanced ALTER script generation of comments from delta model so the delete of a comment is disabled by default

    - Delta Lake/Databricks: added possibility to select multiple HQL files to reverse-engineer

    - Delta Lake/Databricks: added handling of serde properties

    - Glue Data Catalog: added button to fetch additional databases beyond the standard Glue limit of 100 databases per request

    - Glue Data Catalog: added possibility to select multiple HQL files to reverse-engineer

    - Glue Data Catalog: added handling of serde properties

    - Hive: added possibility to select multiple HQL files to reverse-engineer

    - Hive: added handling of serde properties

    - MongoDB: added reverse-engineering of wiildcard indexes

    - MySQL: inline/out-of-line primary/unique keys enhancements

    - OpenAPI: added inclusion of default display options in Schema ERD tab

    - PostgreSQL: added generation ALTER script for changes of precision/scale in numeric and length in strings

    - ScyllaDB: added possibility to select multiple CQL files to reverse-engineer

     

    New features in v6.9.10 [07-Apr-2023]

    - ERD: improved rendering performance for models with many relationship lines

    - ERD: for composite primary keys made of a JSON object, display separator line to include entire object

    - Properties Pane: added restriction so nested fields aren't accidentally selected as Primary Key

    - Custom path for custom properties: suppressed extraneous config migration

    - Excel export: added possibility to include custom properties that are repeated in complex data types

    - Excel export: added absolute reference for validation rules in empty lines

    - Model definitions: fixed conversion when attributes are part of composite primary key

    - Print diagram: fixed issue with disappearing relationship lines

    - Delta Lake/Databricks: enhanced ALTER script generation from delta model to include comments for schemas, tables and attributes

    - MongoDB: added support for wildcard indexes

    - MariaDB/Oracle/PostgreSQL/SQL Server/YugabyteDB: inline/out-of-line primary/unique keys enhancements

    - Snowflake: enhanced table detection logic to accommodate recent shortcomings in Snowflake's showTables() function

    - Synapse: added logging for Azure Active Directory authentication with MFA

     

    New features in v6.9.9 [31-Mar-2023]

    - ERD: added drag-sand-scroll possibility towards left and top of canvas

    - Compare and merge: added merging of ERDV container properties

    - Polyglot: disabled possibility to add views which should only appear in physical target models

    - Workgroup: added handling of legacy Azure DevOps DNS and URLs when matching remote origin of repo

    - Workgroup: added handling of fatal git client error wrongly identifying "not a git repository" in history screen

    - Workgroup: added warning badge in Tools > Options > Default Paths > Models as path is overwritten by selected repo location

    - Avro: added default null when multiple data types in oneOf choices

    - Oracle: added parsing and storing of table properties in DDL reverse-engineering

    - PostgresSQL: added tolerance for nextval and other functions in default of columns

    - YugabyteDB: added tolerance for nextval and other functions in default of columns

     

    New features in v6.9.8 [24-Mar-2023]

    - Polyglot: allowed derive of multiple data types to RDBMS when JSON column is supported

    - Polyglot: enabled ability to infer PKs and FKs

    - Cassandra: adjusted comparison to handle missing properties

    - Amazon AWS DynamoDB and S3: harmonized support for HTTP(S) proxies and company-issued certificates (self-signed)

    - MongoDB: added connection to serverless cluster on Atlas

    - MongoDB: added parsing of ISODate sample when simple date format without time/timezone

    - MongoDB: added validation for JSON Schema drafts later than draft-04 when multiple data types with string and date

    - Oracle reverse-engineering: added parsing of supplemental log data and group syntax in DDL

    - ScyllaDB: adjusted comparison to handle missing properties

    - Snowflake: relaxed URL checks to accommodate change in non-VPS account locator formats with some regions missing a cloud provider extension

     

    New features in v6.9.7 [17-Mar-2023]

    - Compare and merge: added granular selection in merge dialog for ERDVs

    - Custom path for custom properties: adjusted directory structure to match default setup and allow for ExcelOptions

    - ERD: added scrolling when dragging objects outside canvas

    - Added warning badge when duplicate technical names detected in same entity regardless of naming conventions settings

    - Avro: adjusted data type conversion when reverse-engineering Oracle DDL for numbers with no precision specified to DECIMAL(38)

    - Azure Blob Storage and Azure Data Lake Storage for Avro, JSON Schema and Parquet: harmonized support for HTTP(S) proxies and company-issued certificates (self-signed)

    - JSON Schema preview and forward-engineering: filter deactivated objects

    - MongoDB: added Load Balanced option in Advanced tab of connection settings to connect to cluster with such topology

    - PostgreSQL: added escaping of special characters in DDL generation for views

    - SQL Server: allowed self-signed certificates for all authentication methods

    - YugabyteDB: added escaping of special characters in DDL generation for views

     

    New features in v6.9.6 [12-Mar-2023]

    - ERD annotations for graph models

     

    New features in v6.9.5 [10-Mar-2023]

    - Polyglot: added subclass relationship connector for logical modeling use cases

    - Undo/redo: now also takes into account changes in Display Options toggle hide/display attributes

    - Excel import into Avro: unmuted error caused by container-level dependency to avoid hanging dialog

    - FK relationship creation from Properties Pane: allowed same flexibility as drag-and-drop when concerning nested references to definitions

    - Tech stack: replaced AWS SDK library v2 with v3 plus @aws-sdk/client-s3 and @aws-sdk/client-dynamodb to reduce bundle size

    - Documentation generation: fixed error for cases when ERDVs contain custom relationship style

    - XSD reverse-engineering: improved handling of cardinality in normalization when PowerDesigner XSD nested entities to represent FK relationships

    - Avro: adjusted data type conversion to decimal when reverse-engineering Oracle DDL for numbers with precision larger than 18 

    - MongoDB: added possibility for direct connection to Atlas by force dispatching 

    - PostgreSQL: added db version check for security_invoker to determine whether to include in DDL script

    - PostgreSQL: adjusted sequence of DDL statements when table index is defined with "Concurrent build" enabled

     

    New features in v6.9.4 [03-Mar-2023]

    - XSD reverse-engineering: added support for xpath declaration of FK relationships

    - XSD reverse-engineering: added support for <xs:unique> tags to creat corresponding constraints

    - Avro: adjusted data type conversion (int vs long) when reverse-engineering Oracle DDL for numbers with precision larger than 9 

    - Delta Lake/Databricks: adjusted default text mode to string when deriving char/varchar from Polyglot

    - Elasticsearch v7 and above: added Faker function-based mock sample generation in bulk

    - Elasticsearch v7 and above: added possibility to apply mappings to instance

    - Glue Data Catalog: disallowed "Clustered By" in forward-engineering if no "Number of Buckets" is declared

     

    New features in v6.9.3 [27-Feb-2023]

    - Relationship line adjustment preservation: stopped triggering orthogonal distribution after import from Excel when no container in model

     

    New features in v6.9.2 [24-Feb-2023]

    - ERD and ERD Views: added separation of Display Options for each and store in model file

    - ERD: adjusted display option Hide Data types to not hide key indicator

    - ERD: many minor enhancements to adjust relationship lines

    - ERD relationship lines adjustments: disallowed oblique lines on recursive relationships

    - Avro: adjusted data type conversion when reverse-engineering Oracle DDL for numbers with precision and scale

    - Polyglot and non-RDBMS targets: added possibility to choose normalization option when reverse-engineering XSDs, JSON Schema or YAML Schema

    - Glue Data Catalog: added logic to fetch table list by chunk beyond the standard Glue limit of 100 tables 

    - Google Storage SDK: harmonized support for HTTP(S) proxies and company-issued certificates

    - Synapse: added support for "Masked by function" property

    - Teradata: enabled export/import with Excel

     

    New features in v6.9.1 [17-Feb-2023]

    - Teradata: added plugin with full data modeling, support for forward-engineering of DDL, and reverse-engineering including inference of schemas in JSON data types

    - Polyglot: added possibility to declare subtypes/subclasses, kept normalized when deriving into RDBMS targets, and converted to oneOf choice subschemas when deriving into targets supporting nested objects

    - ERD: separated position and adjustments of relationship lines in ERD Views from those in the main ERD

    - Undo/redo after copy/paste: adjusted behavior of the undo stack

    - MongoDB: updated driver to latest version, including all dependencies

    - PostgreSQL: added support for security invoker

     

    New features in v6.9.0 [10-Feb-2023]

    - ERD: added possibility to adjust relationship lines by moving anchors and segments, in addition to the previously available moving of entity boxes.  See more info at https://hackolade.com/help/RelationshiplinksinERdiagram.html#Adjust%20relationship%20lines

    - Polyglot: enhanced behavior when deriving from polyglot and an attribute that is part of a FK relationship is marked as "Polyglot only"

    - Network proxy: harmonized support for HTTP(S) proxies and company-issued certificates

    - Workgroup edition: added user notification that stash is being preserved after conflict during stash application (pop)

    - Avro: handling converting choices with subtypes with different fields

    - OpenAPI: added handling for discriminator objects

    - OpenAPI/Swagger: fixed cosmetic overlapping of labels for low-res screens in forward-engineering tab

    - Protobuf: fixed issue when empty options generated undefined results in script

     

    New features in v6.8.6 [03-Feb-2023]

    - Polyglot: disabled PK restriction on foreign master relationships

    - Workgroup Edition: added deletion of source branch after merging a Pull Request in Bitbucket Server

    - Workgroup Edition: allowed opening a Pull Request in Bitbucket Server when it is in status UNAPPROVED

    - Delta Lake/Databricks/Hive: added tab with DDL of view

    - Neo4j: added possibility to apply Cypher scrip to instance in forward-engineering use case

    - Neo4j: updated to v4.4.10 of SDK

     

    New features in v6.8.5 [27-Jan-2023]

    - Compare and Merge Models: generation of delta model for ALTER script when a model has no technical names, while the other has both business names and technical names: fallback on the business names of the model with no technical names

    - Custom properties: added validation and warning badge for multipleCheckboxSelect property

    - JSON document and Schema reverse-engineering: added trimming of invisible characters

    - ERD: prevented duplication of of references during drag-and-drop operations

    - Foreign key relationships: preserve when replacing an attribute by a reference to a definition (internal, model, or external)

    - JSON in RDBMS: enabled simple polymorphism with multiple data types in JSON fields (complex polymorphism was already allowed with oneOf choices)

    - Avro/Parquet: upgrade Azure Blob Storage SDK

    - Avro/Parquet: shortened delay in display of progress bar

    - Avro/Parquet: allowed to open branches without losing previously selected files in other branches

    - Delta Lake/Databricks: added database name to columns in select statement when there is no select statement and columns reference tables in different databases

    - Neo4j: added support for Neo4j v5 and AuraDB, including new indexes and constraints

     

    New features in v6.8.4 [20-Jan-2023]

    - Workgroup Edition: added ability to STASH local changes from the commit screen, plus review, apply, drop, handle conflicts

    - PDF documentation and PDFdiagram print: replaced PhantomJS library for enhanced performance and increased stability

    - JSON Schema: added user-friendly "Display name" property for conditionals for documentation purposes (not forward-engineered, as not part of spec)

    - JSON Schema: prevented possibility to use copy/paste workaround to create multiple conditionals at same level

    - Avro/Parquet reverse-engineering from cloud storage: set default to combine schemas

    - Avro/Parquet reverse-engineering from cloud storage: increased logging of critical operations

    - BigQuery: added configuration of external table options, plus forward- and reverse-engineering of external table options 

    - BigQuery: added support for new JSON data type

    - BigQuery: disabled ability to create multiple data types for a columns

    - BigQuery: disabled possibility to create pattern columns, while leaving the possibility inside a column with JSON data type

    - Couchbase: enabled possibility for numeric fields to be marked as primary key of document type for documentation purposes

    - Couchbase: adjusted reverse-engineering logic to continue process after failure to fetch documents from N1QL query

    - MariaDB: added validation warning for empty index names

    - MySQL: added handling of tablespaces

    - MySQL: added Blackhole engine

    - MySQL: added validation warning for empty index names

    - PostgreSQL: added array type for domain data type

    - PostgreSQL: added forcing user to create UDT according to spec for data types domain, enum, composite, and range_udt https://www.postgresql.org/docs/current/datatype-enum.html

     

    New features in v6.8.3 [13-Jan-2023]

    - References: added shortcut to root level objects or dialog for nested objects in internal and model definitions when adding, inserting, appending

    - Azure Data Lake Storage: improved performance when reverse-engineering Avro, JSON or Parquet files in nested sub-folders

    - Avro: added name property when resolving UDTs

    - Avro: adjusted resolution of references with multiple data types

    - Couchbase: allowed fallback on N1QL for index retrieval if issues encountered in retrieval via REST API

    - MySQL: implemented generation of ALTER script from delta model

    - OpenAPI/Swagger/EventBridge:allowed additional ways to create FK relationships (for documentation purposes) in Schema ERD View tab

    - PostgreSQL: added visual display for array types in ERD

    - Synapse: added handling for empty tableInfo data and null table_type

     

    New features in v6.8.2 [05-Jan-2023]

    - JSON Schema forward-engineering: adjusted filtering of nested definitions when one is undefined

    - Avro: allowed Doc property of a definition to be replaced by reference description

    - Databricks: adjusted count of number of table buckets when reverse-engineering from HQL file

    - Elasticsearch: added reverse-engineering from cloud instance

    - Glue Data Catalog: adjusted count of number of table buckets when reverse-engineering from HQL file

    - Hive: adjusted count of number of table buckets when reverse-engineering from HQL file

    - Parquet: improved speed of reverse-engineering on Azure Data Lake Storage

    - Synapse: improved detection of parent schema of views

     

    New features in v6.8.1 [30-Dec-2022]

    - Excel: added full path in technical names of nested objects

    - Delta Lake/Databricks: added handling of view table properties, plus added numBuckets cast to number

    - Glue Data Catalog: added handling of view table properties, plus added numBuckets cast to number

    - Hive: added numBuckets cast to number

    - PostgreSQL: added support for v15, including new property NULLS [NOT] DISTINCT for columns, table constraints and table indexes

    - PostgreSQL: added support for array types

    - Synapse: added reverse-engineering of views referencing tables in other schemas, and of views in schemas without tables

     

    New features in v6.8.0 [23-Dec-2022]

    - MySQL: added plugin with full support for forward-engineering of DDL, and reverse-engineering including inference of schemas in LONGTEXT data types

    - Tech refresh of Electron (v22.0.0), NodeJS (v16.17.1), Chromium (v108.0.5359.62), V8 (v10.8) and Electron-related modules

    - Mac: fixed shortcut key conflict on Ventura MacOS after screen capture

    - Schema Registries: fixed issue in selection modal when version labels sometimes overlapped when filter is active

    - Cassandra/ScyllaDB: adjusted ALTER script in case of change in Clustering Key

    - MongoDB/DocumentDB/Cosmos DB with MongoDB API: enhanced BSON parser

    - Neo4j and other graph targets: fixed alignment of nodes when not using forced-directed layout

    - PostgreSQL: adjusted parsing of SELECT statements to allow view columns with no underlying table columns (NULL::character varying AS...)

    - PostgreSQL: enhanced reverse-engineering in case of duplicate views in same DDL

    - Redshift: enhanced handling of deactivated columns in forward-engineering

    - Swagger/OpenAPI/EventBridge: enabled copy/paste in responses of interactive SwaggerUI pane

     

    New features in v6.7.3 [16-Dec-2022]

    - Tools > Options > Forward-Engineering: added parameter to skip COMMENT in DDL for SQL and SQL-like targets

    - Reverse-Engineering selection dialog: adjusted filter so schema versions don't require matching

    - Undo/Redo: various enhancements

    - Workgroup: added basic support for git subtrees

    - Workgroup: added possibility to commit and push in a single step, provided that there are commits to be pulled first

    - Workgroup: updated simple-git library to latest version

    - Workgroup: adjusted SSH password prompt modal

    - Workgroup: added logging of git configuration when opening a repository

    - Avro: added inference of Subject Name Strategy during reverse-engineering of Confluent Schema Registry

    - Cassandra: added determination of PROFILE value from DESCRIBE SEARCH INDEX during reverse-engineering

    - Cassandra: removed from ‘Profile’ <spaceSavingNoTextfield> for CQL if DSE version is 6 and higher

    - Cassandra/ScyllaDB: added tolerance for empty lists in reverse-engineering of UDTs

    - Cassandra/ScyllaDB: moved data transfer to UDThelper

    - Cassandra: added check ‘Profile’ values - <spaceSavingNoTextfield> and <spaceSavingSlowTriePrecision> if they are missing in the reference model

    - PostgreSQL: improved parsing of complex functions during reverse-engineering

    - Protobuf: added conversion of array attributes from Polyglot

    - Swagger/OpenAPI: enabled auto-height and auto-width for entities in Schema ERD View

     

    New features in v6.7.2 [09-Dec-2022]

    - Added validation warnings in ObjectBrowser and ERD for deeply nested attributes

    - Workgroup Edition: after creation of Pull Requests, redirect user to My Pull Requests screen

    - Workgroup Edition: added provider-specific help links in Repository Connections dialog

    - Workgroup Edition: added rendering of Pull Request timeline in ascending order for GitHub and GitLab

    - Avro: refactored integration with Confluent Schema Registry to better handle different subject name strategies

    - Avro: added capture of Schema Registry URL during reverse-engineering from Confluent

    - Avro: added generation of subject name according to strategy and schema type unless specified manually

    - Avro: added validation for Topic and Subject properties

    - Collibra: added more user-friendly dialog when attempting to connect with an erroneous URL

    - Delta Lake/Databricks: added support for columns GENERATED AS

    - Swagger/OpenAPI: allowed display options in Schema ERD View

    - Swagger/OpenAPI: added import of FK relationships when deriving Polyglot model into Schema ERD View

     

    New features in v6.7.1 [02-Dec-2022]

    - Polyglot: added normalization of Polyglot choices during derivation into super-type/sub-type for RDBMS targets

    - Polyglot: added creation of references to Polyglot model when converting a target model to Polyglot

    - Compare and Merge: disabled rendering of properties for ghost objects

    - Workgroup Bitbucket Server: enabled network proxy settings, so self-signed certificates in local store are automatically recognized

    - Avro: added support for newly introduced Avro spec feature of symbol default property for enum data type

    - Delta Lake/Databricks: added Azure URL suffix in connections dialog for Azure Storage Access

    - ScyllaDB: applied recent ALTER script logic enhancements from Cassandra plugin for partitioning/clustering keys

    - Snowflake: updated snowflake-sdk package in plugin

    - SQL Server: allowed creation of Foreign Relationships referencing columns that are non-PK as long as they have a UNIQUE constraint

    - Swagger/OpenAPI/EventBridge: added parsing of yaml values as JSON

    - Swagger/OpenAPI/EventBridge: added validation of objects after reverse-engineering to display warning badges in Object Browser

     

    New features in v6.7.0 [25-Nov-2022]

    - Workgroup: added support for GitLab Cloud (gitlab.com) and GitLab Server (self-hosted) for workflow to submit and review Merge Requests

    - Workgroup: added showing username and display name for change requests

    - Workgroup Bitbucket Cloud: enabled network proxy settings

    - Network proxy: added possibility to specify a .pac file URL for backend functions such as forward- and reverse-engineering

    - Compare and Merge: adjusted matching for objects inside moved objects

    - Excel: adjusted handling of multiple JSON complex types

    - Avro: reverted mapping of date/time/timestamp fields to semantic meaning when converting from DDL and JSON Schema and inference of JSON data

    - Cassandra: removed duplicated udt in list/set/tuple when reverse-engineering from instance

    - Cassandra: removed business and technical names from array items to keep just display name

    - Delta Lake/Databricks: allowed column lists to be used for aliases as well as filter of columns from SELECT statements when reverse-engineering from instance

    - Hive: added forward- and reverse-engineering of AS SELECT statement for views

    - Hive: added forward-engineering of comments

    - OpenAPI/Swagger: added lower tab "Schema ERD view" to enhance visualization of definitions/component schemas

    - Parquet: reverted mapping of date/time/timestamp fields to semantic meaning when converting from DDL and JSON Schema and inference of JSON data

    - ScyllaDB: removed duplicated udt in list/set/tuple when reverse-engineering from instance

    - ScyllaDB: removed business and technical names from array items to keep just display name

     

    New features in v6.6.4 [18-Nov-2022]

    - Polyglot: added possibility to insert attributes in entities of target model derived from Polyglot

    - Polyglot added impact analysis when calling references refresh from entities

    - Network proxy: added possibility to specify a .pac file URL for access to license server and plugin manager

    - Network proxy: enhanced logging of proxy settings on application startup

    - Workgroup Bitbucket Server: added tolerance for slashes in usernames when displaying Pull Requests

    - Custom properties: allowed defaultValue property in custom tabs

    - Cassandra: adjusted reverse-engineering of list<udt>, and adjusted ALTER script generation in case of list<udt>

    - Cassandra: fix over eager drop/create table when business names are different but technical names are similar

    - Databricks on Azure: added connection tab to declare ADLS storage passthrough credentials

    - Neo4j and other graph targets: allowed dragging graph nodes with force-directed layout if node has edge is dangling

     

    New features in v6.6.3 [11-Nov-2022]

    - Command-Line Interface: added command polyglotDerive to derive a target model from multiple polyglot models

    - Compare and Merge: allowed comparison by name to take array display names into account

    - Polyglot: added possibility to derive target model when FK relationships involve attributes in nested objects

    - Workgroup for Azure DevOps Repos: added ability to automatically detect and use proxy settings

    - Workgroup Bitbucket Server: detect Server version to adapt required connection parameters accordingly

    - Workgroup Bitbucket Server: show detailed message in logs in case or API errors

    - Cassandra: adjusted ALTER script generation when change in PK

    - Delta Lake/Databricks: added property Column List in view Properties Pane to achieve round-trip engineering

    - Delta Lake/Databricks: added parsing of column list from CREATE VIEW statement in HQL file

    - Delta Lake/Databricks: allowed column lists to be used for aliases as well as filter of columns from SELECT statements when reverse-engineering from HQL files

    - Delta Lake/Databricks: added handling of jinja double curly braces in forward-engineering and ALTER scripts

     

    New features in v6.6.2 [04-Nov-2022]

    - Command-Line Interface: added command polyglotDerive to derive a target model from a polyglot model

    - Command-Line Interface: added command polyglotUpdate to update a target model for modifications made to the referenced polyglot models

    - Command-Line Interface: added possibility to forward-engineer schema to schema registries (Confluent, Azure, Pulsar)

    - Documentation: fixed issue generating PDF on Ubuntu 24.04

    - Model API generation: added validation of the template to ensure presence of entity/entities in schema components and resources

    - MongoDB: fixed issue with $jsonschema generation when descriptions include Regex-like expressions

    - Workgroup: enhanced handling of user permission errors when submitting change request for review

     

    New features in v6.6.1 [28-Oct-2022]

    - Workgroup: added display of required permissions in the connection manager when issues with the Personal Access Token

    - Workgroup: changed check of repository permission to circumvent lack of proper decoding of slashes in usernames by Bitbucket Server

    - Workgroup: added check for repo permissions when opening Submit for review page, and when switching repos

    - Workgroup: streamlined flow after repo provider authentication error 

    - Workgroup: added input auto-height when typing multi-line comments in change requests creation and review

    - Workgroup: harmonized icons for closed and reopened Change Requests in timeline and status badge

    - Workgroup: added preserving reviewers when switching panes during Change Requests

    - Workgroup: improved SSH keys errors and SSH URLs handling

    - Polyglot: fixed refresh of cross-target external reference after conversion to local objects

    - Polyglot: default to ER Diagram tab when opening previously save model

    - Avro: adjusted mapping of detected ISO-8601 dates in JSON data reverse-engineering

    - EventBridge: added ability to add recursive references to resource schemas

    - OpenAPI: added ability to add recursive references to resource schemas

    - Parquet: adjusted mapping of detected ISO-8601 dates in JSON data reverse-engineering

    - PostgreSQL: adjusted mapping of timestamps without timezone

    - Redhift: adjusted mapping of detected ISO-8601 dates in JSON data reverse-engineering

    - YugabyteDB: adjusted mapping of detected ISO-8601 dates in JSON data reverse-engineering

     

    New features in v6.6.0 [21-Oct-2022]

    - Workgroup: added support for Azure DevOps Repos for workflow to submit and review Pull Requests

    - Polyglot: added lower tab Graph Diagram view for conceptual modeling

    - Collibra: added storage of Asset URL for objects during reverse-engineering

    - Avro: refactoring of forward-engineering to facilitate enhancements

    - Avro: added detection of conflict in names of references and records

    - Avro: added detection of missing type name for fixed fields

    - Avro: adjusted level for generation of alias of arrays

    - Avro: adjusted resolution of array references

    - Avro: adjusted order of doc property in case of array with aliases

    - Avro: added possibility to create complex schemas to fields with map data type

    - Avro: added handling of choices with empty names

    - Avro: resolved duplicate named complex types with different structures

    - Cassandra: added filtering in views of columns that have been deactivated in the underlying table

    - Delta Lake/Databricks: added warning dialog when views are invalid due to discrepancy with underlying table structure, and need to be refreshed

     

    New features in v6.5.5 [14-Oct-2022]

    - ERD: added logic to automatically create PK in parent table if not exists, when FK relationship is created via drag-and-drop

    - Test data generation: upgraded to FakerJS v7.6.0 library

    - Test data generation: added tolerance for wrapping functions with quotes instead of backticks

    - Markdown documentation generation: fixed to take out link rule in turndownHelper to speed up generation

    - Workgroup Edition: added handling of non-scp syntax for SSH protocol in remote URL of git config file

    - DDL reverse-engineering: added handling of integer and decimal type of SQL Server T-SQL dialect

    - Collibra: added handling for deactivated objects in publishing and reverse-engineering

    - Avro: added handling of fixed type when size is zero

    - BigQuery: added filtering in views of columns that have been deactivated in the underlying table

    - Delta Lake/Databricks: added parsing of properties pane SELECT statement to determine view columns

    - Hive: added filtering in views of columns that have been deactivated in the underlying table

     

    New features in v6.5.4 [07-Oct-2022]

    - YugabyteDB with YSQL API: added plugin with full support for forward-engineering of DDL, and reverse-engineering including inference of schemas in JSON and JSONB data types

    - Workgroup: added filter by file extension for custom certificate selector

    - Workgroup: pre-filled host domain for self-hosted providers with info from opened git repo

    - Workgroup: only allow pem,crt,key,cer file extensions when specifying custom SSL Certificate Authority for Git and Git provider API

    - Delta Lake/Databricks: enhanced reverse-engineering by querying long list of properties in struct data type

    - Delta Lake/Databricks: added possibility to reverse-engineer a view that references tables in another Databricks database

    - MongoDB: added choice between JSON or BSON serialization in data sample of Preview, forward-engineering, and Command-Line Interface

     

    New features in v6.5.3 [30-Sept-2022]

    - Workgroup: added support for Bitbucket Cloud for workflow to submit and review Pull Requests

    - Workgroup: improved handling of custom Certificate Authority

    - Enum and other multi-text inputs: added bulk edit functionality

    - JSON Schema reverse-engineering: added detection and tolerance for UTF-16 encoding

    - JSON Schema: added support in choice subschemas to convert to definition, replace by attributes, and replace by attributes

    - Avro: adjusted type for references in array items

    - Cassandra: added filtering of solr_query column during reverse-engineering

    - Cassandra: added searchIndexProfiles to excluded keys in model comparison and generation of delta model

    - Delta Lake/Databricks: made "if not exists" and "or replace" mutually exclusive

    - Delta Lake/Databricks: added filtering in views of columns that have been deactivated in the underlying table

    - Delta Lake/Databricks: enhanced representation of table properties, converting from textarea to key-value pairs

    - Hive: made "if not exists" and "or replace" mutually exclusive

    - MongoDB: enhanced forward-engineering to Mongoose schema so only relevant definitions are included when choosing separate files option

    - OpenAPI/Swagger/EventBridge: added possibility to resolve external references when forward-engineering, in GUI and Command-Line Interface

     

    New features in v6.5.2 [23-Sept-2022]

    - Polyglot: added an impact analysis screen when updating references from polyglot in a target model, based on the model compare screen

    - Workgroup: added possibility to specify custom SSL Certificate Authority for Git and Git provider API

    - Enum and other multi-text inputs: added up/down controls to re-order list

    - ERD annotations: added an Options tab to control color and font style

    - Forward-engineering of ALTER script from delta model: added user-friendly message if script is empty

    - DDL reverse-engineering: adjusted mapping of timestamp, time, and numeric data types for DB2 dialect

    - Delta Lake/Databricks: enhanced reverse-engineering of cross-database views when script does not include related tables

    - Delta Lake/Databricks: improved parser of view statements with CAST of STRUCT when reverse-engineering from HQL file

    - Delta Lake/Databricks: improved parser of view statements with subqueries in FROM section of SELECT statement

    - MongoDB: enhanced forward-engineering of numerics (int32, long, double, decimal128) to be formatted as BSON instead of JSON

    - Redshift: added possibility to connect to instance without region if stored by AWSCLI

    - Snowflake: added to ALTER script from delta model: schema and table rename, comment set/unset, view add, drop and rename

     

    New features in v6.5.1 [16-Sept-2022]

    - Changed some icons of Display options to be more intuitive and consistent

    - JSON Schema: added support for "dependent schemas" property when both business/technical names are present

    - JSON Schema: added tolerance for "example" keyword during reverse-engineering for draft-06 and above, when the keyword should have been "examples"

    - JSON Schema: added support for references in choice subschemas

    - DDL reverse-engineering into Avro target: adjusted mapping of dates and decimal numbers data types 

    - DDL reverse-engineering: adjusted handling of $$ comments for Snowflake dialect

    - Workgroup edition: implemented automatic transparent use of of repository connection credentials in Git clone, if previously provided for provider

    - Workgroup edition: added tooltip next to Clone button to describe URL pattern

    - Workgroup edition: update styles and layout of history details to match the "Repository files" screen

    - Cassandra: adjusted handling of ALTER script for default values in search index

    - Delta Lake/Databricks:added extra logging, plus stopped querying count in case of absolute sampling in reverse-engineering

    - Redshift: added possibility to connect to instance without credentials if stored by AWSCLI

    - Snowflake: added filtering of metadata columns for external tables during reverse-engineering

     

    New features in v6.5.0 [09-Sept-2022]

    - Workgroup: added support for Bitbucket Server for workflow to submit and review Pull Requests

    - JSON Schema: added support for "dependent required" property when both business/technical names are present

    - Collibra: added handling of multiple choice subschemas during reverse-engineering

    - Delta Lake/Databricks: enhanced parsing of views to handle CAST statements

    - Redshift: added support for serverless instances

    - Snowflake: added detection of insufficient rights to perform reverse-engineering and display user-friendly dialog

     

    New features in v6.4.3 [02-Sept-2022]

    - FK relationships: added display option to toggle relationship names in ERD

    - Compare and Merge: added user-friendly dialog if user chooses models for different targets

    - Compare and Merge: if comparison by GUIDs is not possible, changed default to comparison by technical name (if exist) when generating delta model, instead of business names

    - Compare and Merge: display placeholder when models only differ by their metadata

    - Compare and Merge: difference pager count takes display filter into account

    - Compare and Merge: when invoked from the Commits History view, added possibility to Open model in new instance

    - Cassandra: added filter for table options in ALTER script of delta model

    - Oracle: added support for ON DELETE for FK relationships

     

    New features in v6.4.2 [26-Aug-2022]

    - Infer Primary Keys and Foreign Key relationships: increased probability to infer FKs in some conditions, while restricting other conditions to reduce false positives

    - Foreign Key relationship: swapped order of entities in automatic naming to follow a more common convention: fist table is the FK table, and second table is the PK table

    - Model API: added user-friendly dialog if user chooses inadequate file for API template

    - Collibra: added support for multiple JSON Schema choices in same table

    - Workgroup: made column width adjustable in Explore Repository Files screen

    - Workgroup: allowed to review closed Change Requests when remote branch has been deleted

    - Workgroup: added visual clue that a copy icon is being clicked

    - BigQuery: added filtering of deactivated objects in forward-engineering of DDL in JSON Schema format

    - Delta Lake/Databricks: added support for table options reverse-engineered from instance

    - Delta Lake/Databricks: added maintaining order of fields when detecting JSOn in string columns

    - Delta Lake/Databricks: added filtering of extraneous Scala metadata when reverse-engineering bloom filters

    - Snowflake: added reverse-engineering of stages and external tables

     

    New features in v6.4.1 [19-Aug-2022]

    - Apple Silicon ARM64: added application build optimized for M1 and M2 processors and achieve unprecedented performance

    - Read-Only Viewer: added edition to allow navigation through models for consultation purposes only -- no creation or editing, no forward-engineering (except JSON Schema and Excel) or reverse-engineering.  When connected to Git repositories, also allows pull operations and commenting on change requests.  Request pricing at sales@hackolade.com

    - Polyglot: adjusted behavior so external references in polyglot are derived into target physical models as direct external references, instead of transitive via polyglot model

    - References: added handling if a parent object, being converted to a reference, contains a child attribute itself with a prior reference

    - References: added detection of technical name collision when renaming references after copy/paste

    - Workgroup: added ability to detect and visually resolve conflicts affecting change requests when the source branch becomes out-of-sync with the target branch

    - Workgroup: added handling of multiple worktrees by filtering out their branches

    - Workgroup: merged screens for Explore Models and Explore All Files, plus enhanced aesthetics 

    - Workgroup: enhanced UX for local-only repositories

    - Workgroup: enhance logging to reduce file size and redundancies, enhanced logging with git provider API call details 

    - Avro: enhanced handling of enum symbols when deriving from polyglot

    - BigQuery: added handling of typeMode=required in documentation

    - Collibra: added publishing and reverse-engineering of foreign master relationships in denormalized models

    - Delta Lake/Databricks: throttled fetching databases to accommodate API rate limiting

    - Delta Lake/Databricks: added support for table options reverse-engineered from HQL files

    - DynamoDB: added default JSON data for data types binary and binarySet

    - DynamoDB: added Faker function-based (bulk) sample generation in script tab to apply to instance

    - YAML: added possibility to choose quoting style (unquoted, single-quote, double-quotes) in preview and forward-engineering, including new argument quotingType in CLI forwEng command

     

    New features in v6.4.0 [12-Aug-2022]

    - Tech refresh of Electron (v19.0.10), NodeJS (v16.14.2), Chromium (v102.0.5005.167), V8 (v10.2) and Electron-related modules.  Includes backported fix for CVE-2022-2162 vulnerability

    - WARNING: support for Windows 7 is discontinued with this version

    - Workgroup Edition: improved error handling dialog when user has limited or no access to repository

    - Workgroup Edition: harmonized access to Repository options and hub connections

    - Cassandra/ScyllaDB: as ALTER TYPE syntax has been deprecated starting with Cassandra 3.10 and DataStax 5.0.6, replaced with DROP + CREATE column statements in ALTER script of delta model, plus added display of warning badge for incompatible data type change in Compare & Merge dialog

    - MongoDB reverse-engineering: added timeout in probabilistic schema inference process plus enhanced logging

    - YAML forward-engineering: added double-quote encoding of strings when necessary (semicolons, hash signs, and unicode characters)

     

    New features in v6.3.1 [05-Aug-2022]

    - Detection of outside changes in open model: added handling of models stored and synched on OneDrive

    - Collibra: added handling of relationships when when parent and/or child are in nested objects

    - Compare and merge: enhanced handling when one model has technical names and the other doesn't

    - Compare and merge: enhanced named-based detection to better detect names when differences are minor (underscores between words instead of spaces, etc.)

    - Custom properties: added migration of data models when changing a property from propertyType="select" to propertyType="multipleCheckboxSelect"

    - Workgroup: use commit short hash in model name when opening model from commit history view

    - Workgroup: preserve state and select row of history view when changing context then returning to repository context

    - Workgroup: added auto-refresh of history view when creating or deleting a branch

    - Workgroup: added auto-refresh of history view when discarding local changes from uncommitted row

    - Workgroup: enhanced up and down arrow key navigation in history view to go to previous/next page when available

    - Workgroup: enhanced GitHub OAuth user experience to clarify steps

     

    New features in v6.3.0 [29-Jul-2022]

    - Infer Primary Keys and Foreign Key relationships: for RDBMS targets and related, new feature to automatically help identify candidate PKs and FKs in a model, if not yet explicitly reverse-engineered or declared, based on machine learning and probabilities.  Available in BigQuery, Delta Lake/Databricks, Hive, MariaDB, Oracle, PostgreSQL, Redshift, SQL Server, Snowflake, and Synapse plugins.

    - Compare and Merge: refactored dialogs to allows for all permutations of the Workgroup Edition's screens for review changes, merge conflict, and comparisons between different commits

    - Custom properties: added tolerance for presence of unrelated json files (or backups) in properties_pane/<level> directories

    - Tools > Options > General: added possibility to backup and restore user parameters and connection settings.  Useful also when moving to another machine

    - Workgroup Edition: added repository history screen, including filters by data model, branch, or author

    - BigQuery: added primary key property for documentation purposes only

    - MongoDB: added possibility to reverse-engineer fields declared in validator script but no data type is defined

    - MongoDB: added default creation of _id field when not present in validator script and collection is empty

    - OpenAPI: adjusted validations of text inputs in block inputs

    - Swagger/OpenAPI: added default opening of components if no resources are reverse-engineered

     

    New features in v6.2.5 [23-Jul-2022]

    - Excel:enhanced validation when exporting graph models

    - Model API generation: added help link next to template selection, plus enhanced error message when selected file is not a template

    - Polyglot: added spinner when large model is being derived

    - Polyglot: enhanced handling when replacing a reference to a definition by its attributes

    - Workgroup: reload data model if changes detected after pull operation

    - Workgroup: leverage GitHub GraphQL API to populate list of Pull Requests screen

    - Workgroup: enhanced conflict resolution after merge of local branches

    - Parquet: fixed issue causing 'Too many files opened" message

     

    New features in v6.2.4 [17-Jul-2022]

    - Command-Line Interface: reordered commands

    - Multiple data types: enhanced removal when complex data type is last one left

    - Polyglot: added possibility to give a name to the polyglot link.  Can be helpful when making multiple links to the same polyglot model, for different profiles

    - ArangoDB: allowed custom properties in relationships

    - Avro: enhanced schema validation messages

    - JanusGraph: allowed custom properties in relationships

    - Oracle: enhanced parsing of view SELECT statement

    - Snowflake: enhanced reverse-engineering when data sampling enabled

     

    New features in v6.2.3 [08-Jul-2022]

    - Command-Line Interface: added commands to export and import with Excel from the CLI

    - Polyglot: allowed deviations in attribute business and technical names in target model when deriving from Polyglot

    - Polyglot: adjusted mapping of binary type when reverse-engineering XSD

    - Workgroup: added possibility to link Change Request to assignees from the Submit for review screen

    - Workgroup: added possibility to link GitHub Pull Request to reviewers from the Submit for review and the Check pR screens

    - Cosmos DB with MongoDB API: added possibility to generate synthetic/mock/fake documents and applied in bulk to the instance

    - DocumentDB: added possibility to generate synthetic/mock/fake documents and applied in bulk to the instance

    - Couchbase: added possibility to generate synthetic/mock/fake documents and applied in bulk to the instance

    - Oracle: added tolerance for GET_DDL returning concatenated statements without delimiter

    - Oracle: added SQL terminator to view DDL retrieval

    - PostgreSQL: changed escaping from $ to C-style

    - SQL Server: adjusted mapping of data types when deriving from Polyglot to convert string sizes greater than 8000 to (n)varchar(MAX)

     

    New features in v6.2.2 [04-Jul-2022]

    - JSON Schema: added possibility to declare multiple data types including at least one complex data type without oneOf choice

    - Excel import: added support for relationships on nested attributes

    - Excel import: added support for cross-target references

    - Polyglot: allowed modification of business and technical names for attributes and UDTs/model references

    - Polyglot: added handling of references when multiple derivations from the same polyglot model

    - Workgroup: added auto reuse of provider credentials for Git authentication

    - Workgroup: added GitHub OAuth device flow method

    - Workgroup: added possibility to assign a Pull Request by picking from a list of possible assignable users

    - Workgroup: added handling for Pull Request comments deleted on web console

    - Oracle: added tolerance for GET_DDL returning concatenated statements without delimiter

    - SQL Server: added support for MATCH, ON UPDATE, and ON DELETE for FK relationships

    - SQL Server: allowed use of named instance in connection host parameter

     

    New features in v6.2.1 [24-Jun-2022]

    - Azure Blob Storage and Azure Data Lake Storage (for JSON, Parquet, Avro...): collapsed hierarchical folders so they only get discovered when node is expanded

    - Azure Blob Storage and Azure Data Lake Storage (for JSON, Parquet, Avro...): increased limit of discovered objects to 1000

    - JSON data sample for pattern fields: generate default name by regular expression

    - JSON data sample for fields with data type "any": added handling using sub-object if exists or string

    - JSON Schema: allowed root to be an array (in addition to historic possibility for root to be a document)

    - Polyglot: fixed inconsistency when deriving model definitions/UDTs into a target model

    - Test data generation: upgraded to FakerJS v7.3.0 library

    - Workgroup: adjusted finding consistent source branch during resolution of conflicts during discard

    - Workgroup: prevented lock during background check for remote commits

    - Workgroup: enhanced UX and handling of token expiration state

    - Workgroup: enabled caching for some GitHub API requests

    - Workgroup: enhanced GitHub credentials setup to favor personal tokens, as passwords are now deprecated

    - Workgroup: disabled forbidden actions for users with GitHub read-only tokens

    - Workgroup: added column for authors in lists of change requests

    - Workgroup: added submit and review actions to Repository menu

    - Workgroup: added timestamp tooltip to all screens with relative dates

    - Workgroup: added handling of blocked Pull Requests

    - Hive: adjusted forward-engineering "apply to instance" script with deactivated objects

    - MariaDB: adjusted conversion of sample and default properties when deriving from Polyglot Boolean into tinyint(1)

    - Parquet: enabled primary key property for documentation purposes only

    - PostgreSQL: adjusted mapping when deriving nvarchar from Polyglot to varchar

    - PostgreSQL: added support for MATCH, ON UPDATE, and ON DELETE for FK relationships

    - SQL Server: adjusted conversion of sample and default properties when deriving from Polyglot Boolean into bit

    - SQL Server: adjusted mapping when deriving timestamp from Polyglot to Datetime2

    - Synapse: adjusted conversion of sample and default properties when deriving from Polyglot Boolean into bit

    - Synapse: adjusted mapping when deriving timestamp from Polyglot to Datetime2

    - Synapse: added possibility apply DDL to instance

     

    New features in v6.2.0 [17-Jun-2022]

    - Workgroup: added support for GitHub (.com as well as Enterprise Server) for workflow to submit and review Pull Requests

    - Workgroup: added possibility to authenticate on GitHub using personal token

    - MongoDB synthetic data generation: added progress bar when generating in bulk

    - Documentation generation: added support for recursive references

    - Excel import: added support of string formats

    - JSON Schema: added possibility to generate JSON Schema when subschema of choice inside a data type "any" is scalar

    - Polyglot: fixed selection of multiple keys when they are references to model definitions/UDTs

    - Polyglot: fixed rendering of group input properties when referencing definitions

    - Azure Data Lake Storage (for JSON, Parquet, Avro...): enhanced discovery nested sub-folders when empty 

    - Azure Data Lake Storage: added Advanced tab in Connection Settings for Prefix selection

    - Hive: enhanced apply to instance with commented drop statement

    - PostgreSQL: added validation of primary/unique keys, plus added warnings in forward-engineering script when primary/unique constraints have no keys

    - Redshift: enhanced fetching of tables/views if schema has more than 500 of entities

     

    New features in v6.1.3 [10-Jun-2022]

    - Network proxy: increased logging and error details

    - Polyglot: added enforcement that only a single column can be a primary key, or it should be part of of a compound key

    - Polyglot: added possibility to edit required property in UDTs

    - Polyglot: fixed resolution of references before normalization when applicable

    - XSD: added translation of mxOccurs=1 into required/not null during reverse-engineering

    - Workgroup: added Git status icons to repository explorer tables

    - Workgroup: disabled Pull button when there is no remote tracking branch

    - Avro: forward-engineer Confluent subject name from schemaGroupName property

    - Hive: added the possibility to apply forward-engineering HQL script to instance

    - Hive: adjusted v2 HQL script to filter out v3-specific features

    - MongoDB synthetic data generation: added possibility to specify the number of mock/fake documents to be created and applied to the instance

    - Parquet on Azure Data Lake Storage: enhanced discovery when many non-parquet files are also present

    - Protobuf: updated protobufjs libraries

     

    New features in v6.1.2 [03-Jun-2022]

    - Redrew toolbar and contextual menu icons with SVG for cleaner hi-res displays

    - Workgroup: added possibility to end or continue merge branch process

    - Polyglot: adjusted warning for UUID enums, sample, and examples properties

    - Added "Apply to instance" button for all remaining RDBMS and SQL-like targets: Databricks, Hive, MariaDB, Oracle, PostgreSQL, Redshift, Snowflake, SQL Server, Synapse

    - OpenAPI/Swagger models derived from Polyglot: added ability to edit properties of references

    - RDBBMS and SQL-like targets: added enforcement that only a single column can be a primary key, or it should be part of of a compound key

    - Hive: enhanced handling of constraints rely/no rely, disable novalidate

     

    New features in v6.1.1 [27-May-2022]

    - ERD: added display option in toolbar and Tools > Options > Display to show/hide attribute data types

    - Application log files: enhanced so logs are no longer reset with start of additional application instances -- only when first instance gets started

    - Test data generation: added possibility to specify the number of documents to generate in Tools > Forward-Engineer > JSON documents

    - Test data generation: added Faker function-based sample generation in script tab to apply to instance of concerned targets (MongoDB, Couchbase, Cosmos DB, DocumentDB, JanusGraph, Neo4j, Neptune, TinkerGraph)

    - Test data generation: upgraded to FakerJS v7 library

    - Workgroup: added action to merge branches

    - Couchbase: added ability to reverse-engineer buckets with no N1QL primary index, by automatically falling back to REST API for sampling and schema inference

     

    New features in v6.1.0 [20-May-2022]

    - Generate fake but realistic data for development, testing or demos.  More info at https://hackolade.com/help/Generatemockdatafortesting.html

    - Compare and Merge: added auto-selection of matching method when comparing models with different GUIDs

    - Compare and Merge: added display option to only show conflicts

    - Reference definitions: added support in RDBMS targets for definitions containing polymorphic choices

    - License key validation: enabled Tools > Options so the network proxy settings can be adjusted

    - Workgroup: added auto-discovery of git.exe on Windows in likely places if not specified in system PATH

    - Workgroup: added app version, system info, git version at the top of the git log

    - Workgroup: minimized chatty git logging when auto-checking for remote commits

    - Workgroup: disallowed Review Changes in Push screen if remote branch does not exist

    - Cassandra: added generation of WHERE clause with IS NOT NULL for partition keys, clustering keys, and other selected columns in materialized views

    - MariaDB: added forward-engineering of table comments

    - MongoDB: added possibility to apply to instance Field-Level Encryption parameters in createCollection scripts

    - MongoDB: added detection of Field-Level Encryption during reverse-engineering

    - Oracle: added support for reverse-engineering of identity column

    - Snowflake: added support of identity column in properties and forward-engineering of DDL

    - Synapse: added support for forward- and reverse-engineering of partition keys

     

    New features in v6.0.8 [13-May-2022]

    - References to external definitions: fixed display of relative path

    - Polyglot: added creation of many-to-many join table when normalizing on-the-fly to an RDBMS target during deriving from denormalized polyglot model

    - Workgroup: added Tools > Options Repository check for adequate Git executable when specifying a custom path

    - Workgroup: fixed refresh of model list when checking out a new branch

    - Avro: added min/max length properties for string data type, for documentation purposes only

    - Avro: added support for reverse-engineering of schemas with empty records

    - Delta Lake/Databricks: added fallback for getting view names and improve logging

    - Delta Lake/Databricks: added handling for syntax of USING, BLOOMFILTER, TBLPROPERTIES, and PARTITIONED BY when reverse-engineering from HQL file

    - Delta Lake/Databricks:  added support for forward- and reverse-engineering of DISABLE NOVALIDATE

    - Hive:  added support for forward- and reverse-engineering of DISABLE NOVALIDATE

    - MongoDB version 5 and higher: added support for Time-Series collections

    - OpenAPI and EventBridge Schema Registry: added support for media type including dots

    - Redshift: added support for forward- and reverse-engineering of schema, table, and column comments

    - Synapse: added support for partitioning

     

    New features in v6.0.7 [06-May-2022]

    - Added handling of circular external references in JSON Schema 

    - Added warning when enumerations are not unique

    - Compare & Merge: added dialog asking user to handle unsaved changes

    - Compare & Merge: moved button to generate delta model to the Compare panel

    - Introduced a Read-Only mode for delta models (and future use in model history view of Workgroup Edition)

    - Workgroup Edition: disabled auto-loading of last repository when using the Command-Line Interface

    - Delta Lake: fixed issue when Partition Key was a reference to a definition/UDT

    - MongoDB: re-enabled relationship properties for binary data type

    - Oracle: added generation of constraint names in DDL for composite primary and unique keys

    - Oracle: added support for identity start and increment

     

    New features in v6.0.6 [29-Apr-2022]

    - Excel export/import: added handling of font size and colors for entities and views

    - Excel export: added to the relationships tab the names of parent & child entities and attributes to illustrate GUIDs

    - External references: added a warning when user attempts to self-reference the model, given the risks of circular references

    - License validation: added version number to UserData1

    - Polyglot: enabled composite Primary Keys and Unique Keys

    - Workgroup: added author and date of last commit to Explore > Models and All Files table

    - Azure Blob Storage and Azure Data Lake Storage for JSON and Avro: added 3 authentication methods: Anonymous, Shared Access Signature, and Shared Access Token per container

    - Delta Lake: removed unused modules async and thrift from plugin

    - Synapse 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 v6.0.5 [22-Apr-2022]

    - Improved application startup performance with streamlined license validation process on Windows

    - Custom properties: added handling of property names collision with reserved JSON Schema keywords

    - JSON Schema Preview: added resolution of references in choices

    - Tools > Options: added preservation of changes when changing tabs until applied or exist with OK

    - Polyglot: added composite Foreign Key relationships

    - Workgroup: added Review Changes capability to Commit, Pull, and Push screens

    - Workgroup: added display of Git badges on Welcome Page if recent files or recent folders are git-enabled

    - Workgroup: updated simple-git library to latest version 3.6.0

    - Cosmos DB Gremlin: added validation of endpoint in connection settings

    - Delta Lake/Databricks: added reverse-engineering of database location

    - Delta Lake/Databricks: added forward-engineering of reference descriptions in column comments

    - ScyllaDB: caught up with latest Cassandra plugin developments

     

    New features in v6.0.4 [18-Apr-2022]

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

    - ERD: added shortcut Ctrl+Shift+T (Cmd+Shift+T on Mac) to open the selected entity(ies) in a new tab 

    - Compare & Merge: improved visibility of display options

    - Excel options: moved loading of parameters from application start to forward- and reverse-engineering actions

    - Polyglot: made it more obvious that deriving a target model must be done by first creating a target model from which the pulling action must be performed

    - Polyglot: added possibility to derive a polyglot model from another polyglot model

    - References: added possibility for entities to reference model and external definitions

    - Cassandra: adjusted sequence of ALTER statements from delta model to RELOAD SEARCH INDEX after DROP

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

    - Neo4j: updated plugin to latest driver version 4.4.5

    - Redshift 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 v6.0.3 [08-Apr-2022]

    - Added shortcuts to move between contexts (Data Modeling, Repository, etc...- as well as in View menu

    - Compare & Merge: added display option to filter negligible properties (descriptions, comments, samples, defaults)

    - DDL reverse-engineering: added handling of not-encoded special characters in comments

    - Plugin Manager: added logging for steps plugin installation for better troubleshooting

    - Workgroup: added list of recent repositories in Welcome screen

    - Workgroup: added auto-detect of remote commits

    - Workgroup: added Discard action in commit local changes pane

    - Workgroup: added support for multiple selection in commit local changes pane

    - Workgroup: ensured auto-commit of pulled changes if default changed in Git global config

    - Workgroup: added binding of Enter key to primary action in Repository Context

    - Workgroup: added conflict resolution on repos without remote

    - Workgroup: enhanced Git error dialog to allow copy/paste of message and opening of log file

    - Workgroup: added message when push/pull actions are attempted while offline

    - BigQuery: updated library for parsing views

    - Cassandra: added property and CQL script for search index column option {lowercase: true}  

    - Cassandra: adjusted alter index search and alter column statements logic

    - Databricks: added support for Runtime v10

    - Delta Lake/Databricks: replaced Scala commands in forward- and reverse-engineering by Python commands, to allow more flexible security settings

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

    - MarkLogic: updated SDK driver version

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

    - Protobuf: added reverse-engineering of top-level messages as separate entities created from model definitions when "separate schemas" option is chosen

    - Snowflake: added inference of case-sensitive object names in reverse-engineering of file and instance

     

    New features in v6.0.2 [04-Apr-2022]

    - BigQuery 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 v6.0.1 [01-Apr-2022]

    - Workgroup: added auto-resolution of Git conflicts affecting data model metadata

     

    New features in v6.0.0 [31-Mar-2022]

    - [Optional] Workgroup Edition: for teams to collaborate on data models, with versioning, branching, peer reviews, and DevOps integration through Git repositories.  More info at https://hackolade.com/help/Repository.html  Requires the purchase of an upgrade license key from Professional to Workgroup.

    - Stopped including .chm user documentation in Windows installer -- up-to-date user doc online at https://hackolade.com/help