Skip to Main Content

Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

XML Reverse Engineering using XSD in ODI

TN RaghuveerNov 17 2019

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

Comments

Post Details