Takes about 20 seconds to convert a 250kb XML file into 5 different sets of DB insert statements. <BR><BR>I'm running on Linux using Xerces and Xalan and converting to an Oracle 9.0.1 DB. ••• ...

Learn the main challenges and solutions for converting XML data to relational databases, and the best tools and techniques to use.

Souza Cruz ETL process to convert XML to different visions in Oracle. The program will be reading a predefined directory for new files with the xml extension, and ingest them to the Oracle Database.

This class makes it very easy, almost trivial, to convert SQL query results into XML, but a major disadvantage of OracleXMLQuery is that it is a proprietary solution.