Discussions
Categories
- 17.9K All Categories
- 3.4K Industry Applications
- 3.3K Intelligent Advisor
- 63 Insurance
- 535.7K On-Premises Infrastructure
- 138.1K Analytics Software
- 38.6K Application Development Software
- 5.6K Cloud Platform
- 109.3K Database Software
- 17.5K Enterprise Manager
- 8.8K Hardware
- 71K Infrastructure Software
- 105.2K Integration
- 41.5K Security Software
Load XML from DB table
Hi Everyone,
I have an urgent requirement to load XML from Oracle table ... pls let me know how to achieve this .
I know the reversal of the same but unable to proceed further with this req
(ODI : 11.1.1.5, OS : Solaris, DB : Oracle 11g)
Regards,
M
Best Answer
-
Its resolved, used sqlunloader.
I have seen those videos Bhabani, thanks for your help
Answers
-
Bhabani Ranjan Mahapatra Solution Expert, BI Cloud Solution Architect, Member Posts: 1,890 Gold Trophylet me know if you have any doubts.
Bhabani
-
You mean to say, here source is oracle db & target is XML file?
If yes, have you tried with "IKM XML Control Append" ?
See if this helps you : http://www.scribd.com/doc/88229941/ODI-XML-Integration
Regards,
Santy
-
Hi Bhabani &Santy,
Thanks for your replies, but my scenario is I have to load XML from Oracle DB table.
Source being Table and target is XML
Regards,
M
-
What are the problems you are facing to load XML. if it is simple XML file you can do it. I am afraid because you are using ODI 11.1.1.5 (has some issues)
11.1.1.6 and 11.1.1.7 are best for XML for my knowledge.
let me know
Thanks
-
Hi Himanshu,
I reversed the XML and provided and Schema name as well , it has got 15 datastores as there are 15 elements in the XML.
im not sure how to proceed further. (do I have to load each of the datastore individually and then use them in a Package)
I even tried using odisqlunload , gave the necessary details but got error message stating : does not accept URL
Regards,
M
-
Bhabani Ranjan Mahapatra Solution Expert, BI Cloud Solution Architect, Member Posts: 1,890 Gold Trophy
Sorry, I should have read your question properly. How many hierarchy you have in the xml file ?
refer this vedio tutorial
https://s3.amazonaws.com/Ora/XML_5_db_to_Complex_XML.swf
https://s3.amazonaws.com/Ora/XML_4_db_to_XML_Simple.swf
Bhabani
-
Its resolved, used sqlunloader.
I have seen those videos Bhabani, thanks for your help