2 Replies Latest reply: Dec 10, 2012 12:33 PM by 702379 RSS

    Table to XMl ODI

    801667
      I have created an ODI to transfer data from table to xml.
      The interface executes successfully and from the xml data store in the model, I can see that the data is loaded to xml data store.
      However, Iam not able to see any xml with all the data which is inserted.
      In IKM, i have given XML path(C:\abc.xml) , create xml file as true.

      The interface is creating the abc.xml, but it is always creating it with empty schema. The target data is not getting loaded.
      Any help on this is much appreciated.

      Thanks,
      Naveen Kumar T.

      Edited by: 798664 on Aug 28, 2012 5:36 PM
        • 1. Re: Table to XMl ODI
          872208
          I have the same problem. Does anyone have any idea?

          Natalia.
          • 2. Re: Table to XMl ODI
            702379
            I used the below steps to generate xml file:

            1) Place oracle proparties file in Drives folder. (get the properties file in ODI documentation)

            2) use the URL to create XML schema with xml tables in database

            jdbc:snps:xml?&d=/oracledi/demo/xml/test.xsd&lf=/oracledi/demo/xml/test.log&ll=31&re=rootelement&s=test&dp=oracle

            dp is name of the properties file

            3) create phy and logical schemas

            4) Load the Xml tables created in database

            5) use the follwing command in ODI procedure to create file.

            CREATE XMLFILE <file_name> [FROM SCHEMA <schema_name>]

            Hope this will help ...

            Thanks,
            RJ