DataMirror Transformation Server is a high performance, peer-to-peer data replication solution that integrates data bi-directionally between multiple computing platforms and moves data in real time (with lower latency than batch loading, query or message-based systems). It can be deployed quickly and easily using a graphical user interface to solve many different business problems.

With a powerful real-time data integration solution, today’s organizations are making better business decisions, running smoother operations, winning new customers and partners, and increasing their bottom line. They’re using Transformation Server to:
•   Load data warehouses in real time so they can make operational and tactical business decisions based on the latest information
•   Distribute information between different applications to ensure accurate and reliable data across the enterprise
•   Integrate information between mission critical systems and Web applications so employees, customers and partners have access to real-time information
•   Consolidate financial data across systems in different regions, departments, or business units
•   Improve the operational performance of systems that are adversely affected by shrinking nightly batch windows and expensive query and reporting functions

Rather than using triggers or performing queries against the database, Transformation Server uses best-of-breed log-based change data capture (CDC) technology to capture changed data from database logs. This ensures that the performances of even the most demanding mission-critical applications running on the source system aren’t adversely impacted. Transformation Server’s easy-to-use GUI makes it simple to select source and target databases and then configure transformations. The net result: faster implementation, lower cost, and increased return on investment.

How does it work? Data changes are captured in the source system as they happen and the changes flow immediately to the target systems. All information is up-to-date and in sync. With CDC, data is processed throughout the day, as the changes occur, rather than during a nightly batch window. This means organizations can eliminate redundant data transfer, free up their batch window for other tasks, and save network bandwidth.

Customers use Transformation Server to solve many different business problems across a wide range of platforms – from mainframe to mobile. Use it to load a data warehouse, synchronize data between existing systems and Web applications, distribute and consolidate data between different applications, or manage other replication-based requirements. It can be deployed in a variety of architectures, on many different platforms, and between all major databases including DB2, UDB, Microsoft SQL Server, Oracle, Sybase, Teradata, XML and PointBase.