Graphic visualization of complex data structures

Leverage the power of visual modeling
Data Modeling NoSQL

Intuitive and easy-to-use interface

Hackolade's user interface has been carefully designed to be clear and effective, minimizing the learning curve, and allowing you to start modeling right away, without the need to read the entire user manual.

Just enough industry standards

Entity Relationship theory and JSON Schema are great industry standards. Hackolade uses just enough of them to serve its purpose. But not too much of them either, so they don't become a constraint to the practical construction of NoSQL document models.

NoSQL visual data modeling

Visual ER diagrams for JSON documents

Schema modeling in a schemaless world seems like a contradiction. Hackolade applies some Entity Relationship theory to non-relational databases to represent denormalized data in a user-friendly way.

Graphic collection tree view editing

Hackolade is specifically designed to handle the powerful nature of nested objects, denormalization, and polymorphic semi-structured schemas. It uses a JSON Schema notation, easily visualized and maintained in a hierarchical tree view.

Leveraging the power of JSON and NoSQL

Modeling nested objects: sub-documents and arrays
Visual Data Modeling Tool

Field properties

Each data type has its specific properties and constraints, allowing documentation and validation of the business rules needed for proper data integrity. Following the capabilities of JSON, Hackolade supports polymorphic semi-structured schemas with mutiple types possible for a given field/attribute.

Collapsible hierarchical tree

To make each collection's structure more readable, the ER diagram contains a pretty view of the collection schema with an indication of each field's data type. You can easily navigate the database structure only using a mouse.





JSON Schema editor

JSON Schema editor

You may use Hackolade to model plain JSON documents, with its intuitive graphical editor hiding the complexity of JSON Schema with no loss of power. It simplifies the visualization and understanding of deeply nested structures, and facilitates editing and maintenance. Hackolade dynamically generates a sample JSON document to illustrate the structure being built, and validates both the JSON Schema and the sample document.

Even non-relational DBs have relationships

Documentation of implicit relationships and denormalization
Hackolade visual data modeling tool

Denormalized data requires thorough updates

To make each collection's structure more readable, the ER diagram contains a pretty view of the collection schema with an indication of each field's data type. You can easily navigate the database structure only using a mouse.

Forward- and Reverse-Engineering

Speed up your modeling and development cycle
download visual data modeling

Forward-engineering

Create sample documents as you develop your model, to help you visualize your design with representative data. Easily generate MongoDB 3.2+ Validator scripts and Mongoose schemas to be integrated in your code. For DynamoDB, there's dynamic generation of CreateTable and ConditionExpression scripts.

Hackolade

Reverse-engineering

Capture your current data architecture, with many options for reading the metadata of your applications. This can be done by submitting simple JSON documents or their JSON Schema, or even a SQL Data Definition Language file. When reverse-engineering a NoSQL instance, the system performs a probabilistic inference of a representative sampling of each collection or table.

Data model documentation

Data model documentation
Download visual data modeling tool

HTML or PDF formats

Once you have enriched your model with descriptions, constraints, and relationships, Hackolade automatically generates a rich report including diagrams, tables, and all the metadata.

Engage the dialog

Collaborative application architecture design
Hackolade visual data modeling tool

A powerful tool for analysts, data architects, designers, developers, and DBAs

Evaluate alternatives, recognize potential hurdles early to reduce rework later. Facilitate troubleshooting and evolution to respond to growth and customer needs.

Data governance

Insure data integrity and build credibility
MongoDB Visual data modeling tool

Add just the right amount of control

Leverage the new Validator just introduced with MongoDB 3.2. And compensate for the usual lack of native referential integrity of NoSQL document databases.



Data dictionary

Define once object definitions that can be re-used in multiple places. A library of definitions standardizes content and insures consistency. It also simplifies the work of data modelers so maintenance can be performed in one place and be automatically propagated to all places where the definition is referenced.

Hackolade




Command Line Interface

Command Line Interface

True support for an agile development approach leveraging the flexibility of NoSQL dynamic schemas via automated tasks to discover new fields and structures from a much larger dataset as a basis for document sampling.



User-defined custom properties

To help fit Hackolade in your data management infrastructure, you may define your own properties for any kind of object: model, container, database, bucket, collection, table, or attribute.

Custom properties

Multi-platform desktop application

Native support for your desktop OS
OS compatible visual data modeling tool

Matching your environment

Hackolade was developed to be conveniently used on any of your desktop computers: Windows 7 through 10, Mac OS X 10.9 or higher, and several Linux flavors based on kernel v3.20 or above.