XML to DB Transfer Tool Ships

DataMirror is shipping version 3 of its DB/XML Transform tool for providing data exchange between XML, text, database and EDI file formats.

Enhancements to DB/XML 3.0 include support for service-oriented architecture (SOA) integration, improved error reporting, enhanced platform support and embedded database functions aimed at lowering integration costs of moving data between multiple source and target applications, according to the Markham, Ontario firm.

Other new and improved features include a Web services control, which supports sourcing and targeting Web services and integration within an SOA, as well as logging of rejected records for simplified administration and monitoring of records rejected during text-to-database transformations. If a record from the source text file fails to be sent to a target database, it is stored in a text file with the same structure as the data source.

In addition, DB/XML 3.0 now supports transformations of flat files so that users can define the file structure of source flat files in a schema file when integrating XML, EDI, and text with applications, relational databases or message queues. Developers can also use multiple flat files as a source, enabling them to perform joins between multiple flat files into a single business transaction before the files are sent to an application, database or message queue.

DB/XML 3.0 also adds support for integrating information into applications through a message queue by targeting Java Message Service queues natively. Also, version 3 embeds DataMirror’s PointBase, a SQL92/99 JDBC-compliant Java relational database. It provides a built-in staging database for performing joins and other complex transformations as data is mapped between business applications.

About the Author

Stuart J. Johnston has covered technology, especially Microsoft, since February 1988 for InfoWorld, Computerworld, Information Week, and PC World, as well as for Enterprise Developer, XML & Web Services, and .NET magazines.


  • The 2021 Microsoft Product Roadmap

    From Windows 10X to the next generation of Microsoft's application server products, here are the product milestones coming down the pipeline in 2021.

  • After High-Profile Attacks, Biden Calls for Better Software Security

    Recent high-profile security attacks have prompted the Biden administration to issue an executive order aiming to tighten software security practices across the board.

  • With Hybrid Networks on Rise, Microsoft Touts Zero Trust Security

    Hybrid networks, which combine use of cloud services with on-premises software, require a "zero trust" security approach, Microsoft said this week.

  • Feds Advise Orgs on How To Block Ransomware Amid Colonial Pipeline Attack

    A recent ransomware attack on a U.S. fuel pipeline company has put a spotlight on how "critical infrastructure" organizations can prevent similar attacks.