v8.x
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 Electron (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