Data Warehousing and Data integration

XML validation by using XSD

More
2 years 6 months ago #23108 by Kennyc
Hi ETL-tools,

We are using Advanced ETL processor ENT 6.4.1.16

We found there is a XSLT transformation action. We want to validate a XML file with a XSD file before using XSLT transformation if the validation is successfull. If not, export a error result file that includes which xml record is failed.

Would like to know how to implement in AETL?

Best regards,

Kenny

 
The following user(s) said Thank You: admin

Please Log in or Create an account to join the conversation.

More
2 years 6 months ago #23109 by admin
Replied by admin on topic XML validation by using XSD
XSD validation is not currently support but very esy to implement

We will let you nw once it is ready

Mike
ETL Architect

Please Log in or Create an account to join the conversation.

More
2 years 6 months ago #23110 by Kennyc
Replied by Kennyc on topic XML validation by using XSD
Hi Mike,

Thank you for help.

Best regards,

Kenny

Please Log in or Create an account to join the conversation.

More
2 years 6 months ago #23172 by Peter.Jonson
Hi Kenny.

Just letting you know that your suggestion was implemented in the latest release





XML Example

<?xml version="1.0"?>
<note>
  <to>Tove</to>
  <from>Jani</from>
  <heading>Reminder</heading>
  <body>Don't forget me this weekend!</body>
</note>

XSD Example

<?xml version="1.0"?>
<xs:schema xmlns:xs=" www.w3.org/2001/XMLSchema ">

<xs:element name="note">
  <xs:complexType>
    <xs:sequence>
      <xs:element name="to" type="xs:string"/>
      <xs:element name="from" type="xs:string"/>
      <xs:element name="heading" type="xs:string"/>
      <xs:element name="body" type="xs:string"/>
    </xs:sequence>
  </xs:complexType>
</xs:element>

</xs:schema>

Apologies for the delay
 

Peter Jonson
ETL Developer

Please Log in or Create an account to join the conversation.

More
2 years 6 months ago #23175 by Kennyc
Replied by Kennyc on topic XML validation by using XSD
Hi Peter,

Thanks you for your quick support!!

I will try it once our technical team update to latest version.

Best regards,

Kenny

Please Log in or Create an account to join the conversation.

Cookies user preferences
We use cookies to ensure you to get the best experience on our website. If you decline the use of cookies, this website may not function as expected.
Accept all
Decline all
Read more
Marketing
Set of techniques which have for object the commercial strategy and in particular the market study.
Google
Accept
Decline
Analytics
Tools used to analyze the data to measure the effectiveness of a website and to understand how it works.
Google Analytics
Accept
Decline
Google Analytics
Accept
Decline
Functional
Tools used to give you more features when navigating on the website, this can include social sharing.
Advertisement
If you accept, the ads on the page will be adapted to your preferences.
Google Ad
Accept
Decline
Save