Documentation

No results
    gitHub

    v7.x

    New features in v7.3.10 [19-Apr-2024]

    - ERD: paste entity boxes via shortcut in the place where mouse cursor is located

    - Collibra: increased logging in reverse-engineering process

    - Couchbase with scopes and collections: added possibility for multiple indexes plus export in JSON Schema full and extended compliance

    - MongoDB: fixed indicator of views in reverse-engineering entity picker dialog

    - Oracle: added ALTER script for the creation of an index on a newly created table or column

    - Parquet: added schema script tab at model level

    - PostgreSQL: added ALTER script for the creation of an index on a newly created table or column

    - Snowflake: added forward-engineering of composite key constraints

     

    New features in v7.3.9 [12-Apr-2024]

    - Command-Line Interface: allowed space as delimiter between argument key and value, in addition to existing equal sign

    - JSON Schema: added index key name when forward-engineering MongoDB index in Extended compliance

    - JSON Schema: refactored to preserve GUIDs in block/group properties when reverse-engineering files with Extended compliance

    - Workgroup: do not offer option to create local branch if branch of same name exists on remote

    - OpenAPI: limited forward-engineering of examples schema property to OAS 3.1.0+

    - OpenAPI: added requestBody for delete method in OAS 3.1+.  While permitted, the spec advises to avoid it, given lack of precise semantics...

    - Synapse: reduced fetching of metadata to user-defines constraints, filtering out system metadata

    - Synapse: made reverse-engineering more resilient to complete process despite non-blocking errors

    - Synapse: skipped querying DB for sampling if sample is set to zero

    - Synapse: replaced parallel requests to instance with iterative calls via loop

     

    New features in v7.3.8 [05-Apr-2024]

    - Browser deployment: added health check screen, including first tile for config of browser's local storage

    - Naming conventions: adjusted business name validation if no technical name is present

    - JSON Schema export: added possibility to convert model definitions into internal definitions when they are already a subobject an an internal definition

    - Avro: added possibility to convert enum's symbol default to polyglot and derive from it

    - Couchbase with scopes and collections: added detection of multiple data types for collections with no primary index

    - DynamoDB: added restriction of multiple data types to JSON fields only

    - OpenAPI: adjusted generation of example property in sample JSON data when data type is other than string

    - Protobuf: added reverse-engineering of referencing field even if no internal definition is present in file

    - Protobuf: added filter for not referenced definition in individual message scripts

    - Synapse: added explicit config timeout control for query pool

    - Synapse: added API for connection string parsing

    - Teradata: added handling of large data sample

     

    New features in v7.3.7 [01-Apr-2024]

    - JSON Schema forward-engineering: added GUIDs for MongoDB indexes in Extended compliance

    - JSON Schema reverse-engineering: added possibility to reverse-engineer indexes in Full and Extended compliance

     

    New features in v7.3.6 [29-Mar-2024]

    - Avro: added validation of Symbol default property for enum data type

    - Avro: adjusted handling of default for enums in Avro schema forward-engineering

    - DeltaLake/Databricks: show in ERD length from maxLength property for char and varchar data types

    - Elasticsearch: added refresh_interval_unit property

    - Elasticsearch: added time_series_dimensions for ES v8 and up

    - Oracle: added forward- and reverse-engineering of sequences with instance

    - Oracle: added support for sequences in ALTER scrip of delta models

    - Snowflake: added more descriptive message if a view SELECT statement is invalid

    - Snowflake: upgraded libraries to remove potential vulnerabilities

    - XSD reverse-engineering: added error message when circular references are detected

     

    New features in v7.3.5 [22-Mar-2024]

    - Property validation: enhanced use of custom regex in validationRegularExpressions.json custom config file

    - Compare & Merge: added display of differences for custom tabs at model level

    - Multiple data types: fixed handling in native targets (MongoDB, Couchbase, DynamoDB, and JSON) when custom properties are present at field level

    - Browser deployment: added handling with warning when site data is disabled

    - Community edition desktop and browser: enabled some previously disabled forward-engineering function for RDBMS and SQL-like targets -- limit of 50 objects remains

    - Collibra: enhanced handling of views referencing tables not present in the model

    - Databricks: added reverse-engineering of Unity Catalog tags in HQL files

    - OpenAPI: fixed generation of OAS 3.1 examples property when data type is other than string

    - Oracle: added support for creation and handling of sequences

    - Oracle: added DDL forward- and reverse-engineering of sequences from DDL

    - Protobuf: added commenting of schema lines for deactivated messages and columns

    - Protobuf: added handling for commented lines when reverse-engineering schemas

    - ADLS and Blog Storage: added ability to fetch Avro, JSON, and Parquet files in nested folders

     

    New features in v7.3.4 [15-Mar-2024]

    - Object picker dialog: refactored for more intuitive and consistent behavior of search, collapse/expand tree, and select all

    - Excel import: added handling of multiple polyglot references

    - Collibra: added global assignment configuration of foreign master relationships

    - Couchbase: added plugin for support of v7+ with scopes and collections

    - Couchbase v7+: handled race condition in forward-engineering Apply to instance

    - Couchbase v7+: handled creation of a collection even if no scope is declared

    - Elasticsearch v7+: adjusted field properties based on the selected subtype

    - Neo4j: added handling of JSON pattern fields for forward-engineering of properties in Cypher scripts

    - Oracle: added IF NOT EXISTS property for indexes, with dynamic SQL forward-engineering for versions prior to 23c and static SQL with 23c and after

    - Oracle: added reverse-engineering of IF NOT EXISTS in DDLs from 23C and above

    - Oracle: added ALTER script for indexes

     

    New features in v7.3.3 [08-Mar-2024]

    - Improved performance when opening models with new schema validation library (cut time in half)

    - Community edition desktop and browser: enabled some previously disabled functions: text diff, convert to polyglot, and verify data model -- limit of 50 objects remains

    - Entity tab schema tree view: removed 200px max length

    - Documentation and Print Diagram: removed 200px max length in all formats

    - Collibra: added reverse-engineering of logical data dictionaries into polyglot models

    - Databricks: added support for Unity Catalog tags in views

    - Databricks: added handling of Unity Catalog tags in ALTER scripts

    - MongoDB: added reverse-engineering of indexes in JSON Schema files exported with full or extended compliance

    - PostgreSQL: added reverse-engineering of sequences

    - PostgreSQL: added handling of sequences in ALTER scripts

    - PostgreSQL: added handling of indexes in ALTER scripts

     

    New features in v7.3.2 [01-Mar-2024]

    - Enhanced memory usage in model open/close processes

    - Print diagram: increased size of image for PNG format

    - Command-Line Interface: added new argument --references to polyglotUpdate command to allow granular selection

    - Command-Line Interface: deprecated old argument --selecteObjects from polyglotUpdate command

    - BigQuery: added possibility to comment out deactivated relationships in forward-engineering script

    - Databricks Unity Catalog: added support for tags in ALTER scripts of delta models

     

    New features in v7.3.1 [23-Feb-2024]

    - Object browser: significantly reduced memory consumption and increased stability with super large models

    - Collibra: added publishing of Polyglot models to Collibra logical data dictionaries with model/entity/attribute data assets

    - Databricks: added support for tags in Unity Catalog

    - Oracle: added support for function-based indexes

    - Oracle: removed case-sensitivity on inline constraints

    - Oracle: added support for reverse-engineering of hash-partitioned tables, plus composite partitions with LIST subpartitions

    - Polyglot: fixed "max map limit" error upon opening of super large models derived from polyglot

    - PostgreSQL: added support for creation and handling of sequences

    - Protobuf: added possibility to declare single and blocks comments between name and body

    - Synapse: added logger argument

     

    New features in v7.3.0 [16-Feb-2024]

    - Browser: official launch at https://studio.hackolade.com of Community Edition with common code base with Desktop: No credit card. No registration. No download. Runs in browser. No cookies. Local storage of models. Security first.

    - Desktop tech refresh to Electron (v28.2.2), NodeJS (v18.18.2), Chromium (v120.0.6099.276), V8 (v12.0) and related modules

    - Compare & Merge and Impact Analysis: added button to select all deletions

    - Custom properties: fixed editing of group properties on references when using the enabledforReferences template variable

    - Plugin Manager: added detection of lack of Write rights in folder for plugin installation due to anti-virus

    - JSON: added nesting restriction for scalar data types

    - Oracle DDL reverse-engineering: enhanced parser to skip spool statements

    - Snowflake: updated to latest SDK version to circumvent Snowflake limit when sampling rate is higher that SDK's response capacity 

     

    New features in v7.2.3 [09-Feb-2024]

    - DDL reverse-engineering: removed case-sensitivity of columns for PK constraints, indexes, and partitions

    - Polyglot: added support for entity references to handle the fact that this concept exists in Avro

    - Polyglot: added handling of deletion decorative symbols during update of references

    - Workgroup: renamed GitHub Enterprise into GitHub Server, since Enterprise is also available in github.com Cloud

    - Workgroup: removed the OAuth option from GitHub Server

    - Avro: added possibility to edit $ref property for references without definition

    - Collibra: added the possibility to fetch nested Communities

    - Oracle: added reverse-engineering of view comments and view column comments

     

    New features in v7.2.2 [02-Feb-2024]

    - Compare and Merge: added rendering of array items that are references

    - Polyglot Impact Analysis: added rendering of array items that are references

    - Reverse-Engineering from DDLs and XSDs: enriched log file to include system information

    - Collibra: optimized domain fetching logic and performance

    - Delta Lake/Databricks: allow forward-engineering of FK relationships for tables without a schema

    - Excel import: adjusted logic to reverse-engineer edge relationships into polyglot models

    - Oracle: added ability to reverse-engineer Duality View fields defined as simple column references

    - Oracle: relaxed constraint around former reserved keyword SEQ during reverse-engineering and parsing of DDLs

     

    New features in v7.2.1 [29-Jan-2024]

    - Reverted back to Electron v27.2.1 due to issues with workers on MacOS

    - Polyglot and external references: adjusted user experience for relative vs absolute path in file chooser 

     

    New features in v7.2.0 [26-Jan-2024]

    - Tech refresh of Electron (v28.1.4), NodeJS (v18.18.2), Chromium (v120.0.6099.216), V8 (v12.0) and -related modules

    - Infer PKs and FKs: added spinner to prevent user from multiple clicks on submit button

    - Polyglot: added filtering of views when converting target model to Polyglot

    - Polyglot: added comparison of annotation symbols to Impact Analysis screen

    - Polyglot: fixed anomaly during Impact Analysis of of normalized structures

    - Polyglot and external references: streamlined user experience for relative vs absolute path in file chooser 

    - Workgroup Edition: added handling of HTML response from Git server during authentication

    - CockroachDB: added ability to model check constraints, including forward- and reverse-engineering

    - CockroachDB: added ability to model indexes, including forward- and reverse-engineering

    - Collibra: improved logging for publishing of custom configuration

    - Collibra: allowed for factory default reset when creating custom setup

    - Delta Lake/Databricks: added data type timestamp_nz for Runtime 13 and up

    - Delta Lake/Databricks: changed container terminology from database to schema, as per Databricks recommendation

     

    New features in v7.1.1 [19-Jan-2024]

    - Command-Line Interface: allowed * wildcard in --files argument of commands revEng, revEngJSON and revEngYAML

    - Application launch: display warning if application erroneously installed in AppData folder

    - Forward-engineering: added logging of system and application information 

    - Custom properties: harmonized sample xLevelconfig;json file with array for all targets to show support custom tabs

    - Workgroup edition: added deselection by default for deletions in the Git conflict resolution screen

    - Workgroup edition: physical Git conflict markers are associated to logical differences in conflict resolution screen

    - CockroachDB: added support for reverse-engineering of UDTs

    - CockroachDB: added ability to model table partitions, including forward- and reverse-engineering

    - CockroachDB: added ability to model table options, including forward- and reverse-engineering

    - CockroachDB: added properties for using, partitioning, hash, and visibility clauses in indexes, plus ability to parse btree and and hash-sharded indexes

     

    New features in v7.1.0 [12-Jan-2024]

    - Tech refresh of Electron (v27.2.1), NodeJS (v18.17.1), Chromium (v118.0.5993.159), V8 (v11.8) and -related modules

    - Polyglot: implemented 12x performance enhancement on refreshing references in derived models

    - ERD: adjusted box alignment function to keep zoom level

    - Properties Pane: added the automatic marking of Required/Not Null for PKs during reverse-engineering of JSON or derive from Polyglot

    - Documentation: added missing custom properties in native targets

    - Command Line Interface: fixed effect of --maxErdEntityBoxes argument of revEng commands

    - Workgroup : added default deselection of checkbox for deleted attributes in case of conflict resolution

    - CockroachDB: adjusted numeric data types to reflect CRDB's different approach than PostgreSQL

    - CockroachDB: fixed reverse-engineering of table comments

    - CockroachDB: removed tablespace clause from forward- and reverse-engineering

    - Delta Lake/Databricks: suppressed extraneous table options during reverse-engineering of DDL

    - Delta Lake/Databricks: added null safety check to filter check constraints

    - SQL Server/Synapse: increased logging to catch server timeouts during reverse-engineering

    - SQL Server/Synapse: removed unnecessary index query in reverse-engineering

     

    New features in v7.0.7 [05-Jan-2024]

    - Forward-engineering: added possibility to select individual entities of an ERDV

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

    - Delta Lake/Databricks: suppressed extraneous space in encoding of special ASCII characters in object technical names

    - MariaDB: added possibility to define cross-schema views

    - MySQL: added possibility to define cross-schema views

    - Oracle: relaxed technical name validation to allow all ASCII characters, as DDL generation uses quotes

    - Oracle: added possibility to define cross-schema views

    - PostgreSQL: added possibility to define cross-schema views

    - Teradata: added possibility to define cross-schema views

    - YugabyteDB: added possibility to define cross-schema views

     

    New features in v7.0.6 [29-Dec-2023]

    - Compare and Merge: enhanced detection of duplications and deletions in merge conflicts for models derived from polyglot

    - Excel: fixed inconsistent behavior in persistence of selected column options

    - Avro: added support for cross-namespace schema references

    - Cassandra: added support for the Cassandra 5.0 vector<float,dimension> data type

    - Cassandra: added possibility to create custom index with similarity_function option for vector search

     

    New features in v7.0.5 [22-Dec-2023]

    - ERD: implemented 10x performance improvement when display name is technical

    - Polyglot: implemented update of entity name changes in impact analysis screen

    - ERDV: fixed adding entities to ERDV via contextual menu

    - Excel: added exclusion of entity and view columns in export 

    - Forward-engineering: restructured selection tree in entity picker dialog

    - Reverse-Engineering: added reset of entity selection after cancel and immediate restart of the process

    - Avro: added use of record technical name in Schema Registry API forward-engineering of entity references in choices

    - Snowflake: further enhanced parsing of view SELECT statements and forward-engineering of view select statements

     

    New features in v7.0.4 [15-Dec-2023]

    - ERD: added possibility to add FK relationships from parent to child with creation of attribute in child entity.  Behavior can be toggled with child-to-parent direction in Tools > Options > General.  Opposite behavior possible with Ctrl+mouse drag-and-drop

    - Context bar: added Home icon for 1-click access to Welcome page

    - External definitions and parent polyglot model: added Properties Pane button to open reference in new instance

    - Forward-engineering: added possibility to create files according to ERDV membership

    - Workgroup: added tolerance for undocumented 8-symbol conflict markers

    - Avro: added escaping of the schema in forward-engineering with the Schema Registry format

    - Avro: used namespace.name for generation of schema references in forward-engineering with the Schema Registry format

    - Couchbase: upgrade to latest v4.2.4 of couchnode SDK

    - Couchbase: added handling of bucket names with spaces and special characters

    - Couchbase: added handling of delays in creation of new bucket by target instance

    - Databricks: added possibility to generate FaskerJS-based bulk synthetic INSERT records for testing

    - MongoDB: added consent dialog about risks of executing JavaScript when reverse-engineering Mongoose schema files

    - RDBMS and OLAP targets: removed extraneous View On property as DDL is assembled based on the table of the selected columns

    - Snowflake: further enhanced parsing of view SELECT statements to include options in WHERE clauses

     

    New features in v7.0.3 [08-Dec-2023]

    - External definitions: enabled selection of choices and subschemas in external references

    - ERD: fixed bug preventing duplicate action on entities

    - FK relationship: allowed update of relationship name from the child attribute's properties pane

    - Avro: added support for forward- and reverse-engineering of schemas made of oneOf union of schema references

    - Delta Lake/Databricks: removed extraneous View On property as DDL is assembled based on the table of the selected columns

    - DocumentDB: added handling of special characters in username/password

    - MongoDB: added handling of invalid BSON date data type

    - PostgreSQL/YugabyteDB: added estimated rows to udf if the function returns a set

    - PostgreSQL/YugabyteDB: allowed definition of number of estimated rows for udfs that returns table

    - PostgreSQL/YugabyteDB: added comments on functions to DDL generation

    - PostgreSQL/YugabyteDB: allowed creation of indexes without a method

    - Snowflake: added support for view SELECT statements with nested statements and Snowflake-specific syntax like OVER clause and multiple clauses

     

    New features in v7.0.2 [01-Dec-2023]

    - Model obfuscation: added effect to attributes added to a target model derived from polyglot

    - Bulk test data generation: upgraded FakerJS library to v8.3.1

    - Forward-engineering to file system: removed format from the folder name only for unstructured path

    - Avro: removed extraneous POST command in forward-engineering for Schema Registry

    - Delta Lake/Databricks: replaced blanks and dots with underscores in FK relationship constraint names to avoid Unity Catalog restriction not handling backticks

    - Hive: removed extraneous mode=int for in JSON Schema Full compliance when type=integer

    - OpenAPI: removed restriction to replace schema with component reference when derived from polyglot

    - PostgreSQL: removed restrictions on composite PKs when adding update columns to triggers

    - Redshift: removed extraneous mode=int for in JSON Schema Full compliance when type=integer

    - Snowflake: added support for view SELECT statements referencing parsed JSON

    - YugabyteDB: removed restrictions on composite PKs when adding update columns to triggers

     

    New features in v7.0.1 [24-Nov-2023]

    - License status screen: added copying of license key to clipboard prior to release

    - Views: enabled changing the database/schema container while keeping reference to the view on table property

    - Excel: added export and import of lineage sources

    - Polyglot: added possibility to select individual branch of subtype relationship to be deleted

    - Forward-engineering to file system: added format to the folder name

    - Avro: added option to include namespace as part of file name during forward-engineering to file

    - Cosmos DB with Core API: updated axios library to latest to take into account latest vulnerabilities

    - Delta Lake/Databricks: added support for table level constraints

    - Delta Lake/Databricks: adjusted conditions for which USE CATALOG statement is generated in DDL forward-engineering

    - PostgreSQL: added support for NULLS NOT DISTINCT in unique indexes and unique key constraints

    - PostgreSQL: added support for DEFERABLE unique constraints

    - PostgreSQL: added support for stored generated columns

     

    New features in v7.0.0 [17-Nov-2023]

    - Browser: deployment of Community Edition with common code base with Desktop, soft launched at https://studio.hackolade.com, basis for many upcoming enhancements

    - Desktop: Community Edition no longer requires a license key

    - Desktop: redesigned License status screen, also available from Context bar

    - License status screen: added one-step validation of another key, replacing 2-step release of old key plus validation of new key

    - Application packaging: added OS-specific prebuild of native modules

    - Command-Line Interface: added different file name patterns to compMod command [commit:][path]<file> with OS-based escaping for names with spaces

    - Command-Line Interface: added logging and friendly error messages

    - Avro: added possibility to use --defstrategy CLI argument to specify whether an entity should be resolved (default) or referenced

    - Cosmos DB with Core API: added fine-tuning of database and container creation via Azure CLI for partition-key-path, serverless, and TTL parameters

    - Delta Lake/Databricks: added support for data type changes in ALTER script of delta models

    - Delta Lake/Databricks: added support for SET LOCATION changes in ALTER script of delta models

    - Delta Lake/Databricks: added support for SET/UNSET TBLPROPERTIES changes in ALTER script of delta models

    - Oracle: added import of out-of-line column comments in DDL files

    - Snowflake: added schema name escaping plus function arguments, comments generation, and references in CONSTRAINT statements