XML and XSD question

dataservices realtime
1

Hello Forum! I am using BODS 14.0, running on a Win 2008 Server.

I have defined an XML Schema using an XSD file, and am processing XML files loading into SQL Server. In the DF, I right-click the Schema Object and select Open to view the properties. There is a check box labeled “Enable validation”, which I have NOT checked.

Unfortunately some of the XML files are “malformed” in the sense that they do not validate against the XSD. Even though the above check box is in-active, DS still wants to validate my XML which results in an error. Is there a way to have BODS process an XML file with NO validation whatsoever? Can I configure my Job to effectively “pass over” any validation errors?

Thanks in advance for any assistance!

CNV_Ben (BOB member since 2002-08-15)

2

The basic validation has to happen always, you cannot load a table specifying a column X of the target table has none, there it is called Y. Same for XML (row) and XSD (table).
The enable_validation turns on/off advanced XSD rules like internal constraint “The value of this field can only be a,b or c”.

Werner Daehn :de: (BOB member since 2004-12-17)

3

Thanks Werner! I think I am going to build my WF to include Pass/Fail logic so messages which fail validation can be logged and “returned to sender”.

~Ben

CNV_Ben (BOB member since 2002-08-15)