Dbvisit Reporting uses data replication to synchronize data across databases, enabling reporting activities to be offloaded to an alternative platform. This delivers significant benefit at the infrastructure layer, facilitating real time business reporting and reducing the impact of reporting on online systems.
Dbvisit Reporting is powerful, affordable software that is simple to install and configure. Dbvisit Reporting provides replication from Oracle to Oracle and MySQL databases and comes with all the tools and utilities necessary to deliver easy management, including conflict detection and resolution.
Dbvisit Reporting uses the highly efficient change data capture (CDC) mining technology from Dbvisit Replicate to detect changes in the source data and to replicate and distribute these changes across Oracle and non-Oracle databases. The mining process runs outside of the database, meaning it is non-intrusive and does not impact the performance of the online system.
In addition to the built-in conflict detection and resolution processes, Dbvisit Reporting’s caching ensures all committed records are securely delivered to the target database(s) even in the event of an outage, ensuring that the reporting database remains up-to-date and available.
When exchanging data outside of a LAN, either over a WAN or over the Internet, Dbvisit Reporting encrypts the data to ensure it is sent securely from the source database to the reporting database. Within a LAN environment this security can be tuned off.