Dbvisit Replicate is powerful, affordable software that is simple to install and configure. Replicate provides Oracle to Oracle, MySQL and Microsoft SQL Server database replication and comes with all the tools and utilities necessary to deliver easy management, including conflict detection and resolution.
Dbvisit Replicate uses its own highly efficient change data capture (CDC) technology, and Oracle’s internal redo logs, to detect changes in the source data and to replicate and distribute these changes in real-time across Oracle and non-Oracle databases.
In addition to the built-in conflict detection and resolution processes, Dbvisit Replicate’s caching ensures all committed records are securely delivered to the target database(s) even in the event of an outage. This functionality reduces the risk of system interruptions, hardware or network unavailability and restoration delays.
Dbvisit Replicate uses public key cryptography to securely send data from one location to another. When exchanging data outside of a LAN, either over a WAN or over the Internet, public and private keys are used to encrypt and sign the data, ensuring that the data is exchanged securely and providing confidence to the recipient that the data has not been modified in transit. Within a LAN environment, this security can be tuned off.
Dbvisit Replicate provides:
Automatic recovery from errors and network issues
Encryption and compression of data sent across the network
Management of existing database triggers to avoid double firing
Conflict resolution business rules can be created with user defined PL/SQL stored procedures
Replication console to provide real time overview of the replication
With an abundance of software solutions throughout modern organizations, the expectation of high performance access to data across the enterprise is placing increasing demands on database servers and the databases they manage.
The data distribution process provides data synchronization across multiple database servers, thereby spreading the load and widening the availability of data. It also allows each of the accessing applications to connect to a copy of the data that is tailored to their usage, including the data available, its structure and the way it is stored (e.g. indexes). This allows an organization to provide multiple synchronized sources for the same data, each tuned to the individual requirements of the application or user.
The distribution process can transform data as it is transferred, allowing the data to be tailored to the specific purpose of the destination database. For example, data can be de-normalized in order to make reporting more efficient, or can be filtered to provide a subset suited to the purpose of a particular system.
Dbvisit Replicate can be operated in unidirectional and bidirectional modes.
In a unidirectional system changes from a source database are applied to one or more target databases, in a one-way flow of updates. Such an approach can be used for the distribution of reference data, or the transmission of data from a remote office to a central office.
The following diagram illustrates such a one-way flow of updates from the source database to the target.
In bi-directional operation, changes are shared between the databases in both directions. Changes are identified in each database by a mine process and are applied at the remote location by an apply process. This approach, which enables two databases to be continuously synchronized, can be used to share data or maintain different databases for different purposes (online versus batch data etc.).
The following diagram illustrates such a two-way flow of updates between two databases.