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

  • World Map Image

    Microsoft Taps Nebius in $17B AI Infrastructure Deal To Alleviate Cloud Strain

    Microsoft has signed a five-year, $17.4 billion agreement with Amsterdam-based Nebius Group to expand its AI computing capabilities through third-party GPU infrastructure.

  • Microsoft Brings Copilot AI Into Viva Engage

    Microsoft 365 Copilot in Viva Engage is now generally available, extending Copilot's AI-powered assistant capabilities deeper into the Viva platform.

  • MIT Finds Only 1 in 20 AI Investments Translate into ROI

    Despite pouring billions into generative AI technologies, 95 percent of businesses have yet to see any measurable return on investment.

  • 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.

Most   Popular