3 Replies Latest reply: Dec 2, 2012 11:42 PM by Bijal RSS

    ODI  DB to XML

    Bijal
      Hi,

      I have a xml file in Soap UI format with just the nodes. No data is present in it. I need to populate this file using a table in database. When i go to create a topology for XML, giving JDBC URL as :
      jdbc:snps:xml?f=D:\Oracle_ODI\Middleware\ODI_Home\oracledi\xml-reference\AddAccount-Person.xml&re=GEOGRAPHY_DIM&ro=false&case_sens=true

      But when i test this connection am a getting an error:

      "No Root found in DTD file" please guide me where am i going wrong
        • 1. Re: ODI  DB to XML
          Bijal
          Hi,
          i overcome the above error. But am not sure steps to follow to populate XML file using a DB table. i have found links for XML to DB but none for DB to XML. can u please help me?
          • 2. Re: ODI  DB to XML
            Sutirtha Roy
            check if this helps

            http://www.avioconsulting.com/blog/skhot/2011/09/23/oracle-odi-11g-elt-oracle-db-xml
            • 3. Re: ODI  DB to XML
              Bijal
              Hi,
              The link shared by u is really helpful. But it still leaves me with few doubts. While i create the XML Model, each node is created as a separate table. My XML has 11 sub root nodes. I do not want them all as separate files. I have just one DB table that is goin to populate this entire XML. Can i hav a single XML as my target instead of multiple. Is ther a way i can club it all?

              Thanks in advance!