v8.x
New features in v8.1.4 [25-Apr-2025]
- Share model link: made all shareable models editable, relying on the license key to enforce whether the model is editable or not, and on the Git repo right to enforce whether the commit should be allowed or not
- Share model link: modified URL structure so that models are no longer in read-only mode
- Save To: allowed saving models with Cyrillic and other special characters
- DDL reverse-engineering: added tolerance for missing semi-column (";") at the end of the last statement
- ERD: added 25% performance enhancements for models with large number of entities
- Polyglot: added handling of relationships deletion through removal of parent entity prior to deriving into physical model
- PowerDesigner: added the reverse-engineering of domains in CDM, LDM, and PDM files into user-defined types/model definitions
- DDL reverse-engineering: added tolerance for missing semi-column (";") at the end of the last statement
- Cosmos DB w/ Gremlin API, JanusGraph, Neptune, Tinkerpop: updated Gremlin client API and patched it to make it compatible with NodeJS 22, plus added ipv6 ssh URL wrapping
- GraphQL: enhanced logging for reverse-engineering
- Hive: added validation of Composite Unique Key name
- Snowflake: added possibility to narrow down selection to a single schema when configuring reverse-engineering connection, to avoid fetching entire warehouse
New features in v8.1.3 [18-Apr-2025]
- Workgroup: added possibility to create a sub-folder on the remote repo during the Save To operation
- Workgroup: improved breadcrumbs with truncating and ellipses in Open From and Save To dialogs to accommodate for lengthy folder names and deep nesting
- Workgroup: added display of full names of remote repositories in the drop-down of local repositories
- Workgroup: changed icon for removing repositories from the list, to clarify that the repo is not deleted
- Documentation: enhanced image generation to include relationships in ERDVs drawn outside container perimeter
- Suggest denormalization: added support for case when multiple relationships to/from one attribute and lineage capture is enabled
- Polyglot: enhanced Impact Analysis screen in OpenAPI derived model when model definition is removed in parent model
- XSD: added handling of primary keys and data types in polyglot models when reverse-engineering from Erwin XSD
- CockroachDB, Db2, Delta Lake/Databricks, Hive, Oracle, PostgreSQL, Teradata, YugabyteDB: added support for Alternate Keys
New features in v8.1.2 [11-Apr-2025]
- Workgroup: added possibility to save data model directly to remote repository (i.e. without need for a locally-cloned repo) either by committing to the current branch or to a new branch. Currently only with GitHub (.com and Enterprise on-prem server). Other providers in upcoming releases.
- Workgroup: added possibility in GitLab to follow a Fork & Pull innersourcing strategy
- Workgroup: added possibility to compare from the tags screen the commits associated with 2 arbitrary tags
- Workgroup: added deletion of local Git tag when deleting it on remote
- Workgroup: enhanced tags screen so table titles don't disappear when scrolling
- Workgroup: added possibility to resize Commit Hash and Commit Date columns in tags screen
- Workgroup: added automatic selection of specific commit in history screen when selecting Show in History View from tags screen
- Workgroup: don't subscribe to model changes if file is opened from history screen
- Command-Line Interface: added command extRefUpdate to update external references of a selected model
- Custom properties: added handling of defaultValue in cross-level dependencies
- DDL reverse-engineering: added performance enhancements
- ERD orthogonal distribution: added performance enhancements and reduction of memory requirements
- PowerDesigner: added a more tolerant data type matching with Levenshtein algorithm (level 2) when importing PDM files with custom data types or for unsupported targets
- Polyglot: added handling of enum data type and its values when deriving into physical targets with enum data type
- Polyglot: added conversion into model definitions when deriving into physical targets that don't support internal definitions
- DocumentDB: added extra helper information in reverse-engineering Collection Selection dialog when AWS credentials do not allow to establish connection
- GraphQL: added reverse-engineering from .graphql (or .gql) files
- GraphQL: added reverse-engineering with schema introspection of URL endpoint
- Snowflake forward-engineering: adjusted statement sequence for dynamic tables based on SELECT AS
New features in v8.1.1 [04-Apr-2025]
- Browser: reduced loading time substantially when opening model from Open Shared Link
- License management: refactored to clean up old Software Key Validation screen replaced by License Status screen, including RDP fine-tuning of computerID
- Polyglot: implemented taking into consideration custom defaultData when deriving from Polyglot
- PowerDesigner: added support for reverse-engineering CDM files
- Workgroup: enhanced the error dialog when creating illegal branch names or tag names, to display the validation rules having failed evaluation
- Workgroup: enriched tag screen with additional metadata: commit hash, author, timestamp, and message
- Workgroup: added possibility to push, delete, and checkout a tag as a new branch
- Workgroup: adjusted connection creation host placeholder to better match the known online Git provider domains
- CockroachDB, Db2, MariaDB, MySQL, Oracle, PostgreSQL, Snowflake, YugabyteDB-YSQL: added mapping to target-specific maximum length when importing from DDL, referencing external definition, or deriving from Polyglot where char or nchar has MAX length
- DocumentDB: enhanced extended logging for AWS-related credentials
- Snowflake: changed sequence of CREATE TABLE statements in DDLs so that regular tables are created first, and before dynamic tables
New features in v8.1.0 [28-Mar-2025]
- Tech refresh of ElectronJS (v35.0.3), NodeJS (v22.14.0), Chromium (v134.0.6998.44), V8 (v13.4) and related modules
- Workgroup: added support for creation of Git tags from Tags screen and from History screen
- Workgroup: added possibility to show tags and consult tag metadata in History screen
- Open From repository: restricted possibility to trial, Workgroup, and Viewer editions
- BigQuery, CockroachDB, Db2, MariaDB, MySQL, Oracle, PostgreSQL, Redshift, Snowflake, Teradata, YugabyteDB-YSQL: added mapping to target-specific maximum length when importing from DDL, referencing external definition, or deriving from Polyglot where varchar or varbinary has MAX length
- DocumentDB: added tolerance for missing credentials when fetching instance metadata
- DocumentDB: added ipv6 addresses enclosing in square brackets
- MongoDB: adjusted parsing of mongodb+srv string
- Oracle: enhanced reverse-engineering of column comments when referencing schema in name
- Snowflake: enhanced reverse-engineering to accommodate dynamic tables
- Teradata: added maximum length of 64000 to char, varchar and varbyte
New features in v8.0.6 [21-Mar-2025]
- dbt: added forward-engineering via Command-Line Interface forwEng command
- Generate documentation: changed default parameters in Tools > Options > Documentation to reduce size by deselecting less often used sections
- Command-Line Interface gendoc: changed command default arguments: --attribTree (complex only), --properties (not empty), --sepContDiag (false), --jsonSchema (false), --jsonData (false)
- PowerDesigner: added reverse-engineering of user tag, mapping it to Hackolade container/schema/group/bucket/database/namespace/keyspace/...
- PowerDesigner: added mapping from SAP SQL Anywhere data types long binary, double, and variable characters to SQL Server
- PowerDesigner: added more information about reverse-engineering progress, plus enhanced performance of ERDV rendering
- Print diagram and Documentation generation: disabled GPU hardware acceleration for rendering diagrams in PNG and SVG formats
- Avro: enhanced user experience in browser when configuring connection to a schema registry instance in the cloud (CORS reverse-proxy)
- Avro: added possibility to reverse-engineer .avro binary files in browser
- BigQuery: added connection enhancement to accommodate self-signed certificates in proxies
- Hive: adjusted adjusted complex datatype and array datatype column in dbt forward-engineering
- Snowflake: added tolerance in DDL reverse-engineering for non-compliant syntax declaring a column NULL property
New features in v8.0.5 [14-Mar-2025]
- Model opening: handled additional causes for false positives of model metadata changes
- JSON Schema: added reference resolution for modified UDT properties
- JSON Schema: fixed mapping of exclusiveMin/Max boolean across draft-04 and later drafts with numeric representation
- Polyglot: fixed derive of exclusiveMin/Max properties when target JSON Schema spec is draft-06 and higher
- PowerDesigner: added reverse-engineering of .pdm files for targets not supported by Hackolade (e.g.: SAP SQL Anywhere)
- XSD reverse-engineering: added tolerance for missing xs: namespace prefixes
- DeltaLake/Databricks: added reverse-engineering of materialized views from file and from instance
- EventBridge, OpenAPI, Swagger: prevented referencing of external definitions at request and response level to force using component schemas
- GraphQL: enabled append/insert options in contextual menu for scalar and enum types
- PostgreSQL: added support for materialized views
New features in v8.0.4 [07-Mar-2025]
- dbt: enabled forward-engineering of models properties schema.yml files for Hive, MySQL, Oracle, SQL Server, and Teradata tables
- dbt: added materialization strategy in model property files
- dbt: forward-engineer only root attributes for complex data type in BigQuery, Databricks, Glue Data Catalog, and Hive
- Model opening: fixed model change false positives caused by validation of selected objects
- PowerDesigner reverse-engineering: added mapping of MAX length for varchar data type in MySQL, Redshift, SQL Server, and Synapse
- Tech: added ESM enforcement by webpack for CI-CD folder
- Avro: allow main app to control the root type behavior and handle multiple data types
- Avro: added display of array item name in ERD
- Avro: added * in ERD for not-nullable union schemas
- Avro: adjusted data type of default value of numeric fields when derived from Polyglot
- DeltaLake/Databricks: added support for materialized views
New features in v8.0.3 [28-Feb-2025]
- browser deployment: added possibility to forward- and reverse-engineer with Confluent Schema Registry in Avro plugin (given the proper license key)
- dbt: enabled forward-engineering of models properties schema.yml files for BigQuery, Amazon Glue Data Catalog, PostgreSQL, Redhift, and Synapse tables
- dbt: added possibility to generate a single models property file per schema/container/dataset
- GraphQL: prevented appending or inserting a field in a choice of a union
- Documentation generation: improved performance and reduced memory footprint for large models
- PowerDesigner: reverse-engineer of .pdm files into Hackolade physical models of any target, currently except for API targets: EventBridge, GraphQL, OpenAPI, and Swagger that require additional development
- PowerDesigner reverse-engineering: added fractional seconds precision for datetime attributes
- Tech: added ESM enforcement by webpack for app folder
- Tech: ensured that software is fully functional in IPv6-only environments. And no claimed capabilities are invalidated if operated in a dual stack (Ipv6 and IPv4) network environment
- Avro: re-ordered properties when data type is multiple for a more logical sequence
- DeltaLake: changed plugin logo to Databricks for better recognition
- Snowflake: improved character escaping in comments when characters are already escaped
New features in v8.0.2 [21-Feb-2025]
- dbt: enabled forward-engineering of models schema.yml files for DeltaLake/Databricks tables
- dbt: add constraints at table and column levels when forward-engineering of models schema.yml files
- GraphQL: enabled auto-generation of SDL in Browser deployment
- GraphQL: added Append/Insert/Add field for union type via contextual menu
- Custom properties: added validator of proper JSON upon loading application
- Polyglot: added representing in ERD the configured sequence of reordered keys in composite primary key for models derived from polyglot
- Polyglot: updated relationships in target model on update of Polyglot definitions if they were changed in the Polyglot model
- MacOS: fix for rendering of a complex ERD image in documentation
- Oracle: added handling of additional keywords to ANTLR grammar for reverse-engineering: GREAD ONLY, GENERATED BY DEFAULT, EDITIONABLE
- Snowflake: added tolerance for escaped single quote inside table comments during reverse-engineering
New features in v8.0.1 [14-Feb-2025]
- dbt: first release of basic forward-engineering of models schema.yml files for Snowflake tables. Will be enhanced with additional features and additional targets in upcoming releases
- Docker: enhanced detection that application is running in Docker image for latest Linux versions and distributions, and alternate container management tools
- Excel: enhanced adapter handling more permutations of (composite) primary keys during reverse-engineering
- Faker: upgraded to latest library version v9.5.0. Beware of breaking changes in Faker functions https://github.com/faker-js/faker/blob/next/CHANGELOG.md and https://fakerjs.dev/guide/upgrading.html#breaking-changes-to-specific-methods
- Tech: finished migration of all modules to ESM
- DynamoDB: allowed views (used for facets and secondary indexes) to have partition and sort keys that are different than for the underlying table
- GraphQL: added grouping of root types (Query, Mutation, Subscription)
- GraphQL: adjusted order of types in forward-engineered SDL
- GraphQL: added possibility to define structured directives
- GraphQL: adjusted order of directive locations
- Oracle: added generation of ALTER script for changes in table-level check constraints
- Oracle: added generation of ALTER script for changes in column data type changes as well as changes in properties: length, precision, offset…
- Oracle: extended the commenting in ALTER scripts to more potentially destructive statements such as modification of data type, shorter columns, etc.
- PostgreSQL: moved sequence creation statements to the beginning of the DDL script
- Snowflake: moved sequence creation statements to the beginning of the DDL script
- Synapse: updated config with synonyms for proper reverse-engineering from PowerDesigner
New features in v8.0.0 [07-Feb-2025]
- GraphQL: added plugin which is currently limited to allowing definition of non-root types and auto generation of GraphQL Schema Definition Language SDL. More enhancements in the coming weeks to achieve model-driven GraphQL API generation
- Excel export/import: implemented composite key constraint definitions at entity level
- Polyglot: allowed to disable Bold font option in derived models
- PowerDesigner: reverse-engineer of .pdm files into Hackolade physical models of the same target, or in a Polyglot model
- Properties Pane: enabled apply button in textarea when copy/paste
- Properties Pane: allowed display of business name in dropdown of parent/child entity of relationships, when technical name display option is selected but entity has no technical name
- Collibra: adjusted reverse-engineering to accommodate Collibra API return code changes
- Avro: adjusted resolution of references on definitions with multiple types.
- Avro: arranged order of field properties when it is a reference on definition with multiple type
- Couchbase v7+: added tolerance to reverse-engineering parsing for unmanaged (undefined) statements
- SQL Server: added synonyms to improve data type mapping for PowerDesigner PDM files
- Snowflake: eliminated redundant table joins in views DDLs
- Snowflake: added support for templates in view Select statement property with SELECT ${viewColumns} for dynamic list of columns
- Snowflake: added support for views <column_list> to allows column name alias and comments