This discussion is archived
3 Replies Latest reply: Jan 18, 2013 2:55 AM by 960855 RSS

Read XML from a hardware sensor file into ODI

863922 Newbie
Currently Being Moderated
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
  • 1. Re: Read XML from a hardware sensor file into ODI
    David Allan Guru
    Currently Being Moderated
    Hi Hicham

    Specify the DTD location in the URL using the d= property;
    http://docs.oracle.com/cd/E23943_01/integrate.1111/e12644/xml_file.htm#CACJJGGI

    Cheers
    David
  • 2. Re: Read XML from a hardware sensor file into ODI
    863922 Newbie
    Currently Being Moderated
    Hi David,

    Thanks for your reply.
    I've tried this jdbc url

    jdbc:snps:xml?f=http://192.168.0.202/history.xml&d=c:\temp\history.dtd

    but when I test the connection i get the following error
    java.sql.SQLException: While generating the DTD from the XML file, a java.io.IOException exception occurred saying: Server returned HTTP response code: 401 for URL: http://192.168.0.202/history.xml

    If I browse http://192.168.0.202/history.xml and i supply the username and password I get an xml page.

    I've supplied the username and password in the definition tab of the Data Server windows but still getting the above error.

    THanks
    Hicham
  • 3. Re: Read XML from a hardware sensor file into ODI
    960855 Newbie
    Currently Being Moderated
    not required user name pwd.you jst give xml file path,schema name in data server create physical and logical schemas after that create model reverse engineer to get metadata.
    hope this will help you

    nari

Legend

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