This discussion is archived
5 Replies Latest reply: Feb 4, 2013 4:17 AM by nianzhang RSS

ODI loading XML to table

nianzhang Newbie
Currently Being Moderated
I am new to ODI( 10.1.3.5) I need to load XML files to multiple tables.
E.g this xml will go to customer, orderHeader, orderline tables. we don't have ODI 11. Is ODI 10.1.3.5 capable of doing this task? If yes any guidance out there so I can follow? Many thanks.

<order>
<customer>
<name>a</name>
</customer>
<orderHeader>
<ordernumber>1</ordernumber>
</orderHeader>
<orderline>
<no>1</no>
<amount>100</amount>
</orderline>
<orderline>
<no>2</no>
<amount>200</amount>
</orderline>
</order>
  • 1. Re: ODI loading XML to table
    960855 Newbie
    Currently Being Moderated
    yes.do you know the process to create dataserver and build the physical and logical schemas ?let me know first whether u know the process?

    Thanks
    Nari
  • 2. Re: ODI loading XML to table
    960855 Newbie
    Currently Being Moderated
    first you need to create data server build physical,logical schemas and create context to map them. go through the below link then you will come to know

    http://www.odigurus.com/2012/02/xml-to-rdbms-table-loading.html

    Thanks
    Nari
  • 3. Re: ODI loading XML to table
    actdi Pro
    Currently Being Moderated
    This would help you to get started with ODI 10g:

    https://s3.amazonaws.com/Ora/XML_1_define_xml_in_topology.swf
    https://s3.amazonaws.com/Ora/XML_2_The_rendered_data_structure.swf
    http://gerardnico.com/doc/odi/webhelp/en/usermanual/technos/xml/create_data_server_xml.htm
  • 4. Re: ODI loading XML to table
    nianzhang Newbie
    Currently Being Moderated
    Thanks for the replies. All very helpful. I have been able to load csv file to oracle table. Now I am trying loading xml files to oracle tables. I have set up data server and models, selected LKM and IKM, now it asked me for CKM, what CKM for this?
  • 5. Re: ODI loading XML to table
    nianzhang Newbie
    Currently Being Moderated
    OK, I set up the CKM to 'CKM SQL' but don't know where to use it in the interface. The tutorial I found all based on ODI 11 where it has staging area different from target and the staging area is 'In-Memory Engine: Sunopsis_Memory_Engine'. Don't know how to do it in ODI 10.

    But if I set FLOW_CONTROL and STATIC CONTROL to NO for the target data store (oracle table), then odi will not ask for the CKM, and the XML can be loaded. But I guess this skip the data checking? So I guess I will still need to set up the CKM to work.

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points