Buy Download Contact Us

Linked InTwitterFacebookBlogFeedYouTube

Chinese Website
Japanese Website



DBMoto for SAP HANA
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 SAP HANA
Data Replication and Change Data Capture for High-Performance Analytics Database Platforms

The SAP HANA high-performance analytical database platform provides a cost-effective and powerful solution for Big Data analytics. DBMoto is now optimized to work with HANA, giving HANA users a fast-track to loading, updating and automatically keeping data current in HP the HANA platform. Having the freshest data is key to the best decisioning. Rely on the best Data Replication and Change Data Capture product to update and maintain your important data!

Benefits
  • Load data to SAP® HANA from any major relational database source
  • Automatically update HANA data from changes made on the source database
  • Faster data updates mean faster analytics and up-to-date reporting
  • Empower critical analysis, business intelligence and decision-making with the freshest data
  • Apply analytics faster to Big Data and SAP applications

DBMoto version 8 supports the HANA analytical database platform through built-in capabilities that provide seamless data loading and data mirroring to HANA. Whether you need to deploy a new HANA system, or migrate from a separate database, DBMoto can help make data replication a quick and easy task.

DBMoto is the solution of choice for fast, trouble-free, easy-to-maintain data integration and data replication projects. If you depend on data from multiple databases, you need a data replication 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.


DBMoto 
                Data Replication
Full Support
during Trial Period


Real-Time Data Replication and Change Data Capture

DBMoto supports the HANA platform through built-in integration capabilities that provide bulk insert data loading and data mirroring to HANA targets through:

  • Refresh mode: DBMoto reads the data set, applies administrator-defined mapping rules, and writes the entire result to HANA.
  • Mirroring mode: One-way replication from source to HANA, using Change Data Capture (CDC) and transaction log management on the source.
DBMoto's Management Center GUI console includes features to easily:
  • Identify and connect to multiple source databases, with HANA 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
  • 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 for SAP HANA: Management Center

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 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 for SAP HANA: Replication Wizard

Click here for detailed diagram
 

Key Features

Database Support

  • Support for all major databases as sources
  • Support for SAP HANA analytic platform as target
  • Source table access via standard .NET data provider protocol

Replication Support

  • Replication modes: Refresh (snapshot), Mirroring (change data capture)
  • Perform bulk insert of data into HANA
  • 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
  • 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
  • Customizable via Microsoft VB.NET scripting and event driven environment
  • No programming needed on source or target database platforms

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 DB2 for AIX, Linux, HP/UX, Solaris v5 and later
IBM Informix
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
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
PostgreSQL
Gupta Technologies SQLBase Server v8.5.0 and later
MS Access 97 and later
 

Requirements For Systems Running DBMoto:
 
Windows Server 2012/2008/2003
Microsoft .NET framework 4.0 or higher
SAP HANA ODBC driver must be installed on system where DBMoto is installed

DBMoto Data Replication
Full Support
during Trial Period


IBM Advanced Business Partner
 
MSFT Silver ISV
 
Oracle Gold Partner
 

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

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