Expert Notes
- What is the best strategy to have single capture and have a regular target table and a timekey table for every captured table
- Why does the refresh or compare job file get deleted from the folder $HVR_CONFIG_job ?
- Audit Tables and Slowly Changing Dimensions
- PostgreSQL ssl connect
- CVE-2021-44228 log4j Vulnerability for HVR
- Remote SSH tunneling for HVR
- Securing HVR using SSL/TLS
- Querying the HVR repository table HVR_STATS
- Configuring HVR Capture to co-exist with native MS SQL Server Native Replication or native MS Change Data Capture (CDC) tables
- Scheduler was running but now hvr services started than stops. What is the issue?
- How can companies within one org view all the tickets created by the users in same account?
- HVR High Availability Replication on Amazon Web Services
- HVR: Steps to take when database user's password changes for source and Target location
- HVR takes too much CPU time on the source machine
- When the Scheduler is set to archive file for hvr.out, where does it go?
- Why does the publication on<TestDB> require the snapshot agent to run every hour? This creates GB’s of unused files. The log reader agent is used both by the HVR publication db and the publication team. This is logical as there can be only one log reader
- HVR catalog table HVR_STIN<Channel Name>_<Target Location> contains different values for column TRAILER_CAP_LOC and LEADER_CAP_LOC when there is only one location in the channel
- When we connect to a RAC source with a SCAN name – how do we get the exact node name?
- How to Convert Datatypes or Substitute Column values With Expressions?
- How to Use a /RefreshCondition help to join 2 tables (or more).
- How to use Soft Delete function to keep track of deleted rows?
- Using HVR_THROW_WARN
- What are ".cache" files in the HVR router directory?
- What is the default unit (bytes, Kb, Mb, GB) considered when no suffix is provided for the value in HVR_SORT_BYTE_LIMIT?
- What are Orphans (HVR)?
- Is the SQL Server distribution database required by HVR for log-based Capture?
- SQL Server Log-based Сapture Options
- Workaround Redshift Reserve Words and Permissions
- While adding tables to channel - Is it required to specify schema name in the hvradapt command even when TableProperties action is defined to point to non-dbo schema?
- Troubleshoot missing data