Re: xml import

From: Michael Wimmer <newsgroup1_at_ecom.at>
Date: Wed, 30 Mar 2005 14:04:01 +0200
Message-ID: <424a95b1$0$10398$91cee783@newsreader02.highway.telekom.at>

HansF wrote:
> On Wed, 30 Mar 2005 10:19:58 +0200, Michael Wimmer wrote:
>
>

>>Hi
>>
>>we are in the process of considering to migrate from MySQL to Oracle.
>>
>>One of the requirements for the near future is to import data via XML.
>>
>>Is there a possibility import this data directly into oracle from the 
>>XML file or stream? The XML structure could be adjusted to Oracles needs 
>>if necessary.
>>

>
>
> Yes it is possible and very practical using either file or data streaming.
>
> You have not specified Oracle version, and there have been continuous
> improviements with Oracle's support of XML since 8i (8.1.x)

Most likely 9.2 but an upgrade to 10g would be possible if necessary.

I assume you mean the XML SQL Utility (XSU). One question, can this tool be configured to listen on a specific port and capture the streaming XML (assuming the mappings for the XML files to the relational Tables are provided) or do I have to do this programatically?

The XML documents will arrive on the server via HTTP.

Thanks in advance,

Michael

>
> Some sources for information:
>
> Oracle documentation (docs.oracle.com) has at least 3 manuals, including
> the XML API ref, XDK and Dev Duide;
>
> TechNet (otn.oracle.com) has a complete section, including samples, under
> the Technology Cneter. Highly recommend reading the Tutorial!
>
> Several serious books have been written about Oracle & XML, published by
> O'Reilly (oracle.oreilly.com) and Osborne (www.oraclepress.com)
Received on Wed Mar 30 2005 - 06:04:01 CST