Polyglot Data Modeling for SQL and NoSQL databases, APIs, and storage formats
Hackolade Studio is an intuitive yet powerful application to perform the visually data modeling and schema design of many SQL and NoSQL databases, APIS, and storage formats.
Hackolade Studio combines the graphical representation of collections in an Entity Relationship Diagram, with the graphical representation of the JSON Schema definition of each collection in a hierarchical schema view. Together, these graphical representations provide the schema model for data-at-rest and data-in-motion, plus the documentation of that model. The application is specifically designed around the powerful nature of JSON nested sub-objects and denormalization.
The software facilitates the work of, and the dialog between analysts, architects, designers, developers, testers, DBAs, and operators of systems that are based on such technologies. It also can generate schema scripts and documentation in a variety of machine-readable formats (DDLs, JSON Schema, Avro, Parquet, Protobuf, ...) as well as database instances, or human-readable formats such as HTML, Markdown, and PDF reports.
Instead of having to find data structures tacitly described in the application code, the creation of a database model helps to evaluate design options beforehand, think through the implications of different alternatives, and recognize potential hurdles before committing sizable amounts of development effort. A database model helps plan ahead, in order to minimize later rework. In the end, the modeling process accelerates development, increases quality of the application, and reduces execution risks.
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
