Great news both Advanced ETL Processor and Visual Importer ETL support now XSLT transformations.

A lot of XML files have very complex structure and XSLT allows to transform the data into more readable format:

<table>
<record>
<field1>value1<field1>
<field2>value2<field1>
<record>
<record>
<field1>value1<field1>
<field2>value2<field1>
<record>
<table>

XML can be transformed before loading the data or if the user wants to process/validate XML which is stored in the database field two new data transformation functions can be used

XML Transfomation Functions

XML Data Source Options

We would like to thank our customers for providing useful feedback

Direct link, no registration required.