Documentation

gitHub

JSON document

If you open a JSON document from the file system, Hackolade will detect its nature and will execute the reverse-engineering of that document.  You will need to choose a database target for your model.

 

If you wish to include the schema for a JSON document in an existing model, the process is slightly different.  With your model already opened, choose Tools > Reverse-Engineer > JSON document.  

Tools - Reverse-Engineer - JSON document

 

 

The process includes detection of ISO 8601 date/time/timestamp/duration in strings when target supports such data types.

Hackolade also supports Newline Delimited JSON as described in https://ndjson.org/

 

The structure of a JSON document can be imported either as an entity in the Entity Relationship Diagram, or alternatively as a model definition so it could be re-used in the model:

JSON Doc revers-engineering dailog

 

If you wish to force the destination of the reverse-engineering operation, you may specify the container in which the entities should be inserted.

 

 

For RDBMS targets, an additional option appears, that allows automatic normalization of complex data types:

 

JSON reveerse-engineering dialog - normalization