How To

• How to Add a Column to The Target Database
• How to Add Multiple Instances of a Table to a Channel
• How To Add Parallelism by Defining Multiple Integration Jobs
• How to Add Prefix to Replicated Table Name(s) in Target
• How to Add Table to Existing HVR Channel
• How to Archive HVR Log Output Files From HVR_CONFIG Directory
• How to Avoid Grants to Public for a Table Created in Target Database
• How To Avoid Truncation of Table Data
• How To Build HVR Statistics Channel in Relational Format for Reporting
• How to Calculate Values for HVR_SCAN_SEQ_BITS_MSSQL Environment Variable
• How to Capture From an Oracle Materialized View
• How to Change Database User Password for HVR Hub Repository
• How to Configure HVR for High Availability in Oracle Cluster
• How to Configure HVR in a Windows Cluster
• How to Configure Multidirectional Replication with Oracle
• 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 Create and Run Refresh Job Using HVR Scheduler
• How to Create Maintenance Task to Remove Journal Files
• How to Create Multiple Integrate Jobs in the Same Channel for Parallelism
• How to Create New Column Using /CaptureExpression
• How to Create Table in Oracle Target Database for HVR Statistics
• How to Define a Location To Connect to a Greenplum Database
• How To Define a Target Column With a Timestamp That Is Populated With a Date & Time When the Row Is Replicated
• How to Delete Table from Existing Channel
• How to Determine the HVR Hub Fingerprint
• How to Determine Which Journal Receiver is Currently Being Processed
• How to Enable Journaling for Router Files
• How to Exclude a Column From Being Replicated to the Target Table
• How to Extract Table Based on Join Condition
• How to Filter Deletes From Being Propagated to Integrate Location
• How to Fix Date Value Replication Issues
• How to Handle HVR Capture During a Database Upgrade
• How to Identify Data Loss and Inconsistencies
• How to Identify HANA Backup Log File From the Sequence Number in the Error Message
• How to Identify the SQL Server TLog Backup Log File Based on the LSN
• How to Ignore a Redo Thread in CLOSED Status Using The HVR Capture Process
• How to Ignore Mass Deletes Based on Username in PostgreSQL, DB2 for LUW, and MySQL
• How to Install SQL Server ODBC Driver on Linux
• How to Integrate Only Rows Having Specific Column Value from Source Table to Target
• How to Make hvrstats Job Visible in HVR GUI under Scheduler
• How To Mask a String in a Column Value in PostgreSQL Target
• How to Monitor HVR Jobs Using SNMP Integration
• How to Monitor Replication Latency
• How to Move Data From Tables to Flat Files
• How to Refresh Only the Rows in an SAP Pooled Table That Match a MANDT Column Value
• How to Replicate a Single Table to Two Tables on the Target
• How to Replicate XML Files From Oracle to AWS S3
• How To Schedule Email Alerts
• How to Set Default Schema for PostgreSQL, Greenplum, Snowflake, and Redshift
• How to Skip and Recover Record that Continually Causes Capture to Fail
• How to Start HVR as Service Using Systemd in Linux
• How to Start HVR as Service Using Inetd in Linux
• How to Specify Encoding for Binary Field
• How to Test Connection to Oracle RAC Using Hvrtestlistener
• How to Troubleshoot Network Issues
• How to Understand Missing Tables in Table Explorer
• How to Use AddressTo and AddressFrom Features
• How to Use Expression Scope to Track Changes
• 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 HVR_THROW_WARN to Convert Errors Into Warnings
• How to Use MaxFileSize Parameter to Split the Incoming File into Number of Files on the Target in CSV Format
• How to Use Online Refresh for Initial Load or Full Re-initialization
• How to Use Online Refresh to Correct Data Mismatches
• How To Use Online Refresh to Step Over a Capture Issue
• How to Use RenameExpression to Name New Files
• How to Use Scheduling Parameters for Compare
• How to Use Scheduling Parameters for Integrate Locations
• How to Use Scheduling Parameters for Refresh