Buy Download Contact Us

Linked InTwitterFacebookBlogFeedYouTube

Chinese Website
Japanese Website

DBMoto for Informix
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 Server data replication,
            data migration, data transformation, and database synchronication for DB2, Oracle and SQL Server

DBMoto for Informix

DBMoto is the preferred solution for heterogeneous Data Replication, Change Data Capture and Data Transformation requirements in an enterprise environment. DBMoto now supports transaction log-reading for IBM® Informix databases, providing Informix users with fast, efficient Change Data Capture between Informix databases and many other relational databases.

Whether you are migrating data to a lower TCO database, synchronizing data between IBM Informix and operational systems, creating a new data warehouse 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 integration projects for IBM Informix users.

If you are synchronizing data from multiple IBM Informix databases, you need a data integration solution that can quickly and automatically identify, map and replicate data, with the least amount of time and effort. 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 been delivering relational data access products since 1994, and DBMoto incorporates proven integration technology to ensure high performance yet minimally intrusive data synchronization, using Change Data Capture (CDC) for maximum efficiency.

            Data Replication
Full Support
during Trial Period

Real-Time Data Replication and Change Data Capture

DBMoto provides three replication modes for IBM Informix databases:

  • Refresh (Snaphot) mode: Reads data set, applies administrator-defined mapping rules, and writes the entire data set to target database.
  • Mirroring (CDC) mode: Provides one-way replication between IBM Informix and target
    database(s) in real-time using transaction log-reading and Change Data Capture for fast, efficient, data updates.
  • Synchronization Mode: Provides bi-directional mirroring between multiple sources and targets, with built-in conflict resolution and Informix transaction log-reading.
DBMoto's Management Center GUI console includes advanced features:
  • Identifies and connects to multiple source and target 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 the source or target database platforms in order to deploy or run its powerful data integration features.
DBMoto provides all functionality in easy GUI and wizard-based screens; no stored procedures to develop; and no proprietary syntax to learn.

DBMoto for Informix Management Center Screen Shot

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 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.

Key Features

Database Support

  • Support for all major databases as sources: IBM Informix, IBM DB2 (including IBM i/AS400, z/OS, Linux, AIX, Windows), Oracle, Microsoft SQL Server, MySQL, Sybase Adaptive Server Enterprise, SQL Anywhere, Ingres, Cloudscape, Gupta Technologies SQLBase and PostgreSQL
  • Support for IBM Netezza data warehouse and analytic appliances
  • Support for database 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 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 from DBMoto’s Management Center 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 Informix, version 11.5 and later (log-reading)
IBM Informix, all versions (triggers)
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 Netezza
Oracle v8 and later
Microsoft SQL Server v6.5 and later
MySQL v3.23 and later
Sybase ASE v12.50 and later
SQL Anywhere
Ingres 2006
Gupta Technologies SQLBase Server v8.5.0 and later

Databases Supported as Sources (Mirroring and Synchronization Modes)
IBM Informix, version 11.5 and later (log-reading)
IBM Informix, all versions (triggers)
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
Oracle v8 and later
Microsoft SQL Server v6.5 and later
MySQL v3.23 and later
Gupta Technologies SQLBase
Sybase ASE v12.50 and later
Sybase SQL Anywhere

System Requirements:
Windows Server 2008/2003/2000/NT
Microsoft .NET framework 2.0, SP 2, or Microsoft .NET framework 3.5, SP1
Informix drivers, version 3.70 and later

DBMoto Data Replication
Full Support
during Trial Period

IBM Advanced Business Partner
Oracle Gold Partner

© 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 Cloud G Edition DBMoto v8 DBMoto for HP Vertica DBMoto for SQL Server DBMoto for Oracle DBMoto for SAP HANA DBMoto for IBM DB2 LUW DBMoto for IBM DB2 for z/OS