Jump to: Topologies Supported | FAQs | Use Cases | Platforms Supported
HVR is a Real-Time Data Integration Solution
Get a Simple Yet Comprehensive Approach for Continuous Data Integration
Since you are here, you are likely looking for a complete set of capabilities to move your data between databases, to the cloud, into a data lake or data warehouse. You are in the right place–with HVR you can do all of these and enjoy a unified solution that simplifies data integration:
- Scale: Ready your business for the long-term with a solution that can scale with growing data volumes, new and disparate technologies and more
- Create Efficiencies: Achieve greater data movement efficiencies due to built-in features such as log-based change data capture, data compression, and more
- Be in Control of Your Data: Easily manage your data through HVR features such as data validation and repair, reporting and monitoring
- Peace of Mind: Have confidence that your data is secure with features such as encryption and KMS support for AWS as well as flexible options for routing data between your on-premises and cloud environments
“With the combination of flexibility, performance and robustness, HVR has proven to be a very good choice to embed in our flight planning system.”
– Senior Database Software Architect, Lufthansa
Get an All-in-One-Solution Built to Simplify Data Integration
HVR delivers a scalable enterprise data integration and validation platform that enables you to simplify high-volume real-time data movement. Using the HVR solution, you can efficiently and continuously integrate into your cloud and on-premises environment with a flexible solution that supports many topologies. What’s more, this tool is all-inclusive and gives you everything you need to carry through your data integration tasks.
Everything you need for real-time data integration is included with HVR:
- Table Creation and Initial Load
- Log-Based Change Data Capture
- Data Validation and Repair
- Insights — Visual Statistics
This all-in-one solution comes in a small download that is easy to manage and use. You can control all of these features through a Graphical User Interface. (GUI)
Broad Source and Target Support
With HVR, you can move your data between the most commonly used relational databases, file systems, data-warehouses, data lakes, cloud systems, and more. Visit the source and target platform support page to see if your technologies are supported. If you don’t see your technology listed, please contact us to learn more about our API agent plug-in.
HVR has proven its stability and robustness. It keeps on running and running with minimal maintenance effort. HVR guarantees secure delivery of all our data.
– Director of IT, PostNL
HVR is a Flexible, Distributed Architecture that You Control from a Central Point
Through HVR’s distributed architecture, you get the ability to not only move data from one source system to another but also the ability to move data bi-directionally and multi-directionally while maintaining efficiency and accuracy. All from one central console. Watch the video to see how HVR solves for use cases such as migrations, active/active, data lake consolidation, real-time reporting and more.
Features such as collision detection, data validation, and reporting and monitoring give you assurance in moving high volumes of data in your complex environments.
- Can HVR replicate data from a single source to multiple targets?
- Yes, in fact that is one of the advantages of HVR’s architecture. HVR can capture from a single Oracle instance, queue the captured changes on the hub, and then integrate those changes to as many targets as needed. HVR does not have any limitation on the number of targets.
- Can HVR replicate data from a multiple source to a single target?
- Yes, HVR can be configured to capture data from many sources and then replicate to a single target. Many data warehousing solutions require data to be collected from any number of sources to be either combined into a single target warehouse database or into separate target schemas. Some applications and data are designed so that there will not be any conflicts on primary key constraints. If that is not the case for your scenario, then HVR offers you the option to add extra columns and set to values stored in the metadata to make sure you don’t have any conflicting primary keys.
- Does my source and target layouts need to have the same structure and layout?
- No, tables do not need to have the same layout. You can instruct HVR to ignore certain columns or populate extra columns during replication. Column values can also be changed through transformations as well as enriched with the results querying other tables, either on the source or the target. HVR also makes additional transactional metadata values to be available to be mapped to columns, such as source timestamps or transaction identifiers.
- To minimize any impact to our network, can we compress the change data before it sent over the network?
- Yes, in fact HVR already compresses the database by default before sending over the network using an internal algorithm which achieves very high compression rates. The impressive compression ratio reduces impact on your corporate network while using little overhead on the source.
- When instantiating the target database, does the user have to pre-create the target tables, or can HVR help with that?
- The initial load of the target tables takes place by running an HVR Refresh operation. The Refresh can create all the target tables if they don’t already exists. The target tables are created based on the DDL of the source tables in conjunction with any column re-mapping that the user has configured in the replication channel.
- Can HVR convert all insert, update, and delete operations and insert them into a time-based journal or history table?
- Yes, HVR Integrate provides a feature known as TimeKey which converts all changes (inserts, updates, and deletes) into inserts into separate tables. HVR will log both the before and after image for update operations, the after image for insert operations, and the before image for delete operations. HVR also logs additional transaction metadata to provide more time based details for every row replicated. HVR will also automatically create the tables with the preferred structure for timekey integration.