5 Replies Latest reply on Jun 20, 2014 12:15 PM by Phanikanth

    How to reverse engineer complex XML files in ODI

    1374429

      Hi,

      Can you please tell me, how to reverse engineer complex XML files in ODI.

      My XML file has a Message Data tab as mentioned in below xml file, when ever I reverse engineer in ODI, entire Message Data coming into a single column. I want to extract Message Data into a different columns to load into tartget DataBase

       

      <?xml version="1.0" encoding="UTF-8"?>

      <RibMessages

        xmlns="http://www.oracle.com/retail/integration/rib/RibMessages"

        xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"

        xsi:schemaLocation="http://www.oracle.com/retail/integration/rib/RibMessages http://whjed-ribc1.nmc.com:9001/rib-func-artifact/integration/xsd/RibMessages.xsd" >

        <ribMessage>

          <family>XStore</family>

          <type>XStoreCre</type>

          <id>8109</id>

          <ribmessageID>XStore_pub_1|2013.04.26 12:24:35.756|2</ribmessageID>

          <routingInfo>

            <name>store</name>

            <value>8109</value>

          </routingInfo>

          <publishTime>2013-04-26 12:24:35.756 AST</publishTime>

        <messageData>&lt;XStoreDesc xmlns=&quot;http://www.oracle.com/retail/integration/base/bo/XStoreDesc/v1" xmlns:xsi=&quot;http://www.w3.org/2001/XMLSchema-instance"><store>8109</store><store_name>AlDoaae</store_name><store_type>C</store_type><store_name10>AlDoaae</store_name10><store_name3>HAR</store_name3><store_add1>MAKTAF</store_add1><store_add2>MAK</store_add2><store_city>MEC</store_city><state>MEC</state><country_id>SA</country_id><store_pcode>10001</store_pcode><store_class>D</store_class><store_mgr_name>Mohammed Abdultif&lt;/store_mgr_name&gt;&lt;store_open_date&gt;2011-12-06T00:00:00.000+03:00&lt;/store_open_date&gt;&lt;acquired_date&gt;2011-12-07T00:00:00.000+03:00&lt;/acquired_date&gt;&lt;remodel_date&gt;2011-12-05T00:00:00.000+03:00&lt;/remodel_date&gt;&lt;fax_number&gt;312844&lt;/fax_number&gt;&lt;phone_number&gt;12713&lt;/phone_number&gt;&lt;email&gt;storemanager_5007@nmc.com&lt;/email&gt;&lt;total_square_ft&gt;1172&lt;/total_square_ft&gt;&lt;selling_square_ft&gt;911&lt;/selling_square_ft&gt;&lt;linear_distance&gt;72&lt;/linear_distance&gt;&lt;stockholding_ind&gt;Y&lt;/stockholding_ind&gt;&lt;channel_id&gt;1000&lt;/channel_id&gt;&lt;district&gt;150&lt;/district&gt;&lt;start_order_days&gt;30&lt;/start_order_days&gt;&lt;currency_code&gt;SAR&lt;/currency_code&gt;&lt;lang&gt;1&lt;/lang&gt;&lt;iso_code&gt;EN&lt;/iso_code&gt;&lt;integrated_pos_ind&gt;Y&lt;/integrated_pos_ind&gt;&lt;copy_dlvry_ind&gt;Y&lt;/copy_dlvry_ind&gt;&lt;copy_activity_ind&gt;Y&lt;/copy_activity_ind&gt;&lt;vat_region&gt;1000&lt;/vat_region&gt;&lt;like_store&gt;1000&lt;/like_store&gt;&lt;copy_repl_ind&gt;Y&lt;/copy_repl_ind&gt;&lt;transfer_entity&gt;1000&lt;/transfer_entity&gt;&lt;tran_no_generated&gt;R&lt;/tran_no_generated&gt;&lt;timezone_name&gt;Asia/Riyadh&lt;/timezone_name&gt;&lt;org_unit_id&gt;1000&lt;/org_unit_id&gt;&lt;/XStoreDesc&gt;</messageData>

          <customData></customData>

          <customFlag>F</customFlag>

        </ribMessage>

      </RibMessages>

       

      Please tell me how to achive above thing.

       

      Thanks