News

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.

Featured

  • Report: Cost, Sustainability Drive DaaS Adoption Beyond Remote Work

    Gartner's 2025 Magic Quadrant for Desktop as a Service reveals that while secure remote access remains a key driver of DaaS adoption, a growing number of deployments now focus on broader efficiency goals.

  • Windows 365 Reserve, Microsoft's Cloud PC Rental Service, Hits Preview

    Microsoft has launched a limited public preview of its new "Windows 365 Reserve" service, which lets organizations rent cloud PC instances in the event their Windows devices are stolen, lost or damaged.

  • Hands-On AI Skills Now Outshine Certs in Salary Stakes

    For AI-related roles, employers are prioritizing verifiable, hands-on abilities over framed certificates -- and they're paying a premium for it.

  • Roadblocks in Enterprise AI: Data and Skills Shortfalls Could Cost Millions

    Businesses risk losing up to $87 million a year if they fail to catch up with AI innovation, according to the Couchbase FY 2026 CIO AI Survey released this month.