XMLizer carries out the transformation from XML documents to existing relational databases and vice-versa. The XMLizer permits the extraction of data, their transformation into XML format and the insertion (or loading) of the XML data into relational database tables while respecting business rules.
All data translation is simplified into a single document. Thus, the unique properties of this tool are:
> Drastically reduced development time. The programmer simply defines the mappings and all generation of identifiers, parsing of documents and generation of complex SQL statements are done automatically.
> Increased ease of maintainence. Translations between XML and SQL are no longer cast in the "stone" of programs. The translations are clearly laid out in a single location providing a clear description of data movement in both directions.
> Increased performance. XMLizer is highly optimized to perform these translations. Instead of "one-off" optimizations used in an ad-hoc translation, all optimization techniques are gathered in one place and can be applied to all uses of the product.
Exchanging data between EAI, EDI or B to B platforms and an existing relational database is difficult due to the differences in the structure and type of the data involved. The XMLizer brings a solution to this problem by providing a tool to easily:
1. Extract data stored in relational database in XML format,
2. Map XML documents and insert (or load) into an existing relational database.
This functionality is provided by the component with a maximum of flexibility and openness to incremental improvements.