All our ETL software is capable of reading and writing JSON files with or without root node.

About JSON:

JSON (JavaScript Object Notation) is a lightweight data-interchange format. It is easy for humans to read and write. It is easy for machines to parse and generate. It is based on a subset of the JavaScript Programming Language, Standard ECMA-262 3rd Edition - December 1999.

http://www.json.org

JSON Examples:

Without the root node:
[
{ “id” : 1,“Name”: “John”, “age”: 25 },
{ “id” : 2,“Name”: “Maria”, “age”: 43 }
]

With the root node:
{
“root”:
{ “id” : 1,“Name”: “John”, “age”: 25 },
{ “id” : 2,“Name”: “Maria”, “age”: 43 }
]
}

 

JSON

 

JSON

 

Product NameReading JSONWriting JSONTransforming JSON 
Advanced ETL Processor Enterprise 32 Bit Download Now
Advanced ETL Processor Enterprise 64 Bit Download Now
Advanced ETL Processor Professional 32 Bit Download Now
Advanced ETL Processor Professional 64 Bit Download Now
Advanced ETL Processor Standard 32 Bit Download Now
Advanced ETL Processor Standard 64 Bit Download Now
Visual Importer ETL Enterprise 32 Bit Download Now
Visual Importer ETL Enterprise 64 Bit Download Now
Visual Importer ETL Professional 32 Bit Download Now
Visual Importer ETL Professional 64 Bit Download Now
Visual Importer ETL Standard 32 Bit Download Now
Visual Importer ETL Standard 64 Bit Download Now
Visit JSON Wiki Page