Hackolade

What is Hackolade?

Smooth integration of NoSQL databases

• Graphic view
• Nested JSON objects
• Implicit relationships
• Direct and reverse engineering
• Data model documentation
• Team collaboration
• Data management
• Windows, Mac, Linux

Graphical visualization of complex data structures

Harness the power of visual data modeling

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 immediately, without the need to read the entire user manual.

Sufficient industry standards

Entity relationship theory and the JSON schema are great industry standards. Hackolade uses just enough of them to fulfill its purpose. But not many of them either, so they don't become a constraint to the practical construction of NoSQL document templates.

Visual ER diagrams for JSON documents

The design of the scheme in a world without a scheme seems like a contradiction. Hackolade applies some entity relationship theory to non-relational databases to represent denormalized data in a friendly manner.

Graphic collection tree preview editing

Hackolade is specifically designed to address the powerful nature of nested objects, denormalization, and polymorphic semi-structured schemes. It uses a JSON schema notation, easily viewed and maintained in a hierarchical tree view.

Harnessing the power of JSON and NoSQL

Modeling nested objects: subdocuments and arrays

Field properties

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

Collectible hierarchical tree

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

JSON Schema Editor

You can use Hackolade to model simple JSON documents, with its intuitive graphic editor hiding the complexity of the JSON scheme without loss of power. It simplifies visualization and understanding of deeply nested structures and makes editing and maintenance easier. Hackolade dynamically generates a sample JSON document to illustrate the structure being constructed and validates the JSON schema and sample document.

Even non-relational databases have relationships

Documentation of implicit relationships and denormalization

Denormalized data requires full updates

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

Direct and reverse engineering

Accelerate your modeling and development cycle

Advanced engineering

Create sample documents as you develop your model to help you visualize your project with representative data. Easily generate MongoDB 3.2+ Validator scripts and Mongoose schemes to integrate with your code. For DynamoDB, there is dynamic generation of CreateTable and ConditionExpression scripts.

Reverse engineering

Capture your current data architecture, with many options for reading the metadata of your applications. This can be done by sending simple JSON documents or your JSON schema, or even a SQL data definition language file or an XSD from erwin, ER/Studio or PowerDesigner. When reverse engineering a NoSQL instance, the system performs a probabilistic inference of a representative sample of each collection or table.

Data model documentation

HTML or PDF formats

After enriching your model with descriptions, constraints, and relationships, Hackolade automatically generates a rich report including diagrams, tables, and all metadata.

Engage in dialogue

Collaborative application architecture design

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

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

Data management

Ensure data integrity and build credibility

Add the right level of control

Combine document model flexibility with true data compliance and validation capabilities. Teams can now benefit from the ease of development that the document model offers by maintaining tight data governance controls that are critical to applications in regulated industries, through the MongoDB v3.2 validator or JSON v3.6 schema support.

Data dictionary

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

Command Line Interface

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

Comparison and merging of models

Identify additions, modifications, and deletions between 2 versions of a model or between a baseline model and what can be found in the production database instance. Manual and automatic blending can be performed.

User-defined custom properties

To help fit Hackolade into your data management infrastructure, you can set your own properties for any type of object: model, container, database, bucket, collection, table, or attribute.

Naming conventions

You can keep a 'business name' and a 'technical name' for objects (containers, entities, and attributes).

To make it easier to maintain these 2 names, you can keep them synchronized and transformed based on a set of User Oriented Parameters, and optionally based on a conversion file kept out of the application.

Name conversion can occur in both directions: Business-to-Technical or Technical-to-Business. In addition, when reverse engineering, it is assumed that the database instance contains technical names, to be transformed into trade names.

Bulk editing in Excel with export/import

For any of the supported targets, you can export all or part of a model, so that properties can be easily edited in a tabular format, to be reimported back into the application. You can select and choose exactly which objects and properties are exported to each target.

Model-based API generation

Generate an OpenAPI (or Swagger) model and documentation from any Hackolade target model. This feature will help make your APIs more consistent than those produced manually, while easily exposing resources to underlying data sources. API maintenance will be greatly facilitated and the total cost of ownership reduced. Make an entity relationship diagram (ERD) to automatically generate the API for CRUD operations of the entities in that data model.

System requirements:

CPU: 1.8 GHz dual core processor

RAM: 2 GB

HDD / SSD: 50 GB of free space on the main drive

Operating system: Microsoft Windows 8 32-bit, Microsoft Windows 7 32-bit and Microsoft Windows Vista 32-bit

Resolution: 1024×768