This discussion is archived
2 Replies Latest reply: Dec 10, 2012 10:33 AM by 702379 RSS

Table to XMl ODI

801667 Newbie
Currently Being Moderated
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 Newbie
    Currently Being Moderated
    I have the same problem. Does anyone have any idea?

    Natalia.
  • 2. Re: Table to XMl ODI
    702379 Newbie
    Currently Being Moderated
    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

Legend

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