Real-time data replication and data integration

Welcome to DBMoto, providing data replication and transformation for your enterprise server and desktop needs. More than ever before, today's business applications depend on data from multiple databases. Whether deploying applications to provide customers with real-time answers, to furnish suppliers with time-critical production requirements, or to supply management with the latest metric and financial reports, key data comes from your core relational databases. Enterprises need to move data between database platforms. Fast data delivery between relational database platforms yields better performing applications. DBMoto does all this and more!

Achieving efficient data delivery with enterprise-sized data requires expertise in database server environments. HiT Software has been delivering relational data access products since 1994, and DBMoto incorporates our proven access technology to ensure high performance yet minimally intrusive data replication.

Real-Time Data Replication

DBMoto's Enterprise Manager includes wizards that help you easily connect to and identify source and target databases, create target tables, and set up replication processes. Replication mapping and rules are maintained in a metadata database that can be stored on any database platform. DBMoto's Enterprise Manager offers a graphical point-and-click interface that makes it easy to drill down into databases, tables, and columns to understand data elements. DBMoto was specifically designed to replicate data between databases in "refresh," "mirroring" or "synchronization" modes.

DBMoto's Enterprise Manager includes wizards that help you easily connect to and identify source and target databases, create target tables, and set up replication processes. Replication mapping and rules are maintained in a metadata database that can be stored on any database platform. DBMoto's Enterprise Manager offers a graphical point-and-click interface that makes it easy to drill down into databases, tables, and columns to understand data elements. DBMoto was specifically designed to replicate data between databases in "refresh," "mirroring" or "synchronization" modes.

Unmatched Database Replication and
Database Transformation Control

With DBMoto, users define data replication and transformations by applying business rules and mapping. Unlike other solutions, DBMoto offers unlimited control over data replication and transformation using programming or scripting technologies. DBMoto supports two mapping methods: automatic mapping, where source field values are duplicated for the target table, and manual mapping. Both methods can be optionally controlled programmatically or via scripts. DBMoto also includes a powerful expression generator for interactive data transformation.

A key advantage of DBMoto is data delivery and transformation control via scripts and events independent of the associated databases. DBMoto automatically generates replication events during operation. Administrators can define responses to these events with scripts and configure DBMoto to be notified via email if critical events occur.

DBMoto also includes a Windows environment accessible object class that provides detailed control of source and target data during replication. The object properties and methods give users control to perform source or target table lookups, append log activity, and update target tables. All information retrieved from transaction logs, such as user, date and time and device is available within the class object.
 

click here for detailed diagram
 

No Programming Required on Source or Target Databases

Though optionally extendable on the middle tier Windows platform, DBMoto does not require any programming on the source or target database platforms: no programming needed on the source database; no stored procedures to develop; no proprietary syntax to learn.

click here for detailed diagram
 

Key Features:

• Support for all major database platforms: IBM DB2 UDB
  (including System i/iSeries/AS400 and zOS), Oracle,
  Microsoft SQL Server, MySQL, Sybase Adaptive Server
  Enterprise, SQL Anywhere, Ingres, Informix, MS Access,
  Gupta SQL Base, Solid, Firebird, PostgreSQL and ANTs
• Replication modes: refresh, mirroring, synchronization
• Administrative wizards for fast, easy configuration and setup
• No programming needed on source or target database platforms
• Full customization via Microsoft VB.NET scripting and
  event-driven environment
• Built-in transformation functions, with custom functions definable at any time
• Remote accessibility of Enterprise Manager for centralized
  configuration and management
• Extensive log reporting and accessibility
• Powerful visual tool to provide information on replication status
• Object-oriented data access on both source and target databases
• Automatic creation of target tables
• Configuration and management of entire replication process from Windows platform
• User-friendly and graphical interface
• Standard protocols (.NET, OLE DB and ODBC) to access
  tables in source and target databases

Database Sources Supported (Refresh Mode):
IBM System i5
IBM iSeries and AS/400 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
Oracle v8 and later
Microsoft SQL Server v6.5 and later
MySQL v3.23 and later
Sybase ASE v12.50 and later
SQL Anywhere
IBM Cloudscape
Ingres 2006
Informix
Gupta SQLBase Server v8.5.0 and later
MS Access 97 and later
Solid
Firebird
PostgreSQL
ANTs

Database Sources Supported
(Mirroring and Synchronization Modes):
IBM System i5, iSeries and AS/400 V4R3 and later
IBM DB2 for z/OS (OS/390) v5 and later Oracle v8 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 SQLBase
Sybase ASE v12.50 and later
Sybase SQL Anywhere
Informix
ANTs

Database Targets Supported:
IBM System i5
IBM iSeries and AS/400 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
Oracle v8 and later
Microsoft SQL Server v6.5 and later
MySQL v3.23 and later
Sybase ASE v12.50 and later
SQL Anywhere
IBM Cloudscape
Ingres 2006
Informix
Gupta SQLBase Server v8.5.0 and later
MS Access 97 and later
Solid
Firebird
PostgreSQL
ANTs

System Requirements:
 
PC Server
Windows 2003/2000/NT Server
.NET Framework 1.1 or higher