Buy Download Contact Us

Linked InTwitterFacebookBlogFeedYouTube

Chinese Website
Japanese Website



Data Sheet

Web Presentation

DBMoto web presentationView (WMV)
Solutions Brief

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 real-time data replication and data integration  

Real-time Data Replication
and Change Data Capture

DBMoto Data Replication
Full Support
during Trial Period

Data Sheet
DBMoto is the preferred solution for your heterogeneous Data Replication, Change Data Capture and Data Transformation requirements in an enterprise environment. Whether you are migrating data to a lower TCO database, synchronizing data among disparate operational systems, creating a new data warehouse, columnar or high-speed analytic database or data mart environment for analytics, building a business intelligence application or creating a backup of key corporate data, DBMoto is the solution of choice for fast, trouble-free, easy-to-maintain Data Replication and Change Data Capture projects.

If you depend on data from multiple databases, you need a data integration solution that supports major relational database systems, data warehouse appliances and big data systems, and that works out-of-the-box. Using an efficient visual interface, intuitive wizards and easy-to-follow guides, DBMoto helps IT staff implement the toughest replication requirements quickly and easily. DBMoto is mature and approved by enterprises ranging from midsized to Fortune 1000 businesses worldwide.

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

DBMoto : data replication refresh, migration and sychronization

Click here for detailed diagram

Real-Time Data Replication and Change Data Capture
DBMoto is specifically designed to replicate data between databases in the following ways:

  • Refresh (snapshot) mode: DBMoto reads the data set, applies administrator-defined mapping rules, and writes the entire result to the target database.
  • Mirroring mode: One-way replications from source to target in real-time, using Change Data Capture (CDC) based on transaction log management whenever possible.
  • Synchronization mode: Uses DBMoto's CDC and transaction log management capabilities and custom conflict resolution strategies to keep two or more databases continuously synchronized.
DBMoto's Management Center GUI console includes features to easily:
  • Identify and connect to multiple source and target databases
  • Create target tables
  • Manage and control access to replication configurations
  • Set up replication processes and group them for efficient execution
  • Store replication mapping and rules in a metadata database
  • Monitor replication processes, compare results, and analyze issues
  • View real-time information on replication status
  • Record replication activity, performance, and errors into logs,
    providing a quick method to spot and manage errors

Powerful, Flexible, Configurable, Easy-to-Manage Change Data Capture!

DBMoto does not require any programming on the 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 : DB2, iSeries and AS400 database replication and synchronization Enterprise Manager

Click here for detailed diagram

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 are used to filter data or to add business logic to a data 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.

DBMoto : DB2, IBM i  and AS400 database replication and synchronization Enterprise Manager

Key Features

Database Support

  • Support for all major relational databases: 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, PostgreSQL, Firebird and
    MS Access
  • Support for IBM® Netezza data warehouse and analytic appliances
  • Support for high-speed, columnar analytic databases/platforms HP® Vertica™ and
    Actian™ Vectorwise™
  • Support for data replication in Cloud environments using Google App Engine™ Datastore and for disconnected databases
  • Support for database cluster environments
  • 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 to provide information on replication status and errors
  • DBMoto Verifierť™ tool to easily compare and reconcile replication results for accuracy and auditing
  • Support for extended data types, such as XML
  • 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 through one or many DBMoto Management Center console(s) on Windows platform
  • Remote administration of DBMoto Replicator through Management Center
  • Centralized metadata management and multi-user support for replication management
  • Customizable via Microsoft VB.NET scripting and event driven environment
  • Extensive security including user and certificate authentication via TCP/IP and HTTP
  • No programming needed on source or target relational database platforms
  • Relational database 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 Windows v5 and later
IBM DB2 for AIX, Linux, HP/UX, Solaris v5 and later
IBM Informix
IBM Netezza
Oracle v8 and later
Microsoft SQL Server v6.5 and later
MySQL v3.23 and later (Previous versions are trigger-based)
Sybase ASE v12.50 and later
SQL Anywhere
Ingres 2006
Actian™ Vectorwise™
HP® Vertica™ v6.0 and later
Gupta Technologies SQLBase Server v8.5.0 and later

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 Windows v5 and later
IBM DB2 for AIX, Linux, HP/UX, Solaris v5 and later
IBM Informix
IBM Netezza
Oracle v8 and later
Microsoft SQL Server v6.5 and later
MySQL v3.23 and later (Previous versions are trigger-based)
Gupta Technologies SQLBase
Sybase ASE v12.50 and later
Sybase SQL Anywhere

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

DBMoto Data Replication
Full Support
during Trial Period

IBM Advanced Business Partner
Oracle Gold Partner

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