Management of XML files for data integration projects

XML Files

Make your Information System comptabible with the XML format

Because of its principle of "universal mapping" Stambia allows any type of data structure to be easily manipulated.

Thus, the management of XML files in Stambia is surprisingly easy and is very appreciated by users.

Reverse engineering of XML files is done respecting the recognized standards, through an XSD definition or through a direct reverse of the file.

Writing XML data

Stambia can integrate the data into an XML file in one single mapping and this regardless of the complexity of the XML file.

In the example presented here the target of the mapping is an XML file, consisting of multiple hierarchies.

While still readable, one single mapping can feed an XML file containing very deep hierarchies, containing multiple occurrences of the same elements, or an XML file consisting of juxtaposed hierarchies.


Reading of XML data

The Stambia approach of the mapping provides also the optimum way to read complex files in order to load multiple targets, with a very high level of performance.

The "multi-target" approach of the mapping remains simple, while allowing to load multiple targets from a single file. The files will only be loaded one time, but the data will be sent at the same time into multiple targets.

This will provide a high level of performance to read, use and transform source XML files.


Replication of XML files

The integration of XML files (XML sources) into a target can also be automated using the replicator component. This component allows you to browse a directory and massively integrate XML 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.