Feature comparison of Hackolade versions

Compare editions

Choose the edition that best fits your needs

Perpetual license or subscription: which one should I choose? This article may help.

See the feature comparison matrix below for a full listing of the differences between the Community, Personal, and Professional editions.

Community edition

The Community edition of Hackolade is completely FREE. It is an entry-level NoSQL document data modeling software with a subset of the Hackolade Professional edition. It is a great way for students and those new to modeling to get started with an industry-leading data modeling tool.

The Community edition offers many of the core features of data modeling with a limit of 50 model objects. It includes Entity Relationship diagrams and the hierarchical schema view of JSON collections, forward-engineering, documentation, and more. It does not include the reverse-engineering function or HTML documentation.

Personal edition

The Personal edition of Hackolade is ideal for startups and individual developers. It includes all the features of the Community edition plus very flexible HTML documentation to share models with team members, and the capability to model an unlimited number of objects. You may also view model differences and suggest the denormalization of existing relational models.

The Personal edition does NOT include the advanced features of the Professional edition, such as Forward- and Reverse-Engineering functions for each database target, and some advanced features, cfr table below.

Professional edition

The Professional edition of Hackolade includes all the features of the Community and Personal editions, and much more! With no limit on the size of models, this premium version produces documentation in different flexible formats.

Key additional features include forward- and reverse-engineering functions tightly integrated with all our different target technologies, plus our powerful Command Line Interface, and other advanced features. Maintain your schema documentation in sync with your production instance, thanks to the ability to compare different versions of your model.

Start your free trial immediately, and discover the power and flexibility of Hackolade. For 14 days. No credit card required.

Targets & terminology

Avro Schema

Cassandra & DataStax

Cosmos DB w/ SQL API, MongoDB API, and Gremlin API

Couchbase

Amazon DynamoDB

Elasticsearch, up to v6.x

Amazon EventBridge Schema Registry

Google BigQuery

Google RealTime Firebase

Google Cloud Firestore

AWS Glue Data Catalog

HBase

Hive

JSON Schema draft-04, draft-06, draft-07, 2019-09, 2020-12

MariaDB

MarkLogic

MongoDB

Neo4j

Parquet

PostgreSQL and EnterpriseDB

Protobuf

Amazon Redshift

ScyllaDB

Snowflake

Microsoft SQL Server

Azure Synapse

Swagger and OpenAPI

TinkerPop

YAML Schema

Graphic visualization

Unlimited number of objects

Visual ER Diagram navigation

Custom ERD views of main diagram

Graphic hierarchical schema view of entities

Document implicit relationships

Support for nested documents and arrays

Specific properties and constraints for each data type

Data dictionary of reusable objects

User-defined custom properties for all objects

Naming conventions

Suggest denormalization of a relational schema via embedding and referencing

Lineage capture

Bulk editing in Excel with import/export

Model-driven API generation

Documentation generation

PDF

HTML

Markdown

Forward-engineering

Individual JSON documents

JSON Schema

Model-Driven API Generation

Avro schema

Couchbase Ottoman ODM schema

Cassandra & DataStax CQL scripts

DynamoDB CreateTable and ConditionExpression scripts

Elasticsearch mappings

EventBridge Schema Registry

Google BigQuery DDL

Glue Data Catalog HQL and AWSCLI

HBase

Hive HQL scripts

MariaDB DDL

MarkLogic

MongoDB Validator

Mongoose ODM schema

Neo4j Cypher

Parquet schema

PostgreSQL DDL

Protobuf schema

Redshift DDL

ScyllaDB CQL scripts

Snowflake DDL

SQL Server DDL and Azure SQL DDL

Synapse Analytics DDL

Swagger and OpenAPI

TinkerPop Gremlin script

YAML Schema

Reverse-Engineering

Individual JSON documents

NDJSON files

JSON Schema files, local or from Cloud storage, or schema registry

Data Definition Language files (Oracle, MySQL, SQL Server, DB2, PostgreSQL, Informix, Snowflake)

XSDs (from erwin, ER/Studio, PowerDesigner, etc...)

Avro files and schema definitions, local or from Cloud storage, or schema registry

Cassandra & DataStax, on-prem and Astra Cloud

Couchbase instances

Cosmos DB w/ SQL API, MongoDB API, and Gremlin API

DynamoDB instances local and AWS cloud

AWS authentication: Access/Secret keys and credentials file

Elasticsearch

EventBridge Schema Registry

Google BigQuery

Glue Data Catalog

Google RealTime Firebase (TBA)

Google Cloud Firestore (TBA)

HBase

Hive Plain SASL, noSASL, LDAP, Kerberos, HDInsight

MariaDB, including schema inference of JSON in longtext

MarkLogic

MongoDB instances

MongoDB Authentication: username/pwd, LDAP, Kerberos, TLS/SSL X.509, SSH

Mongoose schema

Neo4j

Parquet files, local or from Cloud storage, or schema registry

PostgreSQL and EnterpriseDB

Protobuf files, local or from Cloud storage, or schema registry

Redshift, including schema inference of JSON in SUPER data type

ScyllaDB and Scylla Cloud DBaaS

Snowflake, including schema inference of JSON in VARIANT

SQL Server and Azure SQL DB, including schema inference of JSON in (N)VARCHAR(MAX)

Synapse Analytics

Swagger and OpenAPI

TinkerPop/TinkerGraph

YAML Schema files, local or from Cloud storage, or schema registry

Command Line Interface

Generation of HTML, Markdown, or PDF documentation

Reverse-Engineering of large dataset samples, JSON documents/schema, DDLs

Forward-Engineering of scripts, JSON Schema, sample JSOn document, model API

Model comparisons to identify new fields and structures, and merge changes

Obfuscate model

Collaboration & Versioning

Show model differences

Advanced side-by-side compare and merge

Share schemas and versioning via GIT repository

Miscellaneous

Multi-platform (Windows, Mac, Linux)

Does not require admin rights to install and operate

Auto-update with new releases

Auto-save and recovery of unsaved model in case of PC crash