troubleshooting Question

Parse XML and load into Oracle 10g

Avatar of r3r
r3rFlag for United States of America asked on
Oracle DatabaseJavaXML
4 Comments1 Solution3680 ViewsLast Modified:

I need to import/convert the provided XML file into Oracle 10g.  I am looking for the most efficient means to accomplish this.  Note I had to change the extension to .txt for upload purposes.    For this particular question,  I'm not looking for a coded answer.  I would like someone to provide the best practice of achieving this goal, explaining clearly why I should go their suggested route.  Links would be helpful as well.  I have some people on my end that I need to convince ;)

Here are the suggestions that have been presented to me so far...

1.  transform the xml to csv and use oracle sqldr to import the csv into oracle
2.  use java to directly parse the xml, connect to oracle and populate the database.
3.  use perl to parse the xml, connect to oracle and populate the database
4.  use talend to create to java code for your integration purposes.

Some things to consider:

1.  When this goes in to production, this will be run as a daily job.  The entire process of reading the xml and populating the database  needs to be completely automated.
2.  The sample XML file is much smaller than the actual XML file.  The real XML file will be 5-10 MB

I am open to any suggestion whatsoever as long as it is the BEST and most efficient means.  Best answer gets 500 pts.  Also, after receiving the best answer I will start another question thread seeking more granular response on how to implement the best solution provided here.  That question will be for 500 pts, as well.

Thanks in advance for your assistance...


Join our community to see this answer!
Unlock 1 Answer and 4 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 4 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros