Load xml files

[NetSpace]

Hi!

Can DecisionStream be used to load^* xml files into relational DB(Oracle)?
^*Load means parse xml and insert data(not xml) into tables .

Thank you

[MFGF]

Hi,

A colleague of mine had the following to say on this topic:

"DecisionStream has no direct API for XML data files. You could source XML data using the Merant ODBC solution for windows. Alternatively, process the data using something like Perl which has some awesome stuff available via CPAN to play with Perl (i.e. TWIG which lets you address XML docs using XPATH but actually processes the data using the speed of the SAX API).

Hence, you could process the document in Perl and denormalize the data stream into a text file and then pick it up in DS. You could also do the same via pipes using SQLtxt to a pipe rather than a text file.

Of course, you could also leverage the RDBMS vendor's XML support to shred the the document into standard tables/columns.

Refer to http://www.xml.com/pub/q/perlxml for more details on the Perl route."

Hope that helps!

MF.