3 Replies Latest reply on Dec 3, 2012 5:42 AM by Bijal

    ODI  DB to XML


      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 :

      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
          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

            1 person found this helpful
            • 3. Re: ODI  DB to XML
              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!