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

  • Closeup of the new Copilot keyboard key

    Microsoft Updates Copilot To Add Context-Sensitive Agents to Teams, SharePoint

    Microsoft has rolled out a new public preview for collaborative "always on" agents in Microsoft 365 Copilot, bringing enhanced, context-aware tools into Teams channels, meetings, SharePoint sites, Planner workstreams and Viva Engage communities.

  • Windows 365 Cloud Apps Now Available for Public Preview

    Microsoft announced this week that Windows 365 Cloud Apps are now available for public preview. This aims to allow IT administrators to stream individual Windows applications from the cloud, removing the need to assign Cloud PCs to every user.

  • Report: Security Initiatives Can't Keep Pace with Cloud, AI Boom

    The increasingly fast adoption of hybrid, multicloud, and AI systems is easily outgrowing existing security measures, according to a recent global survey by the Cloud Security Alliance (CSA) and exposure management firm Tenable.

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