Buy Download Contact Us

Linked InTwitterFacebookBlogFeedYouTube

Chinese Website
Japanese Website



DBMoto for IBM PureData (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 is the preferred solution for heterogeneous Data Replication, Change Data Capture and Data Transformation requirements in an enterprise environment. DBMoto now supports IBM® PureData System (Netezza) data warehouse and analytic appliances, through built-in integration capabilities that provide seamless data loading and data mirroring to and from IBM PureData System environments. Whether you need to deploy a new IBM PureData system, or upgrade from an incumbent system, DBMoto can help make change data capture and 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 to and from IBM PureData Systems in the following ways:

  • Refresh mode target: DBMoto reads the data set, applies administrator-defined mapping rules, and writes the entire result to an IBM PureData System.
  • Mirroring mode target: One-way replication from source to an IBM PureData System, using Change Data Capture (CDC) and transaction log management.
  • Refresh mode source: DBMoto reads the data set from an IBM PureData System, applies administrator-defined mapping rules, and writes the entire result to any major database system.
  • Mirroring mode source: One-way replication from an IBM PureData System to any major database system, using Change Data Capture (CDC) to identify changed data and transaction log management.
DBMoto's Management Center GUI console includes features to easily:
  • Identify and connect to multiple source and target databases, including IBM PureData System
  • 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

Unmatched Replication and Transformation Control
 
IBM PureData System, IBM Netezza 100, Netezza 3001, Netezza 2001, Netezza 1001 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

Key Features

Database Support

  • Support for all major databases as sources and targets: IBM PureData System, IBM Netezza 100 (Netezza 3001, Netezza 2001, Netezza 1001 and older Netezza TwinFin) data warehouse and analytic appliances 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 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 C# and VB.NET scripting in an 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
IBM Pure Data System ( Netezza technology)
Oracle v8 and later
Microsoft Azure SQL Database
Microsoft SQL Server v6.5 and later
Gupta Technologies SQLBase
MySQL v5.1.31 and later (Previous versions are trigger-based)
SAP Sybase ASE v12.50 and later
SAP 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 Azure SQL Database
Microsoft SQL Server v6.5 and later
MySQL v3.23 and later
IBM Pure Data System (Netezza technology)
SAP Sybase ASE v12.50 and later
SAP SQL Anywhere
Ingres 2006
PostgreSQL
Gupta Technologies SQLBase Server v8.5.0 and later
MS Access 97 and later

 
Databases Supported as Targets (Refresh and Mirroring Modes)
 
HP Vertica
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 Pure Data System ( Netezza technology)
MySQL v3.23 and later
Microsoft Azure SQL Database
Microsoft SQL Server v6.5 and later
SAP Hana
SAP IQ
SAP Sybase ASE v12.50 and later
SAP SQL Anywhere
Ingres 2006
Gupta Technologies SQLBase Server v8.5.0 and later
PostgreSQL
Actian Vectorwise

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


 

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 DB2 LUW DBMoto for SAP HANA