Menu
Menu
Sharing data between different databases and applications can be very complex and can have a negative impact on system performance, which in turn can negatively affect the company’s financial performance. In addition, if you cannot analyze the minute-to-date data located in different systems you lose the business opportunities offered today by advanced Business Intelligence (BI).
DBPLUS Data Replicator is versatile and reliable software for data replication from Oracle databases to Oracle, Microsoft SQL Server and PostgreSQL. It gives real-time access to copies of production data with zero impact on the availability and performance of the systems which are the source of the data.
By using real-time replication, migration or upgrading the version of the database can become much faster and much more secure. Firstly, this process allows you to migrate with virtually no downtime, because at some point the application can be very quickly switched to a new database which already contains the current data. Most often when designing this type of operation, there is a plan to return to the previous database if you encounter problems. Unfortunately, these plans usually cover no more than the first few minutes of work on the application, but when the new database includes several hours of data, a return to work on the old database is not possible. The solution to this problem is to replicate the real-time data entered into the new database to the old database as well. If you encounter problems with the new database, switching the application to the old database can be done in a matter of seconds in a manner transparent to the user.
Data Replicator can read over 80GB of changes contained in log files per hour. Information about changes made on the source database is read from transaction logs via the LogMiner tool available in Oracle databases. The only effect that the Replicator has on the source base is in the low load that results from the LogMiner tool.
Replication of data in real time between transaction systems and reporting platforms allows you to create reports based on the most current data without any additional load for transactional systems, which are data sources. This allows you to solve the dilemma that either you are working on outdated data (loaded to the reporting system previously, e.g. the night before), or trying to run reports directly on the transactional systems, which has a direct negative impact on their performance.
For the efficient operation of multiple applications in a company it is necessary to have an effective data exchange between them. Most often, solutions for the integration of multiple applications in a company (such as a data bus) are extremely resource-hungry. An optimal solution to the problem of system integration turns out to be replication of data in real time between them, which is much less resource intensive than other methods.
The DBPLUS Data Replicator software can read up to 1.5TB of daytime changes contained in log files. Information about changes made on the source database is read from transaction logs via the LogMiner tool available in Oracle databases. The only effect that the Replicator has on the source database is the low load resulting from the LogMiner tool.
With real-time replication, you can easily consolidate data from multiple systems into a single database – e.g. a data warehouse. Reports can be created based on the current data flowing from multiple systems in the company in real time, which allows for advanced Business Intelligence analysis.
Another application is the uploading of data from the central transaction system into distributed systems in the company. Without the additional load on the source system, users in remote locations can work on a copy of the production data in real time.
Data Transfer allows to copy any data tables between transactional databases. Thanks to this, the configuration of the replication process is more simple.
Using this function, Data Replicator automates the process and does not require the use of additional tools such as Data Pump or RMAN.
The solution is also adapted to the network where there is a risk of packet loss and connection failure – thanks to the built-in function of automatic restoration of synchronization between components.
Replicates Oracle databases from 10.2 version and Microsoft from MS SQL Server 2012 Enterprise Edition and MS SQL 2016 Standard Edition.
DBPLUS Data Replicator server runs on Windows Server 2008, 2012 or 2016 or Windows 7/8/10 with the .NET 4.5 Framework
Data Replicator is updated at least 4 times a year. Customers have access to all updates when they have a license or maintenance service. With the upgrade to the latest version, the application will run faster and smoother. Each published version provides new functionalities and improvements.
DBPLUS Data Replicator is licensed “per socket” (CPU socket) for MS SQL Server / Oracle SE databases or “per core” for the Oracle EE base version in the source-replica configuration.
Minimum impact on the load of the source database.
Support for source databases:
Oracle Standard Edition and Enterprise Edition; Microsoft SQL Server
Ability to replicate the entire database or selected tables.
Very high precision of operation ensures data integrity.
Allows reduction of the load on the production database thanks to the possibility of transferring reporting to dedicated systems.
User support at the highest level.
Extremely cost-effective solution, price levels unmatchable by competitors.
Ability to replicate from Oracle databases to databases in other technologies, including open-source PostgreSQL.
