Make your Information System compatible with "No SQL" formats
JSON has become an essential exchange format. Most web APIs use this format to exchange data with third party applications..
Because of its principle of "universal mapping" Stambia allows any type of data structure to be easily manipulated.
Thus, the management of JSON files in Stambia is surprisingly easy and is very appreciated by users. Stambia can reverse this type of file, directly from the file or through a web service definition.
Writing JSON Data
Reading JSON data
JSON Files replication
Coupled to the Stambia replication component, the connector allows you to replicate a hierarchical JSON model into a standard relational database.
This component allows you to browse a directory and massively integrate JSON files into a relational database. In this case, there is no mapping, thus no development. The replicator is able to create a relational structure from the hierarchical structure of the file and to fill the database with the files that have been found in the folder.
Thus the reading or writing of a JSON file is automated and requires no complex development.
JSON and web services
JSON can also be the input or the output part of a web service. The way to manage the JSON format will be the same as for a mapping using an XML exchange format.
Stambia can directly reverse the web service description including the JSON definition.
If the web service definition doesn't provide the JSON input or output definition, it's possible to associate a JSON file definition to the web service definition in order to complete the metadata.
In that case, the mappings are very simple to implement.