How can I load an XML file into Netezza ?

Toad Data Point & Toad Intelligence Central
1

I would like to load an external XML data flat file into Netezza.

Does anyone have any suggestions on how to do this? I have tried using the TOAD tool, however, that only loaded the first hierarchy.

Is there a way to do this ?

Thank you.

2

Toad will only read XML files that were exported by Toad Data P:oint. We only use one xml format and do not offer the ability to assign a schema file.

3

The Netezza SQL Toolkit has a number of XML functions you may find useful.

4

How big is the file? If it is a size that Excel can handle, Excel can convert an XML file to a flat file. It can use an xml schema and even without one it gives you the option to let Excel figure it out based on the data (which it does a good job of). Toad only imports/exports XML tables.