• The Four Hundred
  • Subscribe
  • Media Kit
  • Contributors
  • About Us
  • Contact
Menu
  • The Four Hundred
  • Subscribe
  • Media Kit
  • Contributors
  • About Us
  • Contact
  • DataMirror Updates Transformation Server/ES

    May 1, 2007 Alex Woodie

    DataMirror last week launched a new release of Transformation Server Event Server (TS/ES), a special version of its data replication software designed to work with message queues used in enterprise application integration (EAI) and service oriented architecture (SOA) environments.

    DataMirror’s popular Transformation Server software has traditionally been used for extracting, transforming, and loading (ETL-ing) massive amounts of data from one relational database to another. In most cases, Transformation Server users are moving data from production DB2/400, DB2 UDB, Oracle, SQL Server, Sybase, or Teradata databases running on i5/OS, Windows, Unix, or Linux servers to a secondary database used for data warehousing, for real-time reporting or for keeping e-commerce Web apps synchronized with the production systems.

    With TS/ES, which was launched in September 2005, DataMirror has taken Transformation Server’s core changed data capture (CDC) functionality and applied it in a slightly different way. Instead of moving data from a database to another database, TS/ES takes the data from the production database, loads it into its embedded Java database, and then transforms it into the native formats used by the message queues of various EAI products, Enterprise Service Busses (ESBs) business performance management (BPM) products, or other applications that use SOA techniques to monitor and react to changing events. In this case, TS/ES is the engine driving data into real-time information systems and dashboards used by senior financial and accounting executives to make strategic decisions, while delivering better performance than using database triggers or performing queries.

    With the new version of TS/ES, DataMirror has tweaked the product to process high-volume, third-party message structures directly from queues, and to parse and embed that data without programming into relational database formats.

    The new product release, which was not further identified but comes on the heels of therelease of Transformation Server 6.0, also received enhancements to its GUI. With this release, the GUI requires little or no programming to use. Any DataMirror or third-party XML objects can now be taken from the message queue and applied directly to applications or databases, the company says.

    “Companies can now fully integrate business data with any database or application,” said Lucian Mustatea, vice president of development for DataMirror, which is headquartered in Toronto, Ontario. “They can leverage their existing investments in databases and message architectures to unlock new business opportunities.”

    RELATED STORY

    DataMirror Unveils Transformation Server 6.0



                         Post this story to del.icio.us
                   Post this story to Digg
        Post this story to Slashdot

    Share this:

    • Share on Reddit (Opens in new window) Reddit
    • Share on Facebook (Opens in new window) Facebook
    • Share on LinkedIn (Opens in new window) LinkedIn
    • Share on X (Opens in new window) X
    • Email a link to a friend (Opens in new window) Email

    Tags:

    Sponsored by
    New Generation Software, Inc.

    It’s Time!
    Replace IBM Query/400 and DB2 Web Query with NGS-IQ.

    IBM retired Query/400 and DB2 Web Query long ago. Is your company still at the party?
    Don’t keep your users waiting.

    Watch a demo on demand and see how NGS-IQ can save you time creating and updating ad-hoc queries; production reports; Excel sheets, tables, and ranges; Adobe PDF files; Web reports; and multidimensional models.

    www.ngsi.com – 800-824-1220

    Share this:

    • Share on Reddit (Opens in new window) Reddit
    • Share on Facebook (Opens in new window) Facebook
    • Share on LinkedIn (Opens in new window) LinkedIn
    • Share on X (Opens in new window) X
    • Email a link to a friend (Opens in new window) Email

    Sponsored Links

    COMMON:  Join us at the Annual 2008 conference, March 30 - April 3, in Nashville, Tennessee
    Seagull Software:  Web-enable your System i apps with LegaSuite GUI
    VAULT400:  Securely archive data with Instant Back-Up & 24x7 Recovery

    IT Jungle Store Top Book Picks

    The System i Pocket RPG & RPG IV Guide: List Price, $69.95
    The iSeries Pocket Database Guide: List Price, $59.00
    The iSeries Pocket Developers' Guide: List Price, $59.00
    The iSeries Pocket SQL Guide: List Price, $59.00
    The iSeries Pocket Query Guide: List Price, $49.00
    The iSeries Pocket WebFacing Primer: List Price, $39.00
    Migrating to WebSphere Express for iSeries: List Price, $49.00
    iSeries Express Web Implementer's Guide: List Price, $59.00
    Getting Started with WebSphere Development Studio for iSeries: List Price, $79.95
    Getting Started With WebSphere Development Studio Client for iSeries: List Price, $89.00
    Getting Started with WebSphere Express for iSeries: List Price, $49.00
    WebFacing Application Design and Development Guide: List Price, $55.00
    Can the AS/400 Survive IBM?: List Price, $49.00
    The All-Everything Machine: List Price, $29.95
    Chip Wars: List Price, $29.95

    Bottomline Launches New ‘Proof of Delivery’ Product HiT Software Updates Data Integration Tool

    Leave a ReplyCancel reply

Volume 7, Number 17 -- May 1, 2007
THIS ISSUE SPONSORED BY:

Lakeview Technology
Aldon
Bsafe
Computer Keyes
RJS Software Systems

Table of Contents

  • BCD Bringing PHP Generation to WebSmart IDE
  • MySQL Database Getting Closer Ties to the System i
  • Quadrant Updates Forms Package, Content Management System
  • IBM Rolls Out LTO 4 Tape Drives and Libraries
  • Oracle Seeks Better Third-Party Integration with AIA Initiative
  • Bottomline Launches New ‘Proof of Delivery’ Product
  • DataMirror Updates Transformation Server/ES
  • HiT Software Updates Data Integration Tool
  • LANSA Gets its Game On
  • Proginet Partners with Canadian System i Reseller

Content archive

  • The Four Hundred
  • Four Hundred Stuff
  • Four Hundred Guru

Recent Posts

  • Oracle Dips A Toe Into IBM’s EBCDIC World
  • When Your Small IBM i Team Is Really A Team Of One
  • Guru: Putting Failure Handling In Its Place
  • Inside The Security Enhancements In ACS
  • IBM i PTF Guide, Volume 28, Number 28: A Crazy Number of Security Vulnerability Patches
  • IBM i PTF Guide, Volume 28, Number 29
  • Inside The Encryption Key Management Changes In IBM i 7.6
  • FalconStor Moved To The Blue Lagoon, And Is Poised For Growth Because Of It
  • Guru: Claude’s SQL Tip
  • Astera Makes Extracting Legacy Report Data an AI Specialty

Subscribe

To get news from IT Jungle sent to your inbox every week, subscribe to our newsletter.

Pages

  • About Us
  • Contact
  • Contributors
  • Four Hundred Monitor
  • IBM i PTF Guide
  • Media Kit
  • Subscribe

Search

Copyright © 2025 IT Jungle