Thoughts on data transformation and Data Junction

Thoughts on data transformation and Data Junction

In response to your quote:
"You can't just import an XML file and magically have it available to your program. You have to first put it through some sort of transformation, which requires work that is unnatural or unwieldy."
I wonder if you have used a tool called Data Junction? Our software has had XML support for a few years now (ok, so I work there) and even novices can map XML documents to and from any other format, including automation objects (ActiveX and Java). I don't intend to spam your column but just that I was taken aback by the use of the terms unnatural and unwieldy. If that is truly the case, then I must fall into the chest-beating technologist category the precursor article described -- because I have been creating and parsing XML documents with ease since the anti-climatic Y2K... and I have only the most rudimentary of programming skills.

    Requires Free Membership to View

    When you register, you'll begin receiving targeted emails from my team of award-winning writers. Our goal is to keep you informed on recent service-oriented architecture (SOA) and SOA-related topics such as integration, governance, Web services, Cloud and more.

    Hannah Smalltree, Editorial Director

    By submitting your registration information to SearchSOA.com you agree to receive email communications from TechTarget and TechTarget partners. We encourage you to read our Privacy Policy which contains important disclosures about how we collect and use your registration and other information. If you reside outside of the United States, by submitting this registration information you consent to having your personal data transferred to and processed in the United States. Your use of SearchSOA.com is governed by our Terms of Use. You may contact us at webmaster@TechTarget.com.

Data Junction is proprietary software -- not a standard API such as SAX or DOM. Also, what you describe is only feasible for simply structured XML -- such as results from database table dumps or object serialisations. Try it with Docbook or XHTML!


This was first published in February 2003