Hackolade کے پرانے ورژن – تمام ورژنز

- Tech refresh: ElectronJS v44.9.3 (Chromium v152.0.7977.167, NodeJS v24.22.0, V8 v15.2.124.43), and related modules
- External references: adjusted the Reference external definition dialog so that selecting an entity and selecting its attributes are mutually exclusive
- Polyglot: added option to include technical names when converting a model to Polyglot -- see more details at https://hackolade.com/help/HandlingwhenconvertingtoaPolyglo.html
- MEGA: added reverse-engineering of MEGA HOPEX logical models from .xmg exchange files into Polyglot models, from the GUI and the Command-Line Interface -- more features in upcoming releases
- PowerDesigner: added preservation of relationship cardinalities when reverse-engineering a CDM or LDM where the parent entity is a shortcut
- PowerDesigner: added reverse-engineering of free symbols (rectangles, ellipses, titles, text and notes) from CDM and LDM files
- PowerDesigner: added detection of files saved in binary format, with a clear warning before reverse-engineering
- PowerDesigner: added reverse-engineering of comments on primary and unique keys for Snowflake
- Snowflake: added support for comments on primary and unique keys

- Tech refresh: ElectronJS v44.7.2 (Chromium v152.0.7977.149, NodeJS v24.21.0, V8 v15.2.124.37), and related modules
- Compare & Merge: enhanced comparison of composite keys (group properties) when matching by technical or business name instead of IDs to generate more accurate ALTER script
- Excel: enhanced reverse-engineering to handle entity attributes with identical business names
- External references: display unique checkbox for columns in composite unique key in an externally referenced entity, and more generally enhanced handling of block and group properties when creating references
- Forward-Engineering: improved performance when generating JSON or DDL artifacts by computing shared calculations once, most noticeably on models with external references
- Forward-engineering: added tolerance for non-array field lists during extended JSON Schema export
- Grid View: added Supertype group rows plus supertype-subtype related properties
- Polyglot and External references: enhanced object selection with a checkbox tree
- PowerDesigner: added preservation of visual options (background, font, border color) in annotation symbols
- PowerDesigner: added detection of target database version from PDM files
- PowerDesigner: added reverse-engineering of Annotations and Keywords into a custom property
- Supertype groups: added warnings in the derive progress modal when selected entities are not derived due to conceptual choice

- Tech refresh: ElectronJS v44.7.0 (Chromium v152.0.7977.130, NodeJS v24.21.0, V8 v15.2.124.28), and related modules
- dbt: included view columns of derived models
- Documentation: prioritized reference description over definition description for referenced attributes
- ERD: preserved entity and view colors when copy-pasting between Studio instances for graph database targets
- ERD: improved visibility of entity selection highlight when using custom entity colors
- Forward-engineering: when script generation options are set for PK and UK constraints in separate statements, re-ordered so that ADD CONSTRAINT statements appear ahead of CREATE INDEX statements
- References: display composite primary and unique constraints in ERD and documentation for attributes in externally referenced entities
- Symbol Annotations: added styling options for border color, body font color, and body fill
- PowerDesigner: enhanced reverse-engineering of symbol names stored as RTF
- Db2: added tolerance for USING INDEX clauses in DDL reverse-engineering
- Snowflake: added wait for callback server in external browser authentication
- Snowflake: updated snowflake-sdk library and removed many extraneous dependencies

- Tech refresh: ElectronJS v44.5.1 (Chromium v152.0.7977.130, NodeJS v24.21.0, V8 v15.2.124.28)
- Licensing: updated license validation server URLs for QLM v20 upgrade
- dbt: added data_type to source columns
- Polyglot: preserved source attribute and collection identifiers after roll-up or roll-down during supertype derivation for Model Hub lineage
- Supertype-subtypes: added error handling in copy-paste
- Supertype-subtypes: added choice of supertype group materialization in derive dialog
- PowerDesigner: added preservation of ERD layout for relationship anchors and paths
- BigQuery: enhanced usability of the reverse-engineering connection dialog when a project has no datasets
- BigQuery, EventBridge, OpenAPI: updated brace-expansion library
- PostgreSQL: added support for renaming a table or a view in ALTER script of delta models
- Snowflake: updated brace-expansion and momentjs libraries

- Tech refresh of ElectronJS (v44.4.5), NodeJS (v24.21.0), Chromium (v152.0.7977.130), V8 engine (v15.2.124.28), and related modules
- Tech refresh: updated Vitest to version 5 and adjusted unit and feature tests for the new mocking and Node environment behavior
- Tech refresh: sanitized collection structure diagram in stored XSS
- Tech refresh: reconfigured Content-Security-Policy (CSP) in HTTP Security Headers
- Tech refresh: blocked HTML event handlers and inline scripts
- Supertype-subtypes inheritance: de-duplicated entity during derive operation for a subtype that is also a supertype
- Supertype-subtypes inheritance: added handling of roll-up and roll-down materializations resulting in no entity to derive, when related entities are not part of the selection
- PowerDesigner: added support for reverse-engineering Oracle CHAR and VARCHAR2 without a CHAR or BYTE length semantic
- PowerDesigner: added preservation of ERD layout through relative arrangement of tables, views, external shortcuts, rectangles, and annotation boxes
- PowerDesigner: added support for reverse-engineering of stereotypes into the custom property stereotype
- PowerDesigner: added reverse-engineering of column-level custom properties (extended attributes)
- Db2 for z/OS: added support for reverse-engineering of data types without length
- MariaDB, MySQL, Redshift, Synapse, Teradata: added an "All Schemas" entry to the forward-engineering lower tab to generate the script of the whole model, including tables outside any schema
- PostgreSQL: adjusted ALTER scripts of delta model to omit COMMENT ON TABLE when the comment is unchanged
- Snowflake: added COMMENT ON COLUMN statement for a newly added column in ALTER scripts when column comments are generated in a separate statement

- Tech refresh of ElectronJS (v44.4.2), Chromium (v152.0.7977.130), NodeJS (v24.21.0), V8 engine (v15.2.124.28), and related modules
- Glossaries: changed default column separator to semicolon when assigning a new glossary
- Licensing: obfuscated last segment of license keys in log files
- Supertype-subtypes: added an auto-positioning property
- Workgroup: strengthened safeguards when working with Git repositories
- Collibra: added publishing of bound glossary terms during forward-engineering
- Collibra: added mapping of Definition and Définition headers to the description column when assigning a glossary
- PowerDesigner: added support for reverse-engineering of business rules as check constraints
- PowerDesigner: added support for reverse-engineering of extended attributes containing underscores
- Cassandra, ScyllaDB: updated adm-zip library
- Oracle: added an "All Schemas" entry to the forward-engineering lower tab to generate the script of the whole model, including tables outside any schema
- Oracle: update ad-zip and oracledb libraries
- PostgreSQL: added generation of column comments for newly added columns in delta model alter scripts
- Redshift: added support for identity columns with seed, increment, and GENERATED BY DEFAULT in forward- and reverse-engineering

- Tech refresh of ElectronJS (v44.2.0), Chromium (v152.0.7977.76), NodeJS (v24.20.0), V8 engine (v15.2.124.19), and related modules
- Tech refresh: support macOS 12 (Monterey) is discontinued by Chromium. Older versions of Hackolade Studio will continue to run on Monterey, but macOS 13 (Ventura) or later is required to run v8.13.0 and higher
- Supertype-subtypes: extended to include completeness (total or partial) and exclusivity (disjoint vs overlapping)
- Supertype-subtypes: extended to support multiple supertype groups
- Supertype-subtypes: extended to support choice of strategy during derive operation: preserver hierarchy, roll-up (flat or nested), roll-down
- Licensing: limit reuse of desktop license to studio.hackolade.com and specific customer sub-domains
- PowerDesigner: added reverse-engineering of creator, creation date, modifier, and modification date into the remark of each object
- Plugin Manager: ensured plugin ZIP installation cannot write files outside the plugins directory
- External references, Polyglot references: ensured potentially malicious reference links are ignored when refreshing definitions
- BigQuery: eliminated symbolic links to binary files in node_modules/.bin
- EventBridge, OpenAPI, Swagger: updated js-yaml library

- Tech refresh of ElectronJS (v43.6.0), Chromium (v150.0.7871.250), NodeJS (v24.20.0), V8 engine (v15.0.245.31), and related modules
- PowerDesigner: added support for reverse-engineering of UNIQUE property of indexes
- PowerDesigner: added support for reverse-engineering of indexes with expression-only index columns
- Collibra: added publishing of large ERD images with Command-Line Interface
- CosmosDB-with-Gremlin-API, CosmosDB-with-Mongo-API, CosmosDB-with-SQL-API, SQLServer/Azure SQL: updated qs library
- Db2 for z/OS: added support for the GBPCACHE clause in CREATE INDEX statements during DDL reverse-engineering
- EventBridge, OpenAPI: updated fast-uri library
- MarkLogic: updated form-data and qs libraries
- Snowflake: updated brace-expansion and toml libraries
- Teradata: added optional chaining for composite key checks in primary keys and unique keys

- PowerDesigner: added tolerance for recursive child collection during reverse-engineering of CDM files
- PowerDesigner: added tolerance for names and codes composed of numbers only
- PowerDesigner: added tolerance for missing target information in Physical Data Model file
- Db2 for z/OS: added support for Sequences in Properties Pane, reverse-, and forward-engineering
- Db2 for z/OS: added support for reverse-engineering of ON DELETE and ON UPDATE clauses

- Tech refresh of ElectronJS (v43.4.1), NodeJS (v24.18.1), Chromium (v150.0.7871.224), V8 engine (v15.0.245.28), and related modules
- ERD/V: added display option for "Entity name only" data model storytelling
- Grid View: inserted model level in hierarchy
- DBML: added support for reverse-engineering of array datatype in BigQuery
- PowerDesigner: ensured indexes are associated with tables and columns during reverse-engineering
- PowerDesigner: handled message "expansion count limit exceeded" during reverse-engineering
- Couchbase v7+: added support for ALTER script of indexes and collections
- Db2 for z/OS: added support for CHECK CONSTRAINT in reverse-engineering when declared at column level
- DeltaLake/Databricks: limit fetching of Unity catalogs during reverse-engineering when specified in connection settings
- Oracle: enhanced grammar parsing of DDLs with UNUSABLE keyword not being at latest position

- Tech refresh of ElectronJS (v43.4.0), NodeJS (v24.18.1), Chromium (v150.0.7871.224), V8 engine (v15.0.245.28), and related modules
- IBM Db2 for z/OS (mainframe): added plugin with full support for forward-engineering of DDL, and reverse-engineering from offline DDL
- Command-Line Interface: disabled superfluous chromium cache
- DBML: added support for reverse-engineering indexes for MySQL, Oracle, and SQL Server
- DDL forward-engineering: optimized script generation for models with references to user-defined types
- Docker CLI: added support for read-only root filesystem
- Documentation: enhanced robustness of diagrams generation for documentation under heavy load or slow system
- Grid View: added support for copy-paste of dropdown select and multi-select properties
- Grid View: separated Properties Pane visibility from row selection to enhance user focus while editing cells directly in the grid
- PowerDesigner: added support for reverse-engineering of stand-alone view columns
- PowerDesigner: added support for reverse-engineering of computed columns for CockroachDB, PostgreSQL, and SQL Server.
- PowerDesigner: added support for reverse-engineering of sub-shortcuts
- Oracle, Polyglot: added support for stand-alone columns in views without direct reference, for modeling purposes only
- Oracle: allowed GENERATED AS properties of attributes referencing a definition to have their own value
- Snowflake: added support for stand-alone columns in views (without direct reference), for modeling purposes only

- Tech refresh of ElectronJS (v42.8.1), NodeJS (v24.18.1), Chromium (v148.0.7778.280), V8 engine (v14.8.178.38), and related modules
- Tech refresh: upgraded from Vite 7 (Rollup) to Vite 8 (Rolldown)
- Grid View: added inline editing of single and multi-select dropdowns when not basis for dependencies
- ERD/ERDV: enhanced readability of entity, view, and annotation headers by automatically applying the highest contrast font color according to WCAG recommendations
- Glossary: initialized the description of modeling objects with the corresponding glossary term description upon binding
- PowerDesigner: added support for import of self-referencing relationships
- PowerDesigner: added support for reverse-engineering of computed and conditional view columns
- PowerDesigner: added support for reverse-engineering computed columns for tables in Oracle and MySQL
- References: allowed enum properties of attributes referencing a definition to have their own value
- Docker CLI: improved offline validation of perpetual licenses, highlighting near-expiry licenses and enforcing container licensing rules for non-concurrent licenses
- Docker: added support for read-only root filesystem for the hck-cli Docker image published on Docker Hub and hardened the setup for state of the art security standards in K8s
- Workgroup: bound local Git/OAuth listeners to 127.0.0.1 when IPv6 is disabled
- BigQuery: updated brace-expansion and minimatch libraries
- EventBridge: updated brace-expansion and js-yaml libraries
- Glue: updated brace-expansion, minimatch, and yauzl libraries
- OpenAPI: updated fast-uri and js-yaml libraries
- Oracle: adjusted DDL generation so that individual named column NOT NULL constraints remain inline
- Swagger: updated js-yaml library

- Tech refresh of ElectronJS (v42.8.0), NodeJS (v24.18.0), Chromium (v148.0.7778.280), V8 engine (v14.8.178.38), and related modules
- DBML: added reverse-engineering of column level check constraints
- DBML: added reverse-engineering of data samples
- Grid View: added lower tab for Views
- Grid View: added lower tab for Edges
- Grid View: improved performance of global search
- PowerDesigner: added support for reverse-engineering relationships without an explicit parent entity
- PowerDesigner: added default business name "Nameless" for view columns lacking a defined name in Physical Data Model file
- BigQuery: updated brace-expansion library
- Cassandra, Oracle, ScyllaDB: updated adm-zip library
- CosmosDB-with-Gremlin-API, CosmosDB-with-Mongo-API, CosmosDB-with-SQL-API, Snowflake: updated axios library
- EventBridge, OpenAPI: updated js-yaml and fast-uri libraries
- Oracle: added support for reverse-engineering DDL reserved words as identifiers
- Oracle: allowed Oracle-specific scalar properties of attributes referencing a definition to have their own values
- Protobuf: updated protobufjs library
- Swagger: updated js-yaml library

- DBML: added shortcut on each line of grid to jump to object in respective ERD or diagram view
- DBML: added reverse-engineering of attributes with enums
- DBML: added reverse-engineering of table-level check constraints
- DBML: added reverse-engineering of note keyword for projects and tables, whether inline or out-of-line blocks
- DBML: added to Command-Line Interface new argument --source=dbml
- Excel: added entity Height and Width properties to export/import
- Grid View: added inline editing of numeric values
- Grid View: added persistence of default grid configuration in data model file
- Grid View: added configurations to Tools > Options > Backup & Restore
- Naming conventions: changed from asynchronous to synchronous process plus stored snapshot in order to make undo/redo more predictable
- PowerDesigner: added using table name from query clause as a fallback when no tables are specified in the view definition
- PowerDesigner: enhanced parsing of SELECT statements using the Code/Technical Name of related table columns
- Properties Pane: added height and width value properties to Options tab of entities, when respectively auto-height and auto-width are disabled
- Properties Pane: enhanced display of entity boxes in ERD when enabling auto-height and auto-width checkboxes
- Properties Pane: improved performance when changing subtype property

- Composite primary and unique keys: adjusted deletion when tables are external references on tables in another model
- ERD: added multi-selection of internal and model definitions that belong to a derived entity
- ERD: fixed creation of multiple external references when the referencing model has lineage capture enabled
- ERD: fixed buttons visibility for modal dialogs on Windows displays with high scale
- Excel export options: updated structure of custom tabs' properties
- Grid View: added possibility to save and apply named grid view configurations
- Grid View: added ability to copy one cell and paste it into multiple grid cells
- Logging: enhanced behavior when encountering broken project settings file, plus provided fallback to default settings
- Object Browser: added logic to respect enableForReference flag
- PowerDesigner: added mapping of Generated property to our Activated property
- Db2, Oracle, PostgreSQL: added support for Unicode language-specific letters in identifiers
- Snowflake: enhanced grammar parsing of DDLs with COLUMN keyword in ADD COLUMN statements
- Snowflake: enhanced grammar parsing of DDLs with doubled single quotes ('') in comments and column descriptions
- Snowflake: enhanced grammar parsing of DDLs with semicolons inside string literals so they are not interpreted as statement terminators
- SQLServer/Azure SQL: allowed changing subtype property in reference by adding enableForReference flag in config

- Command-Line Interface: fixed empty ERD image in Windows when rendering stopped
- Composite primary and unique keys: arranged display, modification, and forward-engineering when tables are external references on tables in another model
- ERD: allowed multi-select of external ref attributes added in a derived entity
- Grid View: added relationship objects
- Grid View: added ability to edit checkboxes
- Grid View: added <empty> option to column filter
- Grid Vies: added color previews to column color filter
- Grid View: added highlighting of search matches
- Grid View: added properties pane tab names (if other than Details) to column titles in Excel report
- Forward-engineering: filtered check constraints if expression is empty
- PowerDesigner; added warning and log message when imported model contains check constraints with no expression
- Properties Pane: added validation badge when check constraints have an empty expression
- Relationships: created adapter to clear relationships for cases when user had replaced a table with a reference
- CockroachDB, Db2, DeltaLake/Databricks, Hive, MariaDB, MySQL, Oracle, PostgreSQL, SQLServer/Azure SQL, Teradata, YugabyteDB: added validation badge in PP, ERD and OB when check constraints have an empty expression, plus filtered check constraints if expression is empty

- Tech refresh of ElectronJS (v42.5.2), NodeJS (v24.17.0), Chromium (v148.0.7778.271), V8 engine (v14.8.178.33), and related modules
- Grid View: added ability to download the grid content as an Excel report
- Grid View: added per-column filters to narrow down grid content by specific column values
- Grid View: added a hierarchical view for the model-level grid, representing the nested structure of the data model or Diagram View
- Grid View: added possibility to expand all / collapse all when hierarchical view
- Grid View: added the model grid at ERDV Diagram View level
- Licensing: enabled sync of obfuscated license key in browser from desktop
- DDL reverse-engineering: enhanced parser grammar to support advanced constraint clauses
- ERD: fixed issue where relationship lines became disconnected from entity boxes after undoing changes and playing with display options
- Workgroup: added full path location of locally-cloned repo to log file
- Lineage Capture: added clear lineage button in Tools > Options > General to remove all lineage data from the current model
- Avro: added feature flag to ensure appropriate resolution of references during forward-engineering with no impact on other targets
- DeltaLake/Databricks: enhanced reverse-engineering to include comments and content of struct
- Snowflake: enhanced added handling of constraints and comments declared as separate ALTER statements in reverse-engineering
- SQLServer/Azure SQL: added handling of views when underlying tables are missing during reverse-engineering
- SQLServer/Azure SQL: added support for reverse-engineering of system-versioned temporal tables without period columns specified

- Licensing: added ability for admin to hide in browser deployment last segment of a license key in the License Status screen and log files -- for license sync between desktop and browser, one more delivery is needed
- Grid View: added search in column picker, column filter, and group by
- Grid View: added support for inline editing of color property
- Grid View: enabled insertion of line breaks in textarea cells during inline editing using Alt+Enter (Windows) or Option or Shift+Enter (macOS)
- Grid View: adapted layout to offer a user experience closer to Excel
- ERD: ensured appropriate coordinates of containers when adding Views to ER Diagram Views
- ERD: fixed issue where relationship lines became disconnected from entity boxes after undoing changes and playing with display options
- Lineage capture: removed the modal prompting users to enable during reverse-engineering DDL
- DeltaLake/Databricks: disabled Properties Pane ability to pick OR REPLACE and IF NOT EXISTS if user checked Temporary property for both Tables and Views
- MySQL: enhanced reverse-engineering to retain all columns in composite UNIQUE keys, even when overlapping with single-column UNIQUE constraints
- Oracle: added support for local and global indexes
- Oracle: added support for indexes, inclusive of cross-schema indexes, on Materialized Views
- Oracle: removed misleading warning icon next to folder selection of Oracle client folder

- Tech refresh of ElectronJS (v42.4.1), NodeJS (v24.16.0), Chromium (v148.0.7778.265), V8 engine (v14.8.178.31), and related modules
- Grid View: introduced an tabular layout for modeling objects at entity and model level, allowing to sort, filter, and edit properties -- more features in upcoming releases
- Licensing: added ability for admin to hide last segment of a license key in the License Status screen and log files -- on desktop only for now -- browser will also benefit from this feature in an upcoming release
- PowerDesigner: set default table format to "Standard" when reverse-engineering Snowflake PDM files
- Connections: removed Test button at bottom of connection list
- CosmosDB-with-Gremlin-API: updated form-data and ws libraries
- CosmosDB-with-Mongo-API, CosmosDB-with-SQL-API, MarkLogic, Snowflake: updated form-data library
- DeltaLake/Databricks: added support for reverse-engineering global view
- DeltaLake/Databricks: added reverse-engineer of varchar and char column lengths from DDL scripts
- DeltaLake/Databricks: disabled OR REPLACE and IF NOT EXISTS for temporary tables and views
- DeltaLake/Databricks: ensured a new container is created when reverse-engineering object without schema from DDL script
- EventBridge, OpenAPI, Swagger: updated js-yaml library
- Hive, JanusGraph, Neptune-Gremlin, Tinkerpop: updated ws library
- Oracle: added support for cross-schema indexes in properties, plus forward- and reverse-engineering
- Oracle: improved robustness by ignoring empty constraints during forward-engineering
- Oracle: added support for cross-schema indexes ON TABLES
- Protobuf: updated protobuf library
- SQLServer: limited reverse-engineering of procedures only for the selected tables and schema

- Tech refresh of ElectronJS (v42.4.0), NodeJS (v24.16.0), Chromium (v148.0.7778.254), V8 engine (v14.8.178.29), and related modules
- ERD: strengthened anchors of non-auto-positioned relationships so they remain fixed on canvas when attributes are added to connected entity boxes
- Glossary: added support for updating assigned glossaries and bound terms of derived models in impact analysis
- DeltaLake/Databricks: added support for reverse-engineering from Databricks DDL in any target -- warning: this new plugin version requires v8.11.6 or higher of Hackolade Studio core application
- DeltaLake/Databricks: moved reverse-engineering of HQL Files to Tools > Reverse-Engineer > Data Definition Language Files... (DDL)
- Hive: added support for reverse-engineering from Hive DDL in any target
- SQL Server/Azure SQL: improved reverse-engineering logging with detailed query metadata and enhanced query reliability
- SQL Server/Azure SQL: introduced reverse-engineering option to toggle fetching of procedures

- Tech refresh of ElectronJS (v42.3.3), NodeJS (v24.15.0), Chromium (v148.0.7778.218), V8 engine (v14.8.178.28), and related modules
- External references: enabled inheritance of standard and custom properties
- Glossary: added support for assigned glossaries and bound terms in compare and merge models
- Rectangle: added position independence between ERD, Graph View, and ERDVs
- PowerDesigner: added support for reverse-engineering of external shortcuts from Logical Data Model files
- XSD: enhanced reverse-engineering of cardinalities
- Collibra: added support for client credentials (M2M OAuth) authentication for connections (CLI only)
- DataHub: added created and lastModified timestamps to all assets
- DataHub: added support for forward-engineering of Foreign Key relationships
- ElasticSearchV7plus: added a comment in the alter script of delta models to indicate when index recreation is required for index changes
- Redshift: added support for Spectrum external tables linked to AWS Glue catalog, including forward- and reverse-engineering
- Snowflake: updated axios library

- Tech refresh of ElectronJS (v41.7.1), NodeJS (v24.15.0), Chromium (v146.0.7680.216), V8 engine (v14.6.202.34), and related modules
- DataHub: added support for publishing Hackolade custom properties as structured properties in DataHub
- DataHub: added fallback to container name for database asset creation when database property is empty
- ERD: improved reordering of non-FK attributes within the entity box when referencing external definitions
- Glossary: improved reverse-engineering of Excel with bound glossary terms in new and unsaved models
- Glossary: added bound terms to documentation
- PowerDesigner: improved performance of reverse-engineering of large models with numerous diagrams
- PowerDesigner: enhanced resilience for missing tags in Logical Data Models
- CosmosDB-with-Gremlin-API, CosmosDB-with-Mongo-API, CosmosDB-with-SQL-API, MarkLogic, SQLServer: updated qs and tmp libraries
- ElasticSearch: added support, in alter script of delta model, for updating supported mapping parameters, for adding indexes, for updating existing index settings, for adding fields in existing indexes, for adding properties to existing field
- ElasticSearch: added support for applying alter script of delta model to instance
- Oracle: added support for connecting to Autonomous Oracle Database 26ai without wallet when mutual TLS is disabled
- Snowflake when publishing to DataHub: added fallback to container name for database asset creation when database property is empty

- Tech refresh of ElectronJS (v41.7.0), NodeJS (v24.15.0), Chromium (v146.0.7680.216), V8 engine (v14.6.202.34), and related modules
- Tech refresh: migrated storage from Storage.json to hck.dat
- ERDV: ensured appropriate coordinates for restored relationships
- Object Browser: added safeguard for a potential exception in rendering
- Polyglot: prioritized reference descriptions, if present, over definition descriptions in derived models
- Properties Pane validation: avoided false alert badges for enums and samples
- Workgroup: avoided infinite spinner when pulling remote changes while having unsaved changed on a model opened from remote
- BigQuery, CosmosDB-with-Gremlin-API, CosmosDB-with-Mongo-API, CosmosDB-with-SQL-API, JanusGraph, Neptune-Gremlin,Tinkerpop: updated brace-expansion and ws libraries
- DeltaLake/Databricks: added support for reverse-engineering of columns with reserved names hour, minute, and second
- Snowflake: added support for Hybrid tables
- SQLServer: added support for reverse-engineering the ENCRYPTED WITH clause on table columns

- Tech refresh of ElectronJS (v41.5.1), NodeJS (v24.15.0), Chromium (v146.0.7680.216), V8 engine (v14.6.202.34), and related modules
- Tech refresh: updated simple-git and git auth for security alerts (CVEs)
- Browser deployment: enabled OAuth for github.com repos with PKCE for seamless authentication, featuring automatic renegotiation of OAuth access token after expiration
- DataHub: added publishing of Snowflake tags
- DataHub: added support for forward-engineering into an existing DataHub domain
- dbt: added “additional data tests“ to the dbt file header “Custom content injected” if one or more additional data tests are manually entered at the column level for any column in the file
- dbt: added “Custom content injected: none“ in dbt file header if no custom content was included
- PowerDesigner: added reverse-engineering of deeply nested Packages in FIBO (Finance Industry Business Ontology)
- Workgroup Open From: added support for opening larger Azure DevOps Repos, Bitbucket, and GitLab files
- Cassandra, DocumentDB, EventBridge, Glue, Neptune-Gremlin, OpenAPI, Redshift, Snowflake: updated fast-xml-parser, fast-uri, and aws-sdk libraries
- DeltaLake/Databricks: enhanced parsing of views and materialized views during reverse-engineering
- ElasticsearchV7plus: upgraded to latest SDK
- ElasticsearchV7plus: added Routing Partition Size and “required“ setting in Properties Pane, forward- and reverse-engineering
- ElasticsearchV7plus: added support for slow logs index-level settings, including for default data
- Snowflake: added publishing of tags to DataHub
- SQLServer: added encryption algorithm dependency handling in DDL and ALTER script generation

- DBML: added support for reverse-engineering of TablePartial
- dbt: enabled data tests, whether package-based or custom
- dbt: added support for forward-engineering of custom YAML fragments for additional dbt data tests at the column level
- dbt: added support for forward-engineering of 4 built-in data tests at the column level
- dbt: enabled custom header and footer injection in forward-engineering for integration with CI/CD pipelines and support of project-specific configurations
- dbt: added new optional arguments in Command-Line Interface for generating data tests from constraints
- ERD: enhanced resize box behavior to ensure all attribute names are fully visible, including post-reverse-engineering processes
- Excel forward- and reverse-engineering: added support for the pipe "|" character
- Glossaries: ensured transitive inheritance of bound terms for external references and Polyglot derived objects (more than 1 level).
- JSON Schema: enhanced reverse-engineering multi-type fields in the example keyword
- Workgroup Open From: added support for opening larger GitHub files (up to 100 MB)
- Workgroup Open From: improved error handling for files exceeding 25 MB during Save To operations.
- Workgroup: added the required organization in Azure DevOps API URL calls
- Workgroup: enhanced authentication with Bitbucket Server regular API tokens by requiring a username for validation via the REST user endpoint
- CosmosDB-with-Gremlin-API, CosmosDB-with-Mongo-API, CosmosDB-with-SQL-API, Hive: updated axios, basic-ftp, thrift, and uuid libraries
- Oracle: avoided double carriage return (\r\r) in scripts on Windows
- PostgreSQL: added v18.x to list of versions

- Tech refresh of ElectronJS (v41.3.0), NodeJS (v24.15.0), Chromium (v146.0.7680.188), V8 engine (v14.6.202.33), and related modules
- Glossaries: added possibility to assign one or more glossaries of business terms to a data model -- see more details at https://hackolade.com/help/Glossariesofbusinessterms.html
- Glossaries: added the possibility to bind any modeling object to one or more business terms from one or more glossaries, and copy glossary definition to model object description/comment
- DBML: added possibility to import (reverse-engineer) models in Database Markup Language, often created from GenAI prompts -- see more details at https://hackolade.com/help/GenAI-createdDBML.html
- dbt: added support for generating sources.yml files -- see more details at https://hackolade.com/help/dbtschemamodels.html#dbt%20sources
- dbt: added config.incremental_strategy property to specify how new data is loaded into incremental models
- ERD: added possibility to display value of (custom) properties in ERD box
- JSON Schema: enhanced reverse-engineering for $comment of multi-type fields
- Toolbar: added icon to Check for Remote Changes when model opened directly from remote repo
- PowerDesigner: enhanced reverse-engineering to use Index Code instead of Index Name
- PowerDesigner: enhanced reverse-engineering to respect individual supertype/subtype membership in Diagram Views
- BigQuery, DeltaLake/Databricks, PostgreSQL, Redshift, Snowflake, SQLServer: added config.incremental_strategy property to specify how new data is loaded into incremental models
- Cassandra, CosmosDB-with-Gremlin-API, CosmosDB-with-Mongo-API, CosmosDB-with-SQL-API, CouchbaseV7Plus, DocumentDB, EventBridge, Glue, Hive, JanusGraph, Neptune-Gremlin, Protobuf, Redshift, Snowflake, SQLServer, Synapse, Tinkerpop: updated libraries fast-xml-parser, follow-redirects, protobufjs, uuid, and xmldom
- DeltaLake/Databricks: added support for COLLATE clause in column definitions
- OpenAPI: added support for enriching nested properties of a derived component
- Oracle: enhanced default behavior to clear the index logging property
- Teradata: improved handling of index properties for compliance with Compare & Merge

- Tech refresh of ElectronJS (v41.2.2), NodeJS (v24.14.1), Chromium (v146.0.7680.188), V8 engine (v14.6.202.33), and related modules
- dbt: added support for dbt-specific model-level properties and column-level properties
- dbt: added possibility to define custom properties to be included in dbt meta -- see more details in doc page https://hackolade.com/help/dbtschemamodels.html
- dbt: added automatic schema and database properties depending on the target
- Definitions: improved error handling for undefined properties in the Internal Definitions Tree Diagram
- External references: limited data type changes of an attribute in case of multiple references to a definition
- JSON Schema: removed unnecessary subschema wrapper for choices
- Polyglot: added support for excluding specific modeling objects from being converted to Polyglot in Compare & Merge
- Collibra: enabled listing of connections from the Welcome Page
- Avro: added display of ENUM values in the JSON sample of the JSON/YAML Preview tab
- BigQuery, DeltaLake/Databricks, Glue, Hive, MySQL, Oracle, PostgreSQL, Redshift, SQL Server/AzureSQL,Snowflake, Synapse, Teradata: enabled dbt model- and column-level properties, custom properties, and automatic schema-level properties
- DeltaLake/Databricks: added support for reverse-engineering columns named year, month, or day
- MySQL: added support for ON DELETE and ON UPDATE properties of foreign key constraints
- MySQL: added support for combined DEFAULT and ON UPDATE for timestamp fields
- MySQL: enhanced reverse-engineering to automatically include collation in column definitions when missing
- Teradata: updated default value for order keys property to ensure models can be compared

- Governance Platforms: added forward-engineering to DataHub platform for Snowflake data models
- Tech refresh: activated new @hackolade/storage APIs with old storage file
- Plugin Manager: made install button more noticeable to avoid confusion
- Polyglot: added support for excluding specific modeling objects from being converted to Polyglot via reverse-engineering from Excel
- PowerDesigner: enhanced reverse-engineering to import diagram-level comments into corresponding ERDV comments
- PowerDesigner: enhanced reverse-engineering of indexes to handle unique key options
- PowerDesigner: improved data type mapping by converting "long varchar" to "varchar(max)" for SQL Server compatibility
- MariaDB, MySQL: improved handling of default values and data type mapping for nullable timestamps
- Oracle: added support for advanced index compression clauses
- Oracle: enhanced display of Logging property in Properties Pane

- Tech refresh of ElectronJS (v41.2.0), NodeJS (v24.14.0), Chromium (v146.0.7680.179), V8 engine (v14.6.202.31), and related modules
- Tech refresh: replaced outdated react-bootstrap-table library with @tanstack/react-table for improved performance and compatibility with React 18+
- Tech refresh: upgraded react-select to replace deprecated findDOMNode usage for improved performance
- Polyglot: added support for excluding specific modeling objects from being converted to Polyglot (a.k.a. "physical only")
- Contextual menu: replaced deprecated react-native-listener to ensure compatibility with REACT 18+
- Compare & Merge: added support for merging objects with distinct IDs and technical names on one side only.
- ERD: improved robustness when editing relationships in ERD Views
- Verify Data Model: added support for verifying external references
- Views: ensured accurate $ref when creating column view manually on ERD
- CosmosDB-with-Gremlin-API, CosmosDB-with-Mongo-API, CosmosDB-with-SQL-API, Snowflake: updated axios library
- DeltaLake/Databricks: added support for comments on view columns
- SQLServer: added support for comments on view columns

- Tech refresh of ElectronJS (v41.1.0), NodeJS (v24.14.0), Chromium (v146.0.7680.166), V8 engine (v14.6.202.26), and related modules
- Tech refresh: updated to React v18
- Excel: added support for editing column view descriptions
- PowerDesigner: added support for reverse-engineering SQL Server procedures from PDM files
- PowerDesigner: added support for reverse-engineering of Oracle function-based indexes from PDM files
- Oracle: added support for function-based index in properties, forward- and reverse-engineering from DDL and instance
- Synapse: added support for procedures in properties, forward- and reverse-engineering from DDL and instance

- Tech refresh: replaced electron-store to leverage safeStorage API with Credential Manager (Windows), KeyChain (Mac), and Gnome Keyring or KWallet (Linux)
- PowerDesigner: added support for reverse-engineering Oracle check constraints
- Plugin Manager: streamlined plugin update process to reduce risks of anti-virus interference
- Cassandra: allowed addition or removal of keys as deviations on partition key of a derived entity
- DeltaLake/Databricks: created hardened fallback for reverse-engineering discovery of large tables
- SQLServer: added support for procedures in properties, forward- and reverse-engineering from DDL and instance

- Tech refresh of ElectronJS (v40.8.3), NodeJS (v24.14.0), Chromium (v144.0.7559.236), V8 engine (v14.4.258.32), and related modules
- DDL: enhanced support for reverse-engineering of arrays
- Excel export: added shared model link URL to easily open models in Browser
- PowerDesigner: updated reverse-engineering of Oracle timezone and character length semantics
- Cassandra, DocumentDB, EventBridge, Glue, Neptune, Redshift, Snowflake: updated dependent modules
- DeltaLake/Databricks: improved robustness in JSON parsing during reverse-engineering
- Teradata: added support for reverse-engineering of constraints in separate statements

- Documentation: enhanced robustness of PNG image generation for large model ERDs

- Tech refresh of ElectronJS (v40.8.0), NodeJS (v24.14.0), Chromium (v144.0.7559.236), V8 engine (v14.4.258.32), and related modules
- General: introduced ability to manually move and adjust size of dialog boxes
- Documentation generation: fixed a potential race condition causing the process to hang
- ERD View: included graph position of containers and entities when duplicating ERDV
- Excel: enriched forward-engineering with all possible values in conditional columns, such as data type synonyms
- PowerDesigner: added reverse-engineering of technical names for constraints
- PowerDesigner: enabled reverse-engineering of stand-alone symbols with text into Studio rectangle
- PowerDesigner: added support for mapping of interval Oracle data type
- Workgroup: added support to review changes in pull requests from forked repositories to upstream repo
- Workgroup: enhanced support for cloning over SSH on Mac and Linux 64-bit systems
- Avro: added handling for multiple duplicated external definitions during forward-engineering
- BigQuery, CockroachDB, MariaDB, Oracle, PostgreSQL, Snowflake, SQL Server/Azure SQL, YugabyteDB: enhanced forward-engineering of delta model when converting a single PK/UK constraint to a composite PK/UK constraint
- Teradata: enabled flexibility in script generation for controlling constraints in CREATE scripts (3 choices: "In CREATE statement", "In separate statement" or "Ignore"), controllable from Tools > Options > Forward-Engineering parameters, plus from forward-engineering lower tab and via Tools > Forward-Engineer menu
- Teradata: added support for forward- and reverse-engineering of comments at database, table, view, and column levels
- Teradata: added support for constraint and index changes in ALTER script of delta mode

- ERD, ERDVs: enabled highlighting of relationships when selecting foreign keys in the entity box
- Graph Diagram: improved robustness to handle missing visual properties
- PowerDesigner: enabled reverse-engineering of relationship colors and shortcuts for each package/ERDV
- PowerDesigner: enabled reverse-engineering of architecture areas and inner symbols into containers with annotations
- PowerDesigner: added model annotations in Object Browser
- PowerDesigner: added mapping for decimal PostgreSQL data type during reverse-engineering
- Oracle: added handling of lower version when annotations are not supported
- PostgreSQL: enabled configurable SQL script hooks for injecting snippets in ALTER statements of delta model
- Teradata: allowed forward-engineering of separate DDL script files per table
- Teradata: upgraded JDBC Driver to the latest 20.x version

- Tech refresh of ElectronJS (v40.6.1), NodeJS (v24.13.1), Chromium (v144.0.7559.220), V8 engine (v14.4.258.25), and related modules
- Polyglot Relationships: added optional display of relationship verbs and roles on Graph Diagram
- PowerDesigner: added reverse-engineering of descriptions of single constraints (primary and unique key), when supported by the target
- Excel: enhanced reverse-engineering for files generated from models themselves reverse-engineered from PowerDesigner
- Tools > Options > Forward-Engineering: for relevant targets, added possibility to reference files for SQL script hooks
- Workgroup: avoided infinite loop when GitHub CLI authentication first succeeded, then fails due to token removal
- CosmosDB with Gremlin API, CosmosDB with Mongo API, CosmosDB with SQL API, Couchbase, DocumentDB, Elasticsearch, Firebase, Firestore, JSON, MarkLogic, MongoDB: enabled primary key (PK) support for nested attributes in document targets
- BigQuery, CockroachDB, Db2, MariaDB, MySQL, Redshift, SQLServer, Synapse, Teradata, YugabyteDB: added configurable SQL script hooks for injecting snippets before or after CREATE SCHEMA, TABLE, and VIEW statements
- Oracle, PostgreSQL, Snowflake: simplified custom SQL script hook properties into text area (instead of block properties)
- Oracle: enabled configurable SQL script hooks for injecting snippets in ALTER statements of delta model
- Oracle: added support for annotations at user schema (pending Oracle's addition of this feature), Table, Column, View, and Index levels in Properties Pane, forward- and reverse-engineering

- Tech refresh of ElectronJS (v40.4.1), NodeJS (v24.13.0), Chromium (v144.0.7559.173), V8 engine (v14.4.258.24), and related modules
- External references: added support for reverse-engineering of references to YAML Schema files
- Polyglot Relationships: added optional display of relationship verbs and roles
- PowerDesigner: enabled reverse-engineering of colors of containers, entities, and views for each package/ERDV
- PowerDesigner: added reverse-engineering of descriptions of composite constraints (primary and unique key) and indexes
- PowerDesigner: added handling of markdown special characters in descriptions during reverse-engineering
- Collibra: added option to customize mapping to avoid using the Hackolade scope during forward-engineering
- Cassandra, ScyllaDB: updated SDK libraries
- Oracle, PostgreSQL, Snowflake: added configurable SQL script hooks for injecting snippets before or after CREATE SCHEMA, TABLE, and VIEW statements

- Polyglot: added derivation of conceptual relationships carrying attributes in associative entities
- Relationships: apply default technical names logic for relationships during drag-and-drop creation based on parent/child entity/attribute technical names
- Docker: created bypass of HTTP requests when license validated offline
- PowerDesigner: enhanced reverse-engineering of relationships to import verb and constraint type into Polyglot
- PowerDesigner: enriched data type mapping for variations of timestamp and varchar to improve compatibility
- Collibra: added support for publishing configurations to an empty Collibra instance
- BigQuery: enabled flexibility in script generation for controlling constraints in CREATE scripts (3 choices: "In CREATE statement", "In separate statement" or "Ignore"), controllable from Tools > Options > Forward-Engineering parameters, plus from forward-engineering lower tab and via Tools > Forward-Engineer menu
- BigQuery: added support for table description changes and partition filter changes in ALTER script of delta models
- CosmosDB w/ Gremlin API, CosmosDB w/ Mongo API, CosmosDB w/ SQL API, Snowflake: updated axios and qs libraries
- Db2: added support for CACHE and ORDER identity parameters in Properties Pane, forward- and reverse-engineering
- DeltaLake/Databricks: added support for streaming tables in Properties Pane, forward- and reverse-engineering
- DeltaLake/Databricks: added runtime 17 (default) and 18
- Hive: added foreign key generation in the CREATE statement
- MarkLogic, SQL Server/AzureSQL: updated qs library
- Oracle: enabled changes on NOT NULL constraint names for attributes referencing a definition (internal, model or external), allowing for unique constraint name across multiple columns

- Compare and Merge: added support for conceptual and logical Polyglot relationships
- Graph targets and Polyglot Graph Diagram: introduced resizing controls for edge properties box
- PowerDesigner: added support for external shortcuts with entity placeholders to be converted into Hackolade Studio external references
- Collibra: improved assignments publishing robustness when configuration cannot be found
- BigQuery, PostgreSQL, SQL Server/AzureSQL: updated qs and lodash libraries
- BigQuery: added support for table and columns rename, column default, primary key and foreign key relationship constraints, add/delete of schema/table/column/view in ALTER script of delta models
- PostgreSQL: added support for functional indexes with expressions in Properties Pane, forward- and reverse-engineering
- Redshift: added new AWS regions
- Redshift: updated aws-sdk and lodash libraries
- SQL Server/AzureSQL: added support for multiline descriptions in forward-engineering with escaping of new lines
- SQL Server/AzureSQL: added resolution of model definition references in DDL forward-engineering through hydration of objects
- Avro, Cassandra, CockroachDB, CosmosDB w/ Gremlin API, CosmosDB w/ Mongo API, CosmosDB w/ SQL API, Db2, GraphQL, Hive, JanusGraph, MariaDB, Neo4j, Oracle, ScyllaDB, Snowflake, Synapse, Teradata, Tinkerpop, YugabyteDB: updated lodash library
- Cassandra: updated lodash and xml-parser libraries
- Couchbase v7+, Elasticsearch, Elasticsearch v7+, Firebase, Firestore, HBase, OpenAPI, Parquet, Swagger: js-yaml and lodash libraries
- DocumentDB, Glue Data Catalog, Neptune: updated aws-sdk and lodash libraries
- EventBridge: updated aws-sdk, js-yaml, and lodash libraries
- MarkLogic: updated js-yaml, lodash, and qs libraries
- MySQL: updated myslq-sdk and lodash libraries
- Protobuf: updated esbuild, js-yaml, and lodash libraries

- ERD: improved container resize when it contains derived annotations
- Excel: added attributes and FK relationships creation based on name references when no GUID is present
- Mermaid: updated library to latest version 11.12.2
- PowerDesigner: added support for reverse-engineering of sub-packages
- PowerDesigner: added validation of PD extended attributes against Studio custom properties configuration
- PowerDesigner: added warning for unsupported ExtendedComposition tags
- Print Diagram: ensured display of attributes for derived entities
- Collibra: improved relation type recognition during forward-engineering
- Cosmos DB with SQL API: suppressed partitionKey declaration if not specified in model
- Cosmos DB with SQL API, Cosmos DB with Gremlin API: added explicit option /* for included paths in index settings
- Db2: added support for table changes, inclusive columns, in ALTER script of delta model
- Db2: added support for view changes in ALTER script of delta model
- Db2: added support for indexes change in ALTER script of delta model
- Db2: added script with comments on Activated/Inactivated entities (table, view, column) successfully applies to DB2 instance
- Oracle: added support for SUBPARTITION in Properties Pane, forward- and reverse-engineering

- Polyglot: introduced flexible modeling for relationships, allowing gradual refinement from conceptual to logical phases. More info at https://hackolade.com/help/ConceptualtoLogicalwithPolyglotr.html
- Relationships: changed Foreign Master relationship lines from dashed to dotted, so as to leave dashed lines for non-identifying relationships
- Documentation generation: refactored to dynamically reflect the configuration in the Properties Pane
- Excel: enabled reverse-engineering in unsaved models when the Excel file does not contain references to other models
- Collibra: stopped running parallel GET requests to the Collibra API to ease load on customer server
- Collibra: added retry logic if the fetch request runs into error net::ERR_INCOMPLETE_CHUNKED_ENCODING
- Avro: ensured appropriate name validation after derivation from Polyglot
- BigQuery: added support for choice of file granularity when generating DDLs: per model, per schema, or per table
- BigQuery: added support for defining Unique and Alternate Keys (Natural Keys) as modeling metadata documentation
- Cosmos DB: improved reverse-engineering to ensure correct conversion of unsupported types within union definitions
- CosmosDB with SQL API: removed extraneous Binary data type to ensure compliance with native JSON data types
- CosmosDB with Gremlin API, JanusGraph, Neo4j, Neptune, Tinkerpop: updated for compatibility with new Polyglot references when derive from and convert to Polyglot
- Snowflake: updated SDK and lodash libraries, plus replaced Axios with proxy fetch library, plus reordered log file
- Synapse: added resolution of model definition references in DDL forward-engineering through hydration of objects

- License: enabled offline validation for license keys when using Windows Remote Desktop (RDP)
- Polyglot: added possibility to derive edge relationships into another Polyglot model
- Polyglot added alternate key indexes in ERD entity box for referenced and derived entities
- Collibra: added detection of pagination type for fetching configurations in Collibra
- Collibra: improved relation type recognition during forward-engineering
- Avro: added support for unresolved named type when the field references a record derived from Polyglot
- Db2: enabled ALTER script in delta model
- Db2: enabled feature to apply DDLs and ALTER scripts to instance
- Db2: added support for reverse-engineering of constraints when specified separately
- PostgreSQL: added CREATE VIEW statement in alter script of delta model
- PostgreSQL: added support for comment on VIEW column in generated DDL
- PostgreSQL: enhanced forward-engineering to escape special characters in comments using 'E' only when necessary
- Snowflake: added extra logging and a default port value to the configuration to assist with browser redirection issues

- ERDVs: ensured that symbols (annotations and rectangles) are preserved during reverse-engineering from Excel
- Command-Line Interface: added support for converting models to Polyglot data models via polyglotConvert command and related arguments
- Compare and merge: improved rendering and merging of supertype groups
- Custom Properties: resolved false alert regarding undeclared custom property "multipleParentType" for array items
- General: improved handling of default path location in file picker to select a file other than a data model (open and save)
- Impact Analysis: enhanced rendering of entities in tree view when changed to a subtype
- Impact Analysis: changed default checkbox state behavior when an entity is changed to a subtype
- Object Browser: added a delete option in the contextual menu for relationships
- Polyglot: enhanced handling of supertype groups during updates of Polyglot definitions
- Polyglot: resolved error when updating Polyglot definitions after changing an entity to a subtype while also modifying existing attributes to references
- Suggest Denormalization: enhanced flexibility in embedding options by leveraging relationship cardinalities to determine whether to use arrays or sub-documents
- Collibra: introduced configurable attribute-level lineage mapping, allowing to choose between direct simple relation and the (default) complex mapping specifications
- Cosmos DB with SQL API, Cosmos DB with MongoDB API: added support for multiple types with complex types to eliminate need for oneOf constructs, plus updated libraries and dependencies
- Db2: introduced flexibility in script generation for controlling constraints in CREATE scripts (3 choices: "In CREATE statement", "In separate statement" or "Ignore"), controllable from Tools > Options > Forward-Engineering parameters, plus from forward-engineering lower tab and via Tools > Forward-Engineer menu, plus plus updated libraries and dependencies

- General: refactored default path location in file picker when selecting SSL/SSH certificates
- Forward-engineering: improved handling of default path location in file picker when selecting target files
- Reverse-engineering: improved handling of default path location in file picker when selecting data model
- Avro: improved forward-engineering by generating type as reference for referenced records in union branches

- General: improve handling default path location of file picker to select a data model
- Object Browser: ensured that relationships name color matches those in ERD and Graph Diagram
- ERD: added name of oneOf choices in entity boxes and object browser
- ERDVs: ensured that relationships line style from ERD is preserved when creating new ERDV
- Persistence: added adapter to remove extraneous empty arrays of complex props
- Avro: added support for unions with named types, with unique names for records, enums, and fixed types to better comply with Avro specs during forward-engineering
- Avro: improved derivation of Polyglot supertype-subtype into oneOf in Avro, using inheritance names as oneOf choice names
- Cassandra: added adjustment for handling partitioning keys
- Delta Lake/Databricks: added adjustment for handling clustering keys
- ScyllaDB: added adjustment for handling partitioning and clustering partition keys

- Polyglot: introduced automatic generation of associative entities for many-to-many relationships during derive operations into Polyglot and RDMBS targets
- References: enabled "Replace by Attributes" functionality in the Properties Pane for Internal, Model, and External references
- Glue, Hive: introduced flexibility in script generation for controlling constraints in CREATE scripts (3 choices: "In CREATE statement", "In separate statement" or "Ignore"), controllable from Tools > Options > Forward-Engineering parameters, plus from forward-engineering lower tab and via Tools > Forward-Engineer menu
- Hive: added support for Hive 4.x as the default version
- BigQuery, CockroachDB, Db2, DeltaLake/Databricks, Hive, MariaDB, MySQL, Oracle, PostgreSQL, Redshift, Snowflake, SQLServer, Synapse, Teradata, YugabyteDB-YSQ: introduced automatic generation of associative entities for many-to-many relationships during derive operations into Polyglot and RDMBS targets

- Desktop application: achieved 30% performance increase when opening application by migrating bundling
- Linux: added SHA-256 checksum file in download S3 folder
- ArchiMate: added support for forward-engineering of complex custom properties of derived modeling objects
- Polyglot: added support for relationships custom color in Graph view
- PowerDesigner: handled missing single primary keys during reverse-engineering of Physical Data Model files (pdm) when structure differs from previously encountered
- PowerDesigner: added support for different format for cardinality during reverse-engineering of PDM files
- References: added visible attribute level $ref property with path to a definition
- References: allowed to create (also change, refresh, and open in a separate instance) a reference at attribute level via the $ref property in Properties Pane
- Views: enhanced properties handling and rendering of attributes marked as Primary Keys in underlying table
- XSD: improved handling of duplicated descriptions in Erwin XSD files
- Oracle: corrected return type of view alter scripts function
- Oracle: added support for named NOT NULL constraints in ALTER scripts

- ArchiMate: added support for forward-engineering of scalar custom properties at model and entity level in Open Exchange file format
- ArchiMate: added support for forward-engineering of complex custom props and relationships in both ArchiMate and Open Exchange file formats
- Custom properties: added ability to declare them for relationships in modelLevelConfig file
- Display options: added support for composite unique keys constrains
- Excel: added support for cross-repository references in forward-engineering and in reverse-engineering, whereby $ref path is exported as defined in the model instead of being converted to absolute path
- Forward-engineering: adjusted compliance in generated JSON sample data, addressing boolean property types, additional properties, and handling of `oneOf` constraints
- Object Browser: added highlight of selected relationship, for consistency with other objects
- Reverse-engineering: enhanced performances by optimizing number of parallel workers for JSON data parsing based on available memory and CPU resources
- Workgroup: added support for sub-groups in GitLab (cloud & server) across all features: Open From, Generate Shareable Link, Save To, and Remote References
- Oracle: added support for removal of primary and unique key constraints in ALTER scripts
- Oracle: added support for removal of comments in ALTER scripts
- Oracle: added support for updating properties of datetime attributes in ALTER scripts
- PostgreSQL: ensured that definition names (UDTs) with special characters (including forward slashes) are correctly resolved throughout DDL generation process

- Documentation: suppressed sidecar windows consuming unnecessary processes and memory

- Remote references: added possibility for cross-repository references to models (Polyglot or external) in a remote location, across different repositories and repository providers
- Memory management: reduced memory footprint of application by 300 MB when opening a model
- Browser: added possibility to create and refresh external and Polyglot references
- ArchiMate: added support for forward-engineering of scalar custom properties at model and entity level in ArchiMate file format (not yet complex custom props, and not yet Open Exchange file format)
- Command-Line Interface: enabled --properties argument in genDoc command
- Documentation: added $ref for entities with external references
- Documentation: eliminated race condition on old and slow Windows machines
- ERD: improved performance for models with large number of relationships
- Properties Pane: added message when number of relationships is greater than 250
- PowerDesigner: added reverse-engineering of technical names ("code") of foreign key relationships
- PowerDesigner: added support for reverse-engineering views based on views
- PowerDesigner: enhanced reverse-engineering of view SELECT statements from Erwin models by cleaning unsupported characters and unnecessary CREATE statements
- Undo/Redo: improved functionality after model conversion
- Collibra: adapted forward-engineering to comply with new stricter configuration rules for complex relation types
- Collibra: added handling of publishing when custom asset types are present
- MariaDB, MySQL: improved reverse-engineering to handle reserved keywords in comments

- Compare & Merge: added support for preservation of layout and colors of graph views, ERD, and ERDVs from right-hand model
- Compare & Merge: adjusted color coding of deleted attributes
- ERDV print diagram: adjusted to occupy entire print area
- Forward-Engineering: added option to skip creation of root folder named after the model, allowing for direct export of files into selected folder
- Object Browser: enhanced search to include ERDV names
- Polyglot: added handling of technical names and naming conventions during conversion, preserving coupling in original model
- PowerDesigner: enhanced reverse-engineering of views generated from Erwin models
- PowerDesigner: added handling of enums without labels
- Command Line Interface: added support for reverse-engineering of PowerDesigner .pdm physical model files
- Undo/Redo: fixed issue where model objects could be created with duplicate IDs after exceeding action stack limit
- Collibra: add new checks for relation types used in assignments
- MongoDB: restored optional relationship inference during reverse-engineering
- PostgreSQL: adjusted timestamp data type mapping when deriving from Polyglot and converting to Polyglot

- Polyglot: added support for technical names and naming conventions, including handling during derive operations depending on the naming conventions in target
- Polyglot: ensured that technical names in target are preserved when updating Polyglot references while naming conventions are inactive
- Polyglot: ensured all technical names are preserved during convert and merge, plus added validation of the target model and improved overall convert performance
- Command Line Interface: added argument applyTargetNamingConventions for polyglotDerive command to control whether to apply the target model’s naming conventions when deriving names
- ERDV: improved performance for basic operations, including faster entity expand, resize, move, and undo actions, along with a delay for relationship line tooltips to reduce blinking during quick mouse movements
- Naming Conventions: unchecked "remove vowels" option by default for all targets in Desktop and Browser
- PowerDesigner: improved reverse-engineering of views in existing models for PDM files generated from Erwin
- PowerDesigner: improved data type mapping to Delta Lake/Databricks and JSON targets, with enhanced warnings and email notifications for unmapped data type
- Oracle, SQL Server: prevented changes in target model after conversion when dependent on Polyglot
- Oracle: improved reverse-engineering from instance to identify new Oracle 26ai version
- Snowflake: enhanced script generation options for alter script of delta models
- Synapse: removed extraneous -- used for commenting

- Tech refresh of ElectronJS (v39.1.0), NodeJS (v22.21.1), Chromium (v140.0.7444.59), V8 (v14.2.231.14) and related modules
- Compare & Merge: improved merging of ERDVs with conflicting names
- ERD & ERDVs: enhanced performance of Undo actions
- Polyglot: preserved physical properties in derived models while maintaining dependencies when converting model
- PowerDesigner: improved reverse-engineering to handle single column references as arrays
- Collibra: removed articulation rules from pre-defined assignments configuration in forward-engineering to comply with new validation rules at Collibra side
- Snowflake: fine-tuned several details when applying script generation options
- Synapse: introduced flexibility in script generation for controlling constraints in CREATE scripts (3 choices: "In CREATE statement", "In separate statement" or "Ignore"), controllable from Tools > Options > Forward-Engineering parameters, plus from forward-engineering lower tab and via Tools > Forward-Engineer menu
- Teradata: improved handling of canceled reverse-engineering process, plus made host field required entry
- Teradata: added handling of reverse-engineer aborting action

- ERD: fixed minor error in entity color picker when color was unchanged
- Db2: replaced query statement with environment variables during reverse-engineering, plus added query to log file
- MongoDB: added aws4 library in public package to allow AWS IAM user authentication and credentials file
- GraphQL: add type for entity during reverse-engineering from instance
- GraphQL: refactored deviations indicators in Object Browser for higher performance
- Snowflake: introduced flexibility in script generation for controlling constraints in CREATE scripts (3 choices: "In CREATE statement", "In separate statement" or "Ignore"), controllable from Tools > Options > Forward-Engineering parameters, plus from forward-engineering lower tab and via Tools > Forward-Engineer menu

- ERDVs: added possibility to duplicate an existing ER Diagram View via contextual menu, toolbar, shortcut, or application menu
- ERD: added warning for generating documentation and printing diagrams with empty names in modeling objects
- Workgroup: implemented lazy loading of assignable users for pull requests to handle slow networks with timeouts and enhance performance
- Workgroup: improved error handling when missing Git client on Windows and encountering the "spawn git ENOENT" error and directing users to relevant documentation
- Collibra: improved performance of forward-engineering of large models
- Collibra: added preliminary check with warning if empty names in modeling objects or out-of-canvas-bounds objects prior to publishing
- YugabyteDB: added support for column-level check constraints

- Tech refresh of ElectronJS (v38.3.0), NodeJS (v22.20.0), Chromium (v140.0.7339.240), V8 (v14.0.365.10) and related modules
- Compare & Merge: improved global performance, particularly noticeable with lineage capture
- ERD: improved performance for zooming, scrolling, selecting, and drag-and-drop actions when handling a large number of relationships
- ERD: improved entity addition from ERDV to ensure new entities are positioned in ERD close to existing ones within the same container
- Excel: added tolerance for primary keys missing their key
- Reverse-engineering: enhanced performance of selection dialog to support displaying large number of entities
- Oracle: added version 26ai
- Oracle: added support for renaming entities and entities in ALTER script
- Oracle: improved application of script generation options in ALTER script
- PostgreSQL: improved application of script generation options in ALTER script
- SQL Server/AzureSQL: added support for reverse-engineering of Microsoft Fabric
- SQL Server/AzureSQL: changed auth methods from Azure AD to Entra ID
- SQL Server/AzureSQL: improved application of script generation options in ALTER script
- Synapse: added support for reverse-engineering of Microsoft Fabric
- Synapse: changed auth methods from Azure AD to Entra ID
- YugabyteDB: introduced flexibility in script generation for controlling constraints in CREATE scripts (3 choices: "In CREATE statement", "In separate statement" or "Ignore"), controllable from Tools > Options > Forward-Engineering parameters, plus from forward-engineering lower tab and via Tools > Forward-Engineer menu

- ERD Display Options: added new display option to toggle display of deactivated objects
- ERD Display Options: added keeping toolbar menu open after selection, until mouse is moved out of the fram
- Object Browser: added option in contextual menu to sort ERDVs alphabetically
- Compare & Merge: removed extraneous Relationships tab in lower half of screen, as information is available in more details in upper half
- Compare & Merge: enhanced filter "Show only differences" to hide unchanged group properties in lower half of screen
- Compare & Merge: added collapsing of unchanged group properties, when filter set to "Show all properties"
- Documentation: added tolerance during generation for missing references to external definitions
- Polyglot: added possibility to define UDT so that it could be derived in CockroachDB, PostgreSQL, and YugabyteDB physical models
- Windows installer: enhanced to provide alternative installation folder and avoid that privileges force Inno Setup to install in AppData, plus updated for Windows 10+ and x64 compatibility
- Workgroup: pass the matching repository root folder when retrieving stashes and tags
- Oracle: added fallback query to fetch table columns meta information without SELECT permission
- PostgreSQL: added support for column-level check constraints
- PostgreSQL: introduced flexibility in script generation for controlling constraints in CREATE scripts (3 choices: "In CREATE statement", "In separate statement" or "Ignore"), controllable from Tools > Options > Forward-Engineering parameters, plus from forward-engineering lower tab and via Tools > Forward-Engineer menu
- YugabyteDB: removed enum, composite, range and domain data types from the data type list to enforce user-defined types for proper declaration in generated scripts

- Tech refresh of ElectronJS (v38.2.0), NodeJS (v22.19.0), Chromium (v140.0.7339.133), V8 (v14.0.365.4) and related modules, including fixes for excessive WindowServer GPU usage and high CPU usage with <input> tag on macOS Tahoe 26
- Security: removed false positives in ReversingLabs evaluation scan of Windows installation package
- Cloud providers: updated AWS, Azure, and GCP SDKs to latest
- ERD Display Options: introduced clearer Tools > Options > Display parameters, toolbar dropdown toggles, and View menu
- ERD Display Options: added new display options: show only foreign keys (FK) and unique keys (UK)
- Faker: changed evaluation of FakerJS expressions to get rid of VM2 library
- Workgroup: removed custom commit message for squash merges, allowing the git provider to generate commit messages based on repository settings
- Collibra: added publishing of multi-select custom properties
- Collibra: added publishing custom properties from custom tab
- PostgreSQL: added fallback query to fetch table columns meta information without SELECT permission
- Snowflake: added handling of tables created from SELECT statements during reverse-engineering
- Synapse: enhanced reverse-engineering to tolerate missing square brackets in partitioning statements
- Synapse: adapted connection screen to replace AAD (Azure Active Directory) by Azure Entra ID, plus replaced Axios with proxy fetch library

- Relationships: added possibility to configure in Tools > Options > General how business names are assembled when creating FK relationships via drag-and-drop
- Command-Line Interface: added argument --pkAtTop to commands forwEng, forwEngAPI, forwEngXLSX
- Diagram Objects pane: consolidated annotations and rectangles under a single symbols entry with sub-menu, plus a help icon lining to the documentation page
- ERD/ERDV: added a placeholder in entity boxes to indicate, when display options are set hide attributes in favor of description, but description is empty
- ERD/ERDV/Object Browser: added badge to visually indicate when an entity or attribute is deactivated
- ERD/ERDV/Object Browser: added badge to visually indicate deviation when adding attributes in entities derived from polyglot
- ERDV: ensured that layout remains unchanged when adding new entity via membership dialog
- Excel: added update of container custom properties values during reverse-engineering
- Excel: enhanced handling of numeric properties so that cleared numeric values in Excel are emptied in the model during reverse-engineering, when the model is derived from polyglot
- Object Browser: added Symbols (currently: annotations and rectangles) in search results, and in search scope dropdown
- PowerDesigner: added handling of geopoint attributes during reverse-engineering into Polyglot and other targets supporting that datatype; to allow array of coordinates
- Collibra: added possibility to configure assetType mapping with custom Collibra IDs
- Oracle: added reverse-engineering of additional table properties
- PostgreSQL: added normalization of arrays of objects when deriving from Polyglot

- Command-Line Interface: added revEng command argument to use index columns in sort criteria for MongoDB reverse-engineering --useIndexInSort=< true | false >
- Custom props: allowed defaultValue property for non-complex custom properties for all modeling objects in native targets
- Documentation: improved robustness by ignoring empty custom tabs
- ERD: created adapter to render visible hidden entities linked to non-existent containers after erroneous user manipulation in Excel
- Excel: enhanced handling of numeric properties so that cleared numeric values in Excel are emptied in the model during reverse-engineering, if the model is not derived from polyglot
- Excel: added support for custom properties for view attributes that can have distinct values from their underlying referenced entity attributes
- PowerDesigner: added reverse-engineering of view technical names
- PowerDesigner: added mapping of data type timestamptz to "timestamp with time zone" when reverse-engineering into PostgreSQL models
- Views: enabled the creation of Views on existing View attributes that lack underlying reference, by extracting data type from SELECT statement
- Avro: resolved schema validation about default: null when resolving reference in model derived from polyglot
- Avro: used technical name of namespace references in schema generation
- Avro: avoid infinite spinner due to race condition when clicking on controls before schema has been generated
- EventBridge: enabled extensions on references
- Snowflake: improved robustness of forward-engineering with view attributes without underlying references
- Synapse: enabled the selection of a column as both an index column and a distribution column

- Relationships: added technical name property with support for naming conventions
- ERD: improved display of rectangle names when positioned at the top of a container
- JSON Schema: mapped business names of view objects to title when technical name is present
- Polyglot: preserved original graph view nodes layout when deriving into a graph target or into another polyglot model
- Polyglot: added handling of relationships marked as polyglot-only when deriving
- PowerDesigner: added support for database views
- PowerDesigner: added disclaimer if source PDM indexes are not compatible with model target
- PowerDesigner: added handling of tag <a:Mandatory> and mapped to required/not null in addition to already handled tag <a:Column.Mandatory>
- Print Diagram: added attribute color coding in Hi-Res PDF
- Workgroup: added segregation of local commits from remote commits in Review Changes screen in respectively Push and Pull screen
- Workgroup: added support for Bitbucket Cloud connection via API tokens with scopes
- Workgroup: added expiration date for Bitbucket Cloud deprecated connections with app password (June 9, 2026)
- CockroachDB, CosmosDB-with-Gremlin-API, DeltaLake/Databricks, Glue, Hive, JanusGraph, MariaDB, Neo4j, Neptune, Oracle, PostgreSQL, SQLServer, Tinkerpop, YugabyteDB-YSQL: added a technical name property with support for naming conventions
- PostgreSQL, YugabyteDB: mapped empty index method to btree during reverse-engineering

- ERD: added possibility to enrich organization of diagrams with rectangle symbol, for example for visual grouping of entities
- ERD: enabled zoom shortcuts to also work with numeric keypad keys (Ctrl++ and Ctrl+-)
- ERDV: prevented orthogonal distribution when adding an entity to existing selection
- Polyglot: allowed custom properties of view attributes derived from Polyglot to deviate from the props of the underlying table
- Avro: added possibility to resolve namespace references also for external references to other Avro models
- CockroachDB, Delta Lake/Databricks, MariaDB, PostgreSQL, SQL Server, Synapse, YugabyteDB: improved generation of ALTER script in forward-engineering when an attribute is added or removed to a composite key
- Db2, Teradata: removed devDependencies from package-lock.json in release artifact
- Glue Data Catalog: added support for AWS Glue 3.0, plus added support for Iceberg tables
- OpenAPI: improved performance on reverse-engineering
- Oracle, PostgreSQL: fixed double index statement in generation of ALTER script in case of new composite key
- PostgreSQL: enhanced sequence of generated ALTER script in forward-engineering

- Delta Lake/Databricks: aligned global option for Request Timeout with the custom deferred requests to Databricks API
- Delta Lake/Databricks: included cluster metadata in logs while fetching the databases info
- ERD: ensured that UK and AK markers remain for attributes involved in multiple composite keys, when composite keys are removed or updated
- ERDVs: added possibility to select only a subset of all subtypes of a supertype
- ERDVs: adjust container size when relationship is manually extended beyond container boundaries
- Excel: hardened checks during import for key constraints referring to non-existent attributes
- Glue Data Catalog: added support for AWS Glue 3.0, plus added support for Iceberg tables

- Compare & Merge: improved message to clarify when no alter script is generated in delta model via CLI due to no changes impacting the database
- ERDV: adapted all ERDVs to accurately reflect changes when an entity is moved to another container which is initially not present in the ERDV
- ERDV: added adapter to redraw relationships based on shortest path between entities while keeping the anchor position on each entity boxes
- Polyglot: added display of block and group custom properties for derived relationships
- XSD reverse-engineering: set “resolve references” to true by default for Erwin source
- Avro: added use of UDT technical name for schema forward-engineering when referencing UDT Enums
- BigQuery, CockroachDB, Db2, Hive, MariaDB, MySQL, Oracle, PostgreSQL, Redshift, SQL Server/Azure SQL, Synapse, Teradata, YugabyteDB: added possibility for views to be based on another view (not just on a table)
- PostgreSQL: added support for single unique constraint options in the alter script of delta models
- SQL Server/Azure SQL: removed extraneous space in comment formatting of DDL forward-engineering
- Snowflake: extend ability to select more file extensions (.pem, .p8, .crt, .cert) when setting up key-pair authentication
- Snowflake: added more user-friendly message in case of missing or invalid passphrase when setting up key-pair authentication
- Synapse: removed extraneous ASC keyword in generated script
- Synapse: added reverse-engineering of (composite) Unique Key constraints

- Print Diagram: added rendering of relationships in ERDV when generating PDF Hi-Res image
- SQL Server/AzureSQL: added adapter when DB version is downgraded from 2025, converting JSON data type into nvarchar with hasMaxLength:true
- Synapse: removed extraneous ASC keyword in Primary Key DDL statement

- Collibra: added support for integration with non-Ultimate Collibra instances (those with Scopes disabled) allowing model publishing through extended global assignments and custom attribute types
- Custom properties: fixed false positive undeclared for native property “error”
- Documentation: improved ERD diagram views to utilize the full page and fit document
- ERDV: improved container resizing behavior when entity is moved to another container
- Polyglot: added display of block and group custom properties for derived objects
- Delta Lake/Databricks: added tolerance for MASK and RELY keyword in column constraints
- Snowflake: added support for key-pair authentication in connection to instances
- SQL Server/Azure SQL: display attribute data type "json" in ERD

- Mermaid added reverse-engineering of attributes on both sides of FK relationships through inference, given that they are not specified in Mermaid ER code
- Mermaid: added Command-Line Interface support with command -revEngDiagram and argument --source=mermaid
- ERD: adjusted font of entity title bar when zooming out to sketchy level
- Polyglot: enhanced handling of name coupling during updates of references
- Polyglot: enhanced model derive process to prevent multiple references to the same Polyglot model, and prompt user for Impact Analysis screen
- Print Diagram: improved performance of PDF generation for large models by reducing the SVG file size significantly
- Print Diagram: adjusted positioning of relationship names in SVG exports to ensure that all names are displayed above the relationship lines
- Print Diagram: added auto-zoom of Graph Diagrams to fit full page
- Delta Lake/Databricks: added possibility for views to be based on another view (not just on a table)
- Delta Lake/Databricks: added support for CLUSTER BY keyword in reverse-engineering
- SQL Server/Azure SQL: added support for v2025, including native JSON data type
- SQL Server/Azure SQL: added automatic generation of FK constraint name if none is specified by user