Ingres Realtime Integration

Connect OLTP In Realtime

Ingres HVR allows different Online Transaction Processing (OLTP) Systems to be connected real-time. An example is a connection between a back-office system and an internet database. Ingres HVR offers a seamless, robust and scalable connection so that investment in existing systems can be leveraged and not lost.

Benefits of connecting OLTP systems using Ingres HVR Realtime Data Integration;

• Ingres HVR is able to replicate between different data models. Business logic for transformations can be injected inside the replication stream.
• Data changes can be changed on both sides (bi-directional replication) and data collisions are automatically detected and resolved.
• Log-based change data capture means that no performance overhead is imposed on the production system.
• The data feed is real-time, which replaces a clumsy nightly data-load. Nightly data-loads are difficulty to maintain and cause endless quality problems.
• Ingres HVR supports multiple database solutions which can replicate between each other; Oracle, SQL Server and Ingres as well as file-replication and bridging to XML-based web services.
• Ingres HVR is quick & easy to use and manage, which increases the return on business investment.
• Ingres HVR Compare and Refresh
• Ingres HVR Managed File Transport

Leveraging Investment

An additional benefit is that Ingres HVR is not restricted to one business need. The solution can be leveraged to simultaneously address multiple requirements inside the enterprise, such a

• High Availability
• Disaster recovery
• Business Intelligence
• Active/Active load balancing configurations for continuous availability
• Zero-downtime migrations