• The Four Hundred
  • Subscribe
  • Media Kit
  • Contributors
  • About Us
  • Contact
Menu
  • The Four Hundred
  • Subscribe
  • Media Kit
  • Contributors
  • About Us
  • Contact
  • HiT Bolsters Data Synchronization Tool

    March 23, 2010 Alex Woodie

    HiT Software next quarter will begin delivery of DBMoto version 7, a new release of its database synchronization tool that supports DB2/400, Oracle, SQL Server, and other major RDBMSs. With version 7, HiT added a number of new management and auditing capabilities that should make it easier to replicate data among multiple databases, while support for DB2/400’s minimized journal data capability should boost data replication performance in System i environments.

    DBMoto is a Windows-based data replication tool that enables organizations to share data among more than 20 different relational database management systems (RDBMS), including IBM‘s DB2/400, DB2 for LUW, Informix, Cloudscape, and SolidDB; Microsoft‘s SQL Server and Access; Oracle‘s MySQL and Oracle 11i; Sybase‘s ASE and SQL Anywhere; CA‘s Ingres; PostgreSQL Global Development Group‘s PostgreSQL; Gupta‘s SQLBase; and FirebirdSQL.

    HiT designed DBMoto’s wizard-based setup to mostly eliminate the need for programming (users can customize replications and do some basic transformations using scripts), while multiple replication modes—refresh, full mirroring, and synchronization–enable users to tailor the replication workload for different data integration tasks and performance requirements.

    Some of the enhancements delivered with version 7, such as support for Oracle‘s Real Application Clusters (RAC) and Microsoft Windows Server clustering environments, are tailored to larger shops with more sophisticated IT investments. Similarly, this release gains the capability to synchronize data among multiple databases. Previously, the data synchronization mode could only operate between two databases.

    DBMoto 7 also brings enhancements to the GUI management console, called the DBMoto Management Center. With this release, users also gain the capability to administer the DBMoto server from any location or even multiple locations, which should make it easier to manage data integration in far-flung enterprises. The console is also more customizable with this release, the company says.

    Version 7 provides something unique to System i shops, which make up a good percentage of HiT’s DBMoto installed base. Specifically, the product now supports replicating data in minimized journal entries.

    Minimized journaled data is a feature that IBM introduced with OS/400 V5R1 to enhance performance of database replication in DB2/400. The minimize data (MINENTDTA) command instructs DB2/400 to only replicate the records within a file that have changed. Since regular journaling replicates all records in a file, whether they changed or not, the capability to replicate only records that have changed can reduce the amount of data that is replicated, thereby boosting replication performance (at the cost of rendering replicated files unreadable by humans).

    DBMoto users on all platforms will appreciate some of the new data management and security capabilities in version 7. Administrators gain new options for managing and filtering access to database tables on source and target systems. New metadata management options should make it easier to use DBMoto for disaster recovery (DR) preparedness, while users gain the option of using the product’s native security options or Windows security tools for managing access to product operations.

    Version 7 introduces two new data auditing capabilities. Administrators should be able to get a better handle on the details and design of their data replication jobs thanks to the new DBMoto Verifier feature, which compares data before and after replication. HiT also added the capability to convert changed data into a log table and then into another file format, which should provide auditors with more visibility into DBMoto activities.

    DBMoto version 7 also gains support for performing change data capture (CDC) synchronization using log data from DB2 for Linux, Unix, and Windows (DB2 LUW, formerly called UDB DB2). Support for XML and Large Object Binary (LOB) data types were also added.

    Version 7 also marks the beginning of support for Netezza‘s data warehousing and analytic appliances. HiT and Netezza worked to validate DBMoto’s capability to efficiently perform initial bulk data loads and ongoing CDC updates into the Netezza TwinFin appliance from Oracle, DB2, or SQL Server sources. Netezza’s director of technology alliances, Matthew Rollender, said he was “impressed by the technology and the expertise of HiT’s team.”

    Meanwhile, HiT CEO Giacomo Lorenzin says DBMoto version 7 should play well with large organizations that demand advanced data replication capabilities, such as support for automated conflict resolution. “DBMoto 7 is a significant step forward in data integration for large organizations where heterogeneous databases share operational workloads,” Lorenzin says in a press release.

    RELATED STORIES

    HiT Bolsters Performance of DBMoto Replicator

    HiT’s DBMoto Gains Enterprise Replication Features

    Bruce Lee Directs HiT for Asia

    NetManage and HiT Software Partner for Structured Data

    HiT Software Updates Data Integration Tool

    HiT Bolsters DB2/400-to-SQL Server Replication Tool



                         Post this story to del.icio.us
                   Post this story to Digg
        Post this story to Slashdot

    Share this:

    • Reddit
    • Facebook
    • LinkedIn
    • Twitter
    • Email

    Tags:

    Sponsored by
    WorksRight Software

    Do you need area code information?
    Do you need ZIP Code information?
    Do you need ZIP+4 information?
    Do you need city name information?
    Do you need county information?
    Do you need a nearest dealer locator system?

    We can HELP! We have affordable AS/400 software and data to do all of the above. Whether you need a simple city name retrieval system or a sophisticated CASS postal coding system, we have it for you!

    The ZIP/CITY system is based on 5-digit ZIP Codes. You can retrieve city names, state names, county names, area codes, time zones, latitude, longitude, and more just by knowing the ZIP Code. We supply information on all the latest area code changes. A nearest dealer locator function is also included. ZIP/CITY includes software, data, monthly updates, and unlimited support. The cost is $495 per year.

    PER/ZIP4 is a sophisticated CASS certified postal coding system for assigning ZIP Codes, ZIP+4, carrier route, and delivery point codes. PER/ZIP4 also provides county names and FIPS codes. PER/ZIP4 can be used interactively, in batch, and with callable programs. PER/ZIP4 includes software, data, monthly updates, and unlimited support. The cost is $3,900 for the first year, and $1,950 for renewal.

    Just call us and we’ll arrange for 30 days FREE use of either ZIP/CITY or PER/ZIP4.

    WorksRight Software, Inc.
    Phone: 601-856-8337
    Fax: 601-856-9432
    Email: software@worksright.com
    Website: www.worksright.com

    Share this:

    • Reddit
    • Facebook
    • LinkedIn
    • Twitter
    • Email

    Sponsored Links

    Help/Systems:  Robot/CONSOLE monitors System i resources automatically
    Northeast User Groups Conference:  20th Annual Conference, April 12 - 14, Framingham, MA
    COMMON:  Join us at the annual 2010 conference, May 3 - 6, in Orlando, Florida

    IT Jungle Store Top Book Picks

    Easy Steps to Internet Programming for AS/400, iSeries, and System i: List Price, $49.95
    The iSeries Express Web Implementer's Guide: List Price, $49.95
    The System i RPG & RPG IV Tutorial and Lab Exercises: List Price, $59.95
    The System i Pocket RPG & RPG IV Guide: List Price, $69.95
    The iSeries Pocket Database Guide: List Price, $59.00
    The iSeries Pocket SQL Guide: List Price, $59.00
    The iSeries Pocket Query Guide: List Price, $49.00
    The iSeries Pocket WebFacing Primer: List Price, $39.00
    Migrating to WebSphere Express for iSeries: List Price, $49.00
    Getting Started With WebSphere Development Studio Client for iSeries: List Price, $89.00
    Getting Started with WebSphere Express for iSeries: List Price, $49.00
    Can the AS/400 Survive IBM?: List Price, $49.00
    Chip Wars: List Price, $29.95

    Companies Say Software Support Is Satisfactory Using UNION for Data Analysis

    Leave a Reply Cancel reply

Volume 10, Number 12 -- March 23, 2010
THIS ISSUE SPONSORED BY:

Databorough
Bytware StandGuard Security
RevSoft
Patrick Townsend Security Solutions
WorksRight Software

Table of Contents

  • CoralTree Toolkit Streamlines CGIDEV2 Web App Development
  • Info Builders Updates Dashboarding Solution
  • Unitrends Adds Cloud-Based Storage to Backup Offering
  • HiT Bolsters Data Synchronization Tool
  • LTO Tape Drives: More than 3 Million Served
  • Fly Doc, Fly: Esker Updates Online Mail and Fax Service
  • Insurance Company Chooses Attunity for DB2/400-to-SQL Server Replication
  • IBM and Assurant Unveil ‘RAMP’ for Intelligent CSR Call-Routing
  • Vision Touts High Availability Install at Food Distributor
  • Construction App from CGC Gets a Web Portal

Content archive

  • The Four Hundred
  • Four Hundred Stuff
  • Four Hundred Guru

Recent Posts

  • The IBM i Power10 Upgrade Cycle Forecast Looks Favorable
  • White Hats Completely Dismantle Menu-Based Security
  • Cloud Software To Drive Enterprise Application Growth
  • How Do You Stay In Touch With The IBM i Community?
  • IBM i PTF Guide, Volume 25, Number 6
  • Security Still Top Concern, IBM i Marketplace Study Says
  • Bob Langieri Shares IBM i Career Trends Outlook for 2023
  • Kisco Brings Native SMS Messaging to IBM i
  • Four Hundred Monitor, February 1
  • 2023 IBM i Predictions, Part 4

Subscribe

To get news from IT Jungle sent to your inbox every week, subscribe to our newsletter.

Pages

  • About Us
  • Contact
  • Contributors
  • Four Hundred Monitor
  • IBM i PTF Guide
  • Media Kit
  • Subscribe

Search

Copyright © 2022 IT Jungle

loading Cancel
Post was not sent - check your email addresses!
Email check failed, please try again
Sorry, your blog cannot share posts by email.