HVR 5.6 — Cloud Connectivity Release

HVR customers are already consolidating and integrating data from dozens of organization-wide sources. Now, you can get a quick and meaningful visual of multiple sources to target data flows while getting an overview of key performance metrics such as latency and data volumes.

This new feature, referred to as topology, uses intuitive visual elements to provide multiple key attributes of every data flow in a single overview, including:

• Direction of the data flow or channel
• Relative number of tables being replicated per node
• Indication of latency, split between Change Data Capture (CDC) and integration
• Indication of whether latency thresholds are exceeded, again split by capture and integration

Topology provides you with live call-out reports giving you deeper insights on your data movement, as well as drilling down into the historical metrics per data flow/channel.

Accuracy builds trust in the data used for analytics and reporting. The built-in HVR feature, Compare, allows you to verify data is in sync and alerts you if there is a problem. The latest version of HVR takes Compare to the next level of measuring data accuracy with live compare and broader functionality:

1. Live Compare: Merge the changes in the HVR transaction files with any detected differences based on selecting the data from either side of the data flow. You can then give an exact answer on whether two systems are in sync, irrespective of in-flight changes.

2. Live Compare using a two-pass approach: Used to validate if databases are in sync or not, regardless if they are being replicated with HVR or any other replication tool.

3. File Compare: Perform a direct reading of the files instead of relying on Hive external tables to retrieve the data. This new approach no longer requires implicit data rounding and truncation as part of coercion and is more scalable than the existing approach using Hive. This also saves the cost of running Hive in the cloud.

All user interactions with HVR are now tracked to provide an easy-to-use, browser-based, graphical report as part of HVR Insights.

This feature facilitates configuration management to keep track of changes made to the setup. Complex environments need this tracking to match change requests with configuration changes, which is a must-have requirement for certain use cases (e.g. compliance for financial reporting).

Every new HVR release introduces countless small improvements. Please check the release notes for full details.

Source

• Aurora PostgreSQL: HVR now supports Log-based CDC from this platform as a source
• DB2 on z/OS: DB2 running on the mainframe (z/OS) is now supported as a source for Log-based CDC
• Also included is updated support for the latest GA versions of database technologies including Oracle, MySQL, and MariaD

Target

• Snowflake on Azure
• Azure BLOB storage is now supported for all supported file types including Parquet, JSON,
• Avro, CSV and others, with lots of options to fine tune the formatting
• Azure HDInsight support for Hive tables
• Oracle’s cloud-based Autonomous Data Warehouse (ADW)
• Also supported: Hive 3.0, Map-R, and Cloudera and Hortonworks distributions of Hadoop