3 Replies Latest reply: Jan 18, 2013 4:55 AM by 960855 RSS

    Read XML from a hardware sensor file into ODI

    user6439991
      Read XML from a hardware sensor file into ODI

      Hi,
      I am trying to extract xml data from a flowmeter that generates XML data.
      The xml file is found in http://ip_address/history.xml

      I’ve defined my Topology as such

      JDBC Driver: com.sunopsis.jdbc.driver.xml.SnpsXmlDriver
      JDBC URL: jdbc:snps:xml?f=http://192.168.0.202/history.xml&ro=true

      Please note to access the file I have to supply a username and password so I did in the definition But when testing my setup I get an error:

      ava.sql.SQLException: The DTD file "http://192.168.0.202/history.dtd" doesn't exist: Server redirected too many times (20)

      Please note I cannot write dtd to the device as it is a read only device.
      Has anyone came across such an issue, how can I achieve this.

      Thanks
      Hicham