HiT Hooks HANA to Other Databases with DBMoto

November 18, 2014 Alex Woodie

You can do a lot with SAP HANA sitting all by itself, including running transactional and analytical applications on the same set of data, which is a pretty neat trick. But in the real world, most SAP HANA customers need a way to move data in and out of HANA as quickly as possible. That’s where the latest release of HiT Software‘s DBMoto software comes in.

Last week HiT Software, which is a subsidiary of BackOffice Associates, announced that the latest release of its DBMoto ETL tool has been certified to integrate with SAP HANA. That means HANA customers will be able to replicate, mirror, and perform change data capture (CDC) from other databases into HANA, or move the data from HANA into other databases.

DBMoto supports all the major relational databases, including DB2 for i, DB2 for LUW, SQL Server, MySQL, Oracle, Informix, SAP’s own Sybase, and others. It also sports certified connections to a variety of analytical databases, such as IBM Netezza, Actian Vectorwise, and EMC Greenplum. It also supports cloud-based databases, such as Google App Engine (GAE), a NoSQL-based datastore. With the new HANA certification for DBMoto version 8.2, HiT is now supporting the last of the major and mainstream analytical databases.

HiT customers can sync data in several ways using DBMoto. In refresh (or snapshot) mode, DBMoto reads data, applies transformations, and writes the result on the target database. In mirroring mode, DBMoto uses CDC technology to perform real-time incremental replications from the source database to the target database. In synchronization mode, DBMoto performs bi-directional mirroring between source and target systems. DBMoto also offers multi-server synchronization for moving data among three or more systems.

There are a few more analytical systems that DBMoto still does not yet work with. We have word that the company is working to support the relational database at the heart of Teradata‘s analytics offering. And the company is also looking closely at Hadoop, the big data framework that’s gaining steam for its capability to store hundreds of petabytes of data across a cluster of distributed X86 servers. In 2013, Giacomo Lorenzin, managing director of HiT Software, told IT Jungle that it was monitoring Hadoop.