Dear All,
I am trying to reverse engineer an XML file with namespaces into ODI 12c. I gave numerous tries with both V2 and V3 version but both failed with different kind of errors. I am sorry I could not post the errors as I played around with XSDs multiple times and each time I got a different error. Can someone help me reverse engineer the file successfully and R.Click View data should work after reverse engineering into the XML Model. It will be very helpful if someone could at least pass me the correct working XSD for this instance.
Here's the XML instance:
<?xml version="1.0" encoding="UTF-8"?>
<first:EMPLOYEES xmlns:first="www.google.com">
<sec:EMPLOYEES xmlns:sec="www.yahoo.com">
<EMPLOYEE>
<EID>1</EID>
<ENAME>
<FNAME>JOHN</FNAME>
<LNAME>ABRAHAM</LNAME>
</ENAME>
<DEPT>IT</DEPT>
</EMPLOYEE>
<EMPLOYEE>
<EID>2</EID>
<ENAME>
<FNAME>LEONARDO</FNAME>
<LNAME>DI CAPRIO</LNAME>
</ENAME>
<DEPT>CSC</DEPT>
</EMPLOYEE>
<sec:EMPLOYEES>
</first:EMPLOYEES>
And the initial version of XSD I used for reverse engineering,
<?xml version="1.0" encoding="UTF-8" ?>
<xsd:schema xmlns:xsd="http://www.w3.org/2001/XMLSchema" elementFormDefault="qualified">
<xsd:element name="EMPLOYEES">
<xsd:complexType>
<xsd:sequence>
<xsd:element name="EMPLOYEE" maxOccurs="unbounded">
<xsd:complexType>
<xsd:sequence>
<xsd:element name="EID" type="xsd:integer"/>
<xsd:element name="ENAME">
<xsd:complexType>
<xsd:sequence>
<xsd:element name="FNAME" type="xsd:string"/>
<xsd:element name="LNAME" type="xsd:string"/>
</xsd:sequence>
</xsd:complexType>
</xsd:element>
<xsd:element name="DEPT" type="xsd:string"/>
</xsd:sequence>
</xsd:complexType>
</xsd:element>
</xsd:sequence>
</xsd:complexType>
</xsd:element>
</xsd:schema>
Thank you very much in advance. Let me know your concerns.
Kind Regards,
Vishnukumar N