Make
a big impact on your business without making a big impact on your mission-critical
systems.
Whether your mission-critical business applications run on DB2, Oracle, SQL
Server, or Sybase you can count on Transformation Server to enable your data
integration projects and solve important business problems—without risking your
enterprise or your job.
Your CFO won't be impressed if you have to replace, re-architect, or rebuild
your current IT infrastructure. Preserve your existing IT investments and
implement a low-risk solution. Transformation Server solves a wide variety of
business problems that require high volumes of information to be distributed
between diverse systems in real time.
Read about how Transformation Server
works seamlessly with all of the other components of
Integration Suite, allowing you to cost-effectively expand your integration capabilities.
About Transformation Server
DataMirror's Transformation
Server software provides real-time, bi-directional data integration and
transformation directly between diverse relational databases and other data
stores on different platforms. Find out more about
Transformation Server's versatility, performance, and ease of use.
Over the past decade, DataMirror has helped over 2,000 customers with their
real-time integration and protection requirements. Unlike traditional ETL,
batch load, query or message-based systems, Transformation Server was designed
from the very beginning to deliver scalable, high performance data integration
in real time with minimal latency. As well, Transformation Server's unique log
scraping change data capture architecture has a minimal impact on the
performance of your operational applications. Read our white paper on
"The Benefits of Transformational Data Integration".
For more information or for a demonstration, contact us at
412-741-1677 or by e-mail at sales@treehouse.com.
Who Needs Transformation Server?
Companies who want to load their data warehouses in real time so they can make
operational and tactical business decisions based on the latest information.
Companies who have recently undergone a merger or acquisition and need to
consolidate and distribute information between diverse systems.
Shipping companies who want to provide customers with access to real-time
shipment information from their Web site, while minimizing the impact on their
mission-critical logistics systems they use to ensure efficient continuous
operations.
Public companies who need to conduct consolidated financial reporting across a
range of transactional systems in different regions, departments, or business
units.
Other businesses who need to improve the operational performance of their
systems, which is being adversely affected by shrinking nightly batch windows
and expensive query and reporting functions.
Customer
Successes Include:
Acushnet
Company
Debenhams
GMAC Commercial Mortgage
Health Alliance
Lyndale Foods Group
Tiffany & Co.
Our
Customers Say
"Transformation Server's robust, real-time data integration capabilities provide
us with high visibility into inventory levels, sales reports, e-Business channels,
and other business-critical operations, allowing us to better manage sales cycles
and deliver superior customer experiences worldwide."
Jim Hill, Manager of Database Services
Tiffany & Co.
Key Product Features:
Business Benefits:
Change Data Capture
Whether data is integrated in real-time or periodically, only changed data is
captured and transferred from publisher to subscriber systems.
Change data capture improves operational efficiency and saves time and
resources by eliminating redundant data transfer and saving network bandwidth.
Zero Programming/Multi-Platform Support
Out-of-the-box, programming-free data integration between DB2 UDB, Microsoft SQL Server, Oracle, Sybase, Teradata, XML, and PointBase across UNIX, Linux, Microsoft Windows NT/2000/XP/2003, IBM OS/400, OS/390 and z/OS. Flat file integration is also supported.
With zero programming required, existing programming staff can invest their time in higher value-added IT projects. Companies can leverage their legacy systems and integrate data across all supported platforms without making changes to their existing environment. Future changes in the computing environment can also be easily accommodated to future-proof your investment.
High-Performance Communications
Fine-tuned architecture for optimizing communications between source and target systems. Supports the efficient transmission of data, including large object binaries (LOBs) such as multi-media audio and video data.
Improve integration network performance and robustness, and make efficient use of available bandwidth. Minimize manual intervention required for setup and maintenance of the network.
Built-in Transformation and Filtering
Translate values, derive new calculated fields, join tables at the source or target, and more. Create, store, and retrieve custom data transformations as macros. Row/column selection allows users to limit access to sensitive information or flow user-specific data to particular sites.
Massage, cleanse and filter corporate and customer data for enhanced data quality and more accurate decision making. Ensure sensitive data is securely delivered and accessible to only authorized recipients.
Direct Peer-to-Peer Integration
Peer-to-peer architecture and native support for TCP/IP ensure direct database connectivity. No data staging or gateway technologies are required.
Ensure information flows in the most efficient and fastest path directly between source and target systems. Maximize information delivery to employees, allowing them to make intelligent business decisions based on the most current information.
Enterprise Administrator Monitor
A graphical tool for viewing and monitoring the integration network through user-defined views. The Monitor actively pulls and displays replication metrics, such as status and latency, providing an up-to-date health check of the system.
Monitor complex integration networks at various levels of granularity to better understand the health of your network and accelerate problem determination and resolution. Easily create, copy, re-use, or delete user-defined network diagrams, saving time and increasing efficiency.
Extended Update Options
Summarization allows users to summarize numerical data from multiple rows in one or more source tables into a single row in a target table. Row consolidation allows users to merge data from multiple source tables into one or more rows in a target table. Adaptive apply gives users the option to specify that the same operation that occurred on the source table will be applied to the target table, regardless of the absence or presence of the source row in the target table.
Extended update options provide more flexible replication capabilities in data warehousing environments, resulting in better database design, lower processing power and storage capacity requirements, and more ease of use in querying and reporting.
Role-Based Security
Assign each Enterprise Administrator user to one of four roles, which differ according to the range of operations that can be performed.
User access to a replication can be confined to just monitoring or expanded to also allow modifications to a configuration, allowing you to distribute administrative duties while maintaining control.
Whether your mission-critical business applications run on DB2, Oracle, SQL
Server, or Sybase you can count on Transformation Server to enable your data
integration projects and solve important business problems—without risking your
enterprise or your job.
Transformation
Server Fact Sheet 
DataMirror Presentation