Buy Download Contact Us

Linked InTwitterFacebookBlogFeedYouTube

Chinese Website
Japanese Website



DBMoto for Netezza
Data Sheet


pdfPDF
Web Presentation

DBMoto web presentationView (WMV)
Case Studies

case studiesView


Purchase

USA and Canada
sales@hitsw.com
+1-408-345-4001
 
Asia
Australia
Europe
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 Netezza

DBMoto DBMoto is the preferred solution for heterogeneous
Data Replication, Change Data Capture and Data
Transformation requirements in an enterprise environment. DBMoto version 7 now supports IBM Netezza 100 and IBM PureData System (Netezza 1001, Netezza 2001 and older Netezza TwinFin) data warehouse and analytic appliances, through built-in integration capabilities that provide seamless data loading and data mirroring to IBM® Netezza targets. Whether you need to deploy a new IBM Netezza system, or upgrade from an incumbent system, DBMoto can help make data migration an easy and understandable task.

DBMoto is the solution of choice for fast, trouble-free, easy-to-maintain data integration projects. If you depend on data from multiple databases, you need a data integration solution that supports major relational database 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 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 for maximum efficiency.

DBMoto 
            Data Replication
Full Support
during Trial Period

Real-Time Data Replication and Change Data Capture

DBMoto is specifically designed to replicate data from relational databases to IBM Netezza in the following ways:

  • Refresh mode: DBMoto reads the data set, applies administrator-defined mapping rules, and writes the entire result to IBM Netezza.
  • Mirroring mode: One-way replication from source to IBM Netezza, using Change Data Capture (CDC) and transaction log management.
DBMoto's Management Center GUI console includes features to easily:
  • Identify and connect to multiple source databases, with IBM Netezza as a target
  • 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
  • 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, 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 : DB2, iSeries and AS400 database replication and synchronization Enterprise Manager

Click here for detailed diagram
 

Unmatched Replication and Transformation Control IBM Netezza 100 and IBM PureData System (Netezza 1001, Netezza 2001 and older Netezza TwinFin)

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.

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

Click here for detailed diagram
 

Key Features

Database Support

  • Support for all major databases as sources: 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 100 and IBM PureData System (Netezza 1001, Netezza 2001 and older Netezza TwinFin) data warehouse and analytic appliances as target
  • Support for database cluster environments

Replication Support

  • Replication modes: Refresh (snapshot), Mirroring (change data capture)
  • 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 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 Sources for Mirroring Mode
 
IBM DB2 for i and AS400 V3R3 and later
IBM DB2 for z/OS (OS/390) v5 and later
IBM DB2 for Windows v5 and later
IBM Informix
IBM DB2 for AIX, Linux, HP/UX, Solaris v5 and later
Oracle v8 and later
Microsoft SQL Server v6.5 and later
Gupta Technologies SQLBase
MySQL v5.1.31 and later (Previous versions are trigger-based)
Sybase ASE v12.50 and later
Sybase SQL Anywhere
 

Databases Supported as Sources for Refresh Mode
 
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
Oracle v8 and later
Microsoft SQL Server v6.5 and later
MySQL v3.23 and later
IBM Netezza 100 and IBM PureData System (Netezza 1001, Netezza 2001 and older Netezza TwinFin)
Sybase ASE v12.50 and later
SQL Anywhere
Ingres 2006
PostgreSQL
Gupta Technologies SQLBase Server v8.5.0 and later
MS Access 97 and later
Firebird
 

System Requirements:
 
Windows Server 2008/2003/2000/NT
Microsoft .NET framework 2.0, SP 2, or Microsoft .NET framework 3.5, SP1
 

DBMoto Data Replication
Full Support
during Trial Period


Technology Partner Alliances

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

DBMoto v8 DBMoto for HP Vertica DBMoto for IBM i DBMoto for DSP DBMoto for Informix DBMoto Cloud Edition DBMoto for Vectorwise DBMoto for MySQL DBMoto Cloud G Edition DBMoto for Oracle DBMoto for SQL Server DBMoto for IBM PureData System for Analytics (Netezza)