Buy Download Contact Us

Linked InTwitterFacebookBlogFeedYouTube

Chinese Website
Japanese Website

DBMoto Data Sheet

Web Presentation

DBMoto web presentationView (WMV)
Case Studies

case studiesView


USA and Canada
Latin America

data replication, sychronization and integration for DB2, Oracle and SQL Serverdata replication, data migration, data transformation, and database synchronication for DB2, 
                Oracle and SQL Server

DBMoto for IBM DB2 LUW

DBMoto is the recommended solution for heterogeneous Data Replication, Change Data Capture and Data Transformation requirements in an enterprise environment. Whether you are migrating data to IBM DB2, sharing data between DB2 LUW and other databases for querying and reporting, synchronizing data among operational systems, creating a new data warehouse or analytics data mart or creating a backup of key corporate data, DBMoto is the solution of choice for fast, trouble-free, easy-to-maintain data replication projects.

DBMoto easily replicates data between any version of IBM DB2 databases, as well as between DB2 LUW and all major heterogeneous databases.

Providing an efficient visual interface, intuitive wizards and easy-to-follow guides, DBMoto helps IT staff implement the toughest replication and Change Data Capture (CDC) requirements quickly and easily. DBMoto is mature and approved by enterprises ranging from midsized to the Fortune 1000 worldwide.

Enabling dependable data delivery in enterprise environments requires expertise in database servers. HiT Software has been offering relational data access products since 1994. DBMoto incorporates proven integration technology to ensure high performance yet minimally intrusive data replication using Change Data Capture for maximum efficiency.

            Data Replication
Full Support
during Trial Period

Real-Time Data Replication and Change Data Capture

DBMoto provides an easy, cost-efficient way to replicate data between DB2 LUW and other databases and maintains continuous updates to that data using Change Data Capture (CDC). DBMoto shields users from programming requirements through its intuitive and graphical interfaces for replication, job status, data comparisons (before and after replications) and error management.

DBMoto is specifically designed to replicate data between DB2 LUW and other databases in the following ways:

  • Refresh (Snaphot) mode: Reads data set, applies administrator-defined mapping rules, and writes the entire result to the target database.
  • Mirroring (CDC) mode: One-way replication using real-time CDC from source to target based on transaction log management, allowing the greatest degree of accuracy and timeliness through change data capture.
  • Synchronization: Uses DBMoto's CDC-based transaction log management and custom conflict resolution strategies to keep multiple databases bi-directionally synchronized.
DBMoto's Management Center GUI console:
  • Manages source and target connections to DB2 LUW and other databases
  • Creates target tables
  • Manages and controls access to replication configurations
  • Sets up replication processes and groups them for efficient execution
  • Stores replication mapping and rules in a metadata database
  • Monitors replication processes, compares results, and analyzes issues
  • Provides real-time information on replication status
  • Records replication activity, performance, and errors into logs, to quickly spot and manage errors

Powerful, Flexible, Configurable, Change Data Capture!

DBMoto does not require any programming on DB2 LUW, or on any source or target database platforms in order to deploy or run its powerful data replication features.
DBMoto provides all functionality in easy GUI and wizard-based screens; no stored procedures to develop; and no proprietary syntax to learn.

DBMoto: Management Center

Unmatched Replication and Transformation Control

With DBMoto, users define data replication and transformations by applying built-in mapping and customized business rules.

Business rules can be applied through scripts which filter data or add business logic to a replication. They are generally implemented through automatically-generated events during a DBMoto replication. Scripting can perform source/target table lookups, append log activity and update target tables. DBMoto also includes a powerful expression generator for interactive data transformation. Once compiled, scripts become a part of the DBMoto implementation.

DBMoto: Replication Wizard

Key Features

Database Support

  • Data replication performed on DB2 LUW logs
  • Support for all major databases as sources or targets: IBM DB2 (including IBM i/AS400, z/OS, Linux, AIX, Windows),Oracle, Microsoft SQL Server, MySQL, Sybase Adaptive Server Enterprise, SQL Anywhere, Ingres, IBM Informix, Gupta Technologies SQLBase and PostgreSQL
  • Support for IBM® PureData™ for Analytics systems (Netezza) as targets
  • Support for SAP HANA, HP Vertica and Actian Vectorwise as targets
  • Support for database and Windows cluster environments
  • Support for Cloud database environments and databases
  • Open APIs to integrate DBMoto into corporate architectures, or into third-party solutions

Replication Support

  • Replication modes: Refresh (snapshot), Mirroring (change data capture),
    Synchronization (real-time bi-directional mirroring with conflict resolution)
  • "Multi-Server Synchronization" to synchronize changes bi-directionally between source and multiple targets, with built-in conflict resolution
  • Automatic creation of target tables
  • Extensive log reporting and accessibility
  • Powerful visual tool for information on replication status and errors
  • DBMoto Verifierť™ tool to easily compare and resolve replication differences for accuracy and auditing
  • Built-in transformation functions, with custom functions definable at any time

User Support

  • User-friendly graphical interface
  • Administrative wizards for fast, easy configuration and setup
  • Configuration and management of entire replication process from DBMoto's Management Center console on Windows platform
  • Remote administration of DBMoto Replicator through Management Center
  • Customizable via Microsoft VB.NET scripting and event-driven environment
  • Extensive security including user authentication and other options
  • No programming needed on source or target database platforms
  • Source and target table access via standard .NET data provider protocol

Databases Supported as Targets (Refresh and Mirroring Modes)
IBM DB2 for i and AS400 V3R2 and later
IBM DB2 for z/OS (OS/390) v5 and later
IBM DB2 for LUW v5 and later
IBM Informix v9.5 and later
IBM PureData/Netezza
Microsoft SQL Server v6.5 and later
SAP Sybase ASE v12.50 and later
SAP Sybase SQL Anywhere
Ingres 2006
Gupta Technologies SQLBase Server v8.5.0 and later
Actian Vectorwise
HP Vertica

Databases Supported as Sources (Mirroring and Synchronization Modes)
IBM DB2 for i and AS400 V4R3 and later
IBM DB2 for z/OS (OS/390) v5 and later
IBM DB2 for LUW v5 and later
IBM Informix v9.5 and later
MySQL v5.1.31 and later log-based
MySQL v4.1.5 and later trigger-based
Oracle v8 and later
Microsoft SQL Server v6.5 and later
SAP Sybase ASE v12.50 and later
SAP Sybase SQL Anywhere
Gupta Technologies SQLBase

System Requirements:
Windows Server 2012/2008/2003
.NET framework 4.0 or higher

DBMoto Data Replication
Full Support
during Trial Period

Technology Partner Alliances

© 2016 HiT Software, Inc., A BackOffice Associates, LLC Company. All Rights Reserved.

DBMoto for IBM i DBMoto for DSP DBMoto for IBM PureData System for Analytics (Netezza) DBMoto Cloud Edition DBMoto for Vectorwise DBMoto for MySQL DBMoto for IBM Informix DBMoto for HP Vertica DBMoto Cloud G Edition DBMoto v8 DBMoto for SQL Server DBMoto for Oracle DBMoto for SAP HANA DBMoto for IBM DB2 for z/OS