0 Replies Latest reply on Nov 17, 2019 10:04 PM by TN Raghuveer

    XML Reverse Engineering using XSD in ODI

    TN Raghuveer
    TN Raghuveer Nov 17, 2019 10:04 PM

      Hello,

       

      I have a valid xsd, I tried to reverse engineer the XML file using the XSD by placing it on my local desktop, when I reverse engineer the XML all the attributes of Datastores whose XSD data type is xs:string are being converted as VARCHAR 255, where as XSD has a restriction on simple type attributes as below:

       

      <xs:simpleType name="ABCD">

      <xs:restriction base="xs:string">

      <xs:maxLength value="30"/>

      </xs:restriction>

      </xs:simpleType>

       

       

      I am expecting the datastore attribute ABCD after reverse engineering should have a column with data type varchar 30, instead of varchar 255, I have done some research on xml driver properties of default_type_varchar (or dtvc) / 

      default_length_varchar (or dlvc) these properties are applicable only to "XML annotation and documentation elements" and not for the regular attributes.

      As per the documentation, restriction is supported by XML Driver, still it is going wrong somehow :

      https://docs.oracle.com/cd/E28280_01/integrate.1111/e12644/appendix_xml_driver.htm#ODIKM154

      Using ODI : 12.2.1.0.0

      Please help me fixing this issue