Documentation

No results
    gitHub

    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