? QA Design Gurus: Powerful tool for replicating OpenEdge database

May 11, 2016

Powerful tool for replicating OpenEdge database

All OpenEdge database Customers can adopt this powerful and reliable tool (Pro2) for replicating data from a Progress OpenEdge database to Microsoft SQL Server, Oracle, or to another Progress OpenEdge database.

Introduction
Progress OpenEdge Pro2 Data Replication (Pro2) is the easiest, lightweight and most cost effective approach for replicating Progress OpenEdge data to Microsoft SQL Server or to the Oracle RDBMS. Extracts no longer need to compete for resources with 4GL users or nightly dump and load routines that may not work. Data is replicated in near real-time, instead of 24 hours later. Another major advantage of the Pro2 Replication suite is that all data transformations can be completed using the OpenEdge 4GL. This provides for maximum flexibility and excellent performance since the solution is completely native to Progress.

Pro2 utilizes the strengths of both the Progress OpenEdge database and OpenEdge 4GL/ABL to achieve the most dependable and configurable solution for Progress to SQL replication.

What is the need for Database Replication ?
Replication requirements arise for a variety of reasons. Heterogeneous application integration, reporting server, data archival, high availability, Auditing and business intelligence are just a sample of the business solutions that may require near-real time replication to a foreign database.

Why is Pro2 lightweight? 
The entire architecture of Pro2 was designed with simplicity in mind. The product was designed using a small footprint with proven technology. The product is written using the OpenEdge Advanced Business Logic (ABL). The process also uses the OpenEdge DataServer as a bridge to fill the gap between OpenEdge fields and data types and the corresponding target fields and data types. The DataServer also includes some useful utilities enabling the two heterogeneous databases to “play nicely” with each other.

Pro2 Replication Architecture Overview

No comments:

Post a Comment