Introduction

HVR is a powerful software product that enables real-time homogeneous and heterogeneous data replication. HVR uses various CDC (Change Data Capture) methods to replicate changes between databases, directories (file locations), as well as between databases and directories, that HVR calls 'locations'. Locations can either be a source or a target. Each change in a source location is captured by HVR, transmitted and then applied to a target location. Database CDC technology is also referred to as a 'log mining process' that reads a database transaction log for relevant transactions. HVR uses its own internal log mining technology along with certain database vendor APIs. The CDC method that HVR uses during a replication depends on various settings defined/configured within HVR.

HVR has a built-in compare feature that allows real-time verification to ensure that the source and target locations are in sync. In addition, HVR has a replication monitoring feature allowing users to actively monitor the status of replication, including viewing real-time data flow statistics. All actions can be securely monitored using the event audit feature to ensure that all actions taken are logged.

Advantages

  • Log based CDC has minimal impact on a source databases
  • Low latency gathering of changes made on a source database
  • Changes keep transactional integrity
  • Changing source applications is not required
  • Flexibility allows for trade-offs in remote versus local capture, as well as capture once, deliver to multiple, scenarios
  • Resiliency against failures allows for recovery without data loss
  • Setup is available both via graphical user interface and CLI

Capabilities

  • Feed a reporting database
  • Populate a data warehouse or data lake
  • Feed Kafka or other streaming platforms
  • Migrate from on-premises to cloud e.g. move from on-premises Oracle to AWS Oracle RDS with little or no downtime
  • Move data from one cloud vendor to another cloud vendor supporting intra-cloud, inter-cloud and hybrid cloud deployments
  • Consolidate multiple databases
  • Keep multiple geographically distributed databases in sync
  • Migrate from one hardware platform to another, e.g. move from an AIX platform to a Linux platform with little or no downtime
  • Migrate from an older database version to the latest supported version
  • Migrate from one database technology to another, e.g. from Oracle to PostgreSQL