Documentation

Documentation

  • HVR 5 Documentation
  • Introduction
    • Architecture Overview
    • Replication Overview
    • Replication Topologies
    • HVR 5 Release Life Cycle
    • Platform Compatibility Matrix
      • Platform Compatibility Matrix - HVR 5.7.5
      • Platform Compatibility Matrix - HVR 5.7.0
      • Platform Compatibility Matrix - HVR 5.6.5
      • Platform Compatibility Matrix - HVR 5.6.0
      • Platform Compatibility Matrix - HVR 5.5.5
      • Platform Compatibility Matrix - HVR 5.5.0
      • Platform Compatibility Matrix - HVR 5.3.1
      • Platform Compatibility Matrix - HVR 5.3.0
      • Platform Compatibility Matrix - HVR 5.2.3
      • Platform Compatibility Matrix - HVR 5.2.1
    • Document Conventions
  • Installing and Upgrading HVR
    • Downloading HVR
    • HVR Licensing
    • System Requirements
      • HVR Installation Location
      • Disk Requirements
      • Network Requirements
      • Server Requirements
      • Supported Operating Systems
    • Installing HVR on AWS
      • Requirements for AWS
      • Scaling and Monitoring HVR Hub and Agent Resources on AWS
      • Installing HVR on AWS using HVR Image
      • Installing HVR on AWS Manually
    • Installing HVR on Azure
      • Requirements for Azure
      • Installing HVR on Azure using HVR Image
      • Installing HVR on Azure Manually
    • Installing HVR on macOS
    • Installing HVR on Unix or Linux
    • Installing HVR on Windows
    • Installing HVR in a Cluster
    • Upgrading HVR
    • Downgrading HVR
    • Migrating HVR Hub to New Server
  • Configuring HVR
    • Auto-Starting HVR Scheduler after Unix or Linux Boot
    • Auto-Starting HVR after Windows Boot
    • Configuring Remote Installation of HVR on Unix or Linux
    • Configuring Remote Installation of HVR on Windows
    • Authentication and Access Control
    • Encrypted Network Connection
      • Configuring Encrypted Network Connection
    • Hub Wallet and Encryption
      • Configuring and Managing Hub Wallet
    • Network Protocols, Port Numbers and Firewalls
    • Regular Maintenance and Monitoring for HVR
    • HVR High Availability
  • Location Class Requirements
    • Requirements for Azure Blob FS
    • Requirements for Azure Data Lake Storage Gen2
    • Requirements for Azure Data Lake Store
    • Requirements for Azure SQL Database
    • Requirements for Azure Synapse Analytics
    • Requirements for BigQuery
    • Requirements for DB2 for i
    • Requirements for DB2 for Linux, UNIX and Windows
    • Requirements for DB2 for z/OS
      • Installing HVR Capture Stored Procedures on DB2 for z/OS
    • Requirements for FTP, SFTP, and SharePoint WebDAV
    • Requirements for Google Cloud Storage
    • Requirements for Greenplum
    • Requirements for HANA
    • Requirements for HDFS
      • HDFS Authentication and Kerberos
      • Requirements for MapR
    • Requirements for Hive ACID
    • Requirements for Ingres and Vector
    • Requirements for Kafka
    • Requirements for MySQL and MariaDB
    • Requirements for Oracle
    • Requirements for PostgreSQL
    • Requirements for Redshift
    • Requirements for S3
    • Requirements for Salesforce
    • Requirements for SapXForm
      • Configuring SapXForm with HVR 4
    • Requirements for SingleStore
    • Requirements for Snowflake
    • Requirements for SQL Server
      • Managing SQL Server Log File Truncation
    • Requirements for Sybase ASE
    • Requirements for Teradata
  • Actions
    • AdaptDDL
    • AgentPlugin
      • Agent Plugin for BigQuery
      • Agent Plugin for Cassandra
      • Agent Plugin for Manifest Files
      • Agent Plugin for MongoDB
    • Capture
    • CollisionDetect
    • ColumnProperties
    • DbObjectGeneration
    • DbSequence
    • Environment
    • FileFormat
    • Integrate
    • LocationProperties
    • Restrict
    • Scheduling
    • TableProperties
    • Transform
  • Commands
    • Calling HVR on the Command Line
    • Command Reference
    • Hvr
    • Hvradapt
    • Hvrcatalogcreate, Hvrcatalogdrop
    • Hvrcatalogexport, hvrcatalogimport
    • Hvrcatalogupgrade
    • Hvrcheckpointretention
    • Hvrchecksuppllog
    • Hvrcompare
    • Hvrcontrol
    • Hvrcrypt
    • Hvreventtool
    • Hvreventview
    • Hvrfailover
    • Hvrfingerprint
    • Hvrgui
    • Hvrinit
    • Hvrlivewallet
    • Hvrlogrelease
    • Hvrmaint
    • Hvrproxy
    • Hvrrefresh
    • Hvrremotelistener
    • Hvrretryfailed
    • Hvrrouterconsolidate
    • Hvrrouterview
    • Hvrscheduler
    • Hvrsslgen
    • Hvrstart
    • Hvrstatistics
    • Hvrstats
    • Hvrstrip
    • Hvrsuspend
    • Hvrswitchtable
    • Hvrtestlistener, hvrtestlocation, hvrtestscheduler
    • Hvrusagesnapshot
    • Hvrvalidpw
    • Hvrwalletconfig
    • Hvrwalletopen
  • HVR Insights
    • Topology
    • Statistics
    • Events
  • Advanced Operations
    • Analyzing Diff File
    • Configuring Multi-Directional Replication
    • Data Type Mapping
      • Data Type Mapping for Aurora MySQL
      • Data Type Mapping for Aurora PostgreSQL
      • Data Type Mapping for Avro, Json, and Parquet
      • Data Type Mapping for Azure SQL Database
      • Data Type Mapping for Azure Synapse Analytics
      • Data Type Mapping for BigQuery
      • Data Type Mapping for Db2 for i
      • Data Type Mapping for Db2 for Linux, Unix, and Windows
      • Data Type Mapping for Db2 for z/OS
      • Data Type Mapping for Greenplum
      • Data Type Mapping for Hive ACID
      • Data Type Mapping for Hive External Table with Avro, CSV, Json, Parquet
      • Data Type Mapping for Ingres
      • Data Type Mapping for Kafka
      • Data Type Mapping for MariaDB
      • Data Type Mapping for MySQL
      • Data Type Mapping for Oracle
      • Data Type Mapping for PostgreSQL
      • Data Type Mapping for Redshift
      • Data Type Mapping for SAP HANA
      • Data Type Mapping for SingleStore
      • Data Type Mapping for Snowflake
      • Data Type Mapping for SQL Server
      • Data Type Mapping for Sybase ASE
      • Data Type Mapping for Teradata
      • Data Type Mapping for Vector
    • Extended Data Type Support
    • Managing Recapturing Using Session Names
    • Manually Adapting a Channel for DDL Statements
    • Replication Transformations Between Non-Identical Tables
    • Replication with File Locations
      • Replicating CSV file to Database Table
      • Replicating XML file to Database Table
    • Using Contexts Variables for Comparing Data Based on Datetime Column
  • Internal HVR Objects
    • Catalog Tables
    • Extra Columns for Capture, Fail and History Tables
    • Integrate Receive Timestamp Table
    • Metrics for Statistics
    • Naming of HVR Objects Inside Database Locations
  • Capabilities
    • Capabilities for Aurora MySQL
    • Capabilities for Aurora PostgreSQL
    • Capabilities for Azure SQL Database
    • Capabilities for Azure SQL Managed Instance
    • Capabilities for Azure Synapse Analytics
    • Capabilities for BigQuery
    • Capabilities for DB2 for i
    • Capabilities for DB2 for Linux, UNIX and Windows
    • Capabilities for DB2 for z/OS
    • Capabilities for Greenplum
    • Capabilities for HANA
    • Capabilities for Hive ACID
    • Capabilities for Ingres
    • Capabilities for Kafka
    • Capabilities for MariaDB
    • Capabilities for MySQL
    • Capabilities for Oracle
    • Capabilities for PostgreSQL
    • Capabilities for Redshift
    • Capabilities for Salesforce
    • Capabilities for SingleStore
    • Capabilities for Snowflake
    • Capabilities for SQL Server
    • Capabilities for Teradata
    • Capabilities for Vector
  • Quick Start Guides
    • Quick Start for HVR - Azure Data Lake Storage Gen2
    • Quick Start for HVR - Azure SQL Database
    • Quick Start for HVR - DB2 for LUW
    • Quick Start for HVR - DB2 for z/OS
    • Quick Start for HVR - File Replication
    • Quick Start for HVR - Greenplum
    • Quick Start for HVR - HANA
    • Quick Start for HVR - HDFS
    • Quick Start for HVR - Ingres
    • Quick Start for HVR - Kafka
    • Quick Start for HVR - Oracle
    • Quick Start for HVR - PostgreSQL
    • Quick Start for HVR - Redshift
    • Quick Start for HVR - Salesforce
    • Quick Start for HVR - SapXForm
    • Quick Start for HVR - Snowflake
    • Quick Start for HVR - SQL Server
    • Quick Start for HVR - Teradata
  • FAQ
    • How To
      • How to Archive HVR Log Output Files from HVR_CONFIG Directory
      • How To Build HVR Statistics Channel for Reporting
      • How to Calculate Values for HVR_SCAN_SEQ_BITS_MSSQL Environment Variable
      • How to Change Database User Password for HVR Hub Repository
      • How to Configure HVR for High Availability in Oracle Cluster
      • How to Configure Remote Location with SSL Encryption
      • How to Connect HVR to Oracle Database
      • How to Convert Datatypes or Substitute Column Values With Expressions
      • How to Replicate a Single Table to Two Tables on the Target
      • How to Make hvrstats Job Visible in HVR GUI
      • How to Map Different Source Table and Column Names to Target
      • How to Move Data From Tables to Flat Files
      • How to Override Default Target Schema in Replication
      • How To Ignore Mass Deletes Based on Username
      • How to Install SQL Server ODBC Driver on Linux
      • How to Integrate Only Rows Having Specific Column Value
      • How to Add Column to The Target Database
      • How to Add Multiple Instances of Table to Channel
      • How to Determine Which Journal Receiver is Currently Being Processed
      • How to Skip and Recover Record that Causes Capture to Fail
      • How to Start HVR Using Systemd
      • How to Start HVR Using Inted
      • How to Test Connection to Oracle RAC
      • How to Set Default Schema for PostgreSQL, Greenplum, Snowflake, and Redshift
      • How to Use HVR and Oracle Data Guard for Source Database Failover
      • How to Use HVR Refresh in Online Mode to Recover
      • How to Use Online Refresh for Initial Load or Full Re-initialization
      • How to Use Online Refresh to Correct Data Mismatches
      • How to Specify Encoding for Binary Field
      • How to Run HVR Refresh with Slice Options
      • How to Run Routerview Command for Single Job
      • How to Set Up Capture from Multiple Sources
      • How to Promote Pre-Production Environment to Production
      • How to Recover from Permission Denied Error
      • How to Remove Repository from HVR Hub
      • How to Retrieve REDO File Name with Specific Sequence
      • How to Create Maintenance Task to Remove Journal Files
      • How to Create New Column Using /CaptureExpression
      • How to Create and Run Refresh Job Using HVR Scheduler
      • How to Create Table in Oracle Target Database for HVR Statistics
      • How to Delete Table from Existing Channel
      • How to Monitor Replication Latency
      • How to Configure HVR in a Windows Cluster
      • How to Use RenameExpression to Name New Files
      • How to Configure Multidirectional Replication with Oracle
      • How To Avoid Truncation of Table Data
      • How to Fix Date Value Replication Issues
      • How to Use HVR_THROW_WARN to Convert Errors Into Warnings
      • How to Ignore a Redo Thread in CLOSED Status Using The HVR Capture Process
      • How to Identify Data Loss and Inconsistencies
      • How to Handle HVR Capture During a Database Upgrade
      • How to Create Multiple Integrate Jobs in the Same Channel for Parallelism
      • How to Capture From an Oracle Materialized View
      • How to Use Expression Scope to Track Changes
      • How to Use Scheduling Parameters for Compare
      • How to Enable Journaling for Router Files
      • How to Identify HANA Backup Log File
      • How to Identify SQL Server TLog Backup Log File
      • How to Determine the HVR Hub Fingerprint
      • How to Exclude a Column From Being Replicated
      • How to Use Scheduling Parameters for Integrate Locations
      • How to Use Scheduling Parameters for Refresh
      • How to Use MaxFileSize Parameter to Split Incoming File
      • How to Monitor HVR Jobs Using SNMP
      • How to Avoid Grants to Public for a Table
      • How to Define Target Column With Timestamp
      • How To Troubleshoot Network Issues
      • How To Use Online Refresh to Step Over a Capture Issue
      • How To Mask String in Column Value in PostgreSQL Target
      • How to Understand Missing Tables in Table Explorer
      • How To Schedule Email Alerts
      • How to Use AddressTo and AddressFrom Features
      • How to Extract Table Based on Join Condition
      • How to Replicate XML Files From Oracle to AWS S3
      • How to Add Table to Existing HVR Channel
      • How to Add Prefix to Replicated Table Name(s) in Target
      • How To Add Parallelism by Defining Multiple Integration Jobs
      • Greenplum Define Location
      • How to Filter Deletes in MySQL
    • Expert Notes, Best Practices
      • HVR GUI Tips and Tricks
      • What are Orphans
      • When Capture or Integrate is Stopped
      • Default Unit for HVR_SORT_BYTE_LIMIT
      • What is HVR Hub
      • Command to Kill Hvrscheduler in Linux
      • Where is HVR Log File Archive Directory
      • Why Publication Require Snapshot Agent to Run Every Hour
      • Why Refresh or Compare Job File Gets Deleted
      • Can HVR Agent Plugin Use Environment Variable
      • Can HVR SQL Statements Be Traced
      • Capture Job Gets Suspended by Online Refresh
      • Grants and Privileges After Refresh
      • SQL Server Requirements for AG
      • Database User Password Change
      • Primary, Replication, and Distribution Keys for HVR 5
      • Scripts for Oracle Log-Based Capture
      • Temporary Files
      • Cache Files
      • Resilient Option With Continuous Integration
      • Integration Error Causes
      • Online Refresh
      • Use Soft Delete Function
      • Process Stop Alert
      • Too Much CPU Time
      • Different Column Values
      • Row-Wise and Bulk Checksum Mismatch
      • Delete Manually Created Control File
      • Troubleshoot Missing Data
      • Integration Error
      • Log-Based Capture Requirement
      • Specify Schema Name in Hvradapt
      • Manage HVR Remote Listener Processes
      • Updates to SQL Server Database Are Not Captured
      • Are the Existing CDC Tables and Articles Dropped in SQL Server During HVR Initialize
      • SQL Server Log-based Сapture Options
      • Table Compare Reports Identical When Data Is Not Identical
      • Does HVR Replicate Case-Sensitive Tables or Column Names
      • How Does HVR Deal With Non-Logged Unrecoverable Operations
      • High Log Generation
      • Exact Node Name
      • Indexed Disabled During Refresh
      • Server for the HVR Installation
      • hvrmaint Alert Without Latency
      • Kill Capture & Integrate
      • SQL Simple Recovery Not Supported
      • Agent Installation
      • Snowflake Best Practices
    • Errors, Warnings, Alerts
      • CRS-2415 HVRLsnr Cannot Be Registered
      • Error 404 Page Not Found
      • F_JC0038, F_JC003A, or F_JC0041 in hvrremotelistener
      • F_JD024D DBMS Error
      • F_JD20DB DBMS Error
      • F_JD21AE Unable To Connect to SQL Server
      • F_JD21B4 Invalid Object Name
      • F_JD21D5 Attempting To Execute SQL Statement
      • F_JD22A1 Invalid Teradata SQL Token
      • F_JD22CA Skipping Table
      • F_JD2313 DBMS error
      • F_JD2822 Unable To Find Log Files or Archives With Valid Non-Zero Sequences
      • F_JG0B15 Error While Inspecting URL
      • F_JG0F02 Could Not Convert List
      • F_JG200A Internal Error Triggered Segmentation Violation Trap SIGSEGV
      • F_JG202F Shared Library Failed
      • F_JG20D5 Execute Command Curl
      • F_JG221C Pipe Project Received Tag
      • F_JG231B Operating System Command
      • F_JG2402 Mismatch of Column Info
      • F_JG2529 XML Error
      • F_JG2901 String Containing Invalid Sequence
      • F_JG3529 Couldn’t Resolve Host Name for Slack Alert
      • F_JR0549 Unable to Find ColumnProperties
      • F_JR0E28 License File Has Capture Restrictions
      • F_JR0E29 License File Has Integrate Restrictions
      • F_JR0E62 Integrate Job Prevented from Starting
      • F_JT0263 Pipe Sort Supplied Received Rows From Table
      • F_JT0400 Log Scanning Error F_JZ1517
      • F_JT044C Encountered Change to Table
      • F_JT0736 Table is Already Enrolled
      • F_JT0905 Log Start Positioning Error F_JZ1101
      • F_JZ0A42 Log File Has Been Reused
      • ORA-26723 User Requires `DV_GOLDENGATE_REDO_ACCESS` Roles
      • Process for Job Will Be Killed
      • W_JR00B3 No Specified Tables in `loc_src` and `loc_tgt`
  • Release Notes
    • HVR 5.7 Release Notes
    • HVR 5.6 Release Notes
    • HVR 5.5 Release Notes
    • HVR 5.3 Release Notes
RSS
Release notes RSS
Fivetran Documentation
Fivetran Documentation
Main Menu
Introduction
Architecture Overview
Replication Overview
Replication Topologies
HVR 5 Release Life Cycle
Platform Compatibility Matrix
Document Conventions
Fivetran
HVR 5
Local Data Processing
  • Support
  • Sign In
Fivetran
HVR 5
Local Data Processing
Edit on GitHub

Introductionlink

Updated 13 days ago

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.

Advantageslink

  • 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

Capabilitieslink

  • 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

Questions?

We're always happy to help with any other questions you might have! Send us an email.

    Thanks for your feedback!
    Was this page helpful?