Progress® OpenEdge® Pro2™ is a data replication solution that provides easy access to data from your OpenEdge applications. OpenEdge Pro2 data replication solution removes connectivity limitations without disruption to normal business operations or risk to the transactional database.
With OpenEdge Pro2 data replication you create a channel for transferring Progress OpenEdge data into a Microsoft SQL Server, Oracle or a target OpenEdge database for efficient reporting and analysis. As your data is updated, it is replicated to your desired database in near real-time. With your Progress OpenEdge database and target databases virtually in sync, you can use your third-party reporting solutions for up-to-date reports and business intelligence.
By leveraging Progress OpenEdge Change Data Capture (CDC), OpenEdge customers and partners can deliver low-latency, near real-time replication of that data to support not just traditional descriptive analytics, but also predictive analytics, AI-driven decisions, and time-sensitive IoT events.
Pro2 offers a new, modern UX dashboard and new UX Replication Wizard, ensuring you’ll be prepared for increasing demands for data access with expanded functionality and scalability for future growth. The UX dashboard improves efficiency and productivity, and allows proactive monitoring of performance and analytics, all while delivering a beautiful and intuitive experience that expands the product’s functionality while representing the most evolved version to date.
Increase Efficiency With an Intuitive UI
Scale for Growth
Change Data Capture (CDC) Replication Speed
In Pro2 6.2, CDC replication records are consumed directly by Pro2 bypassing the need for the records to be converted and decrease total time of replication.
Bulk-load Process Optimized
The bulk-load process is optimized to directly generate native SQL Insert statements and wrap multiple inserts into a single target transaction— improving the efficiency of the load process. For table loads that run for days or weeks, the impact can be proven to be dramatic. Because the new bulk-load method is a Pro2 produced methodology, this new feature operates identically in both Oracle and Microsoft SQL Server environments, allowing Pro2 to provide wide-transaction support in Microsoft SQL Server environments.
Replication triggers or Change Data Capture automatically capture all data changes; this means minimal information is written to the queue to identify the updated record.
Next, the multi-threaded replication process retrieves the updated record and the queued data in the replication is moved to the target database. Done in near real-time, the I/O operation is optimized with the updated record residing in cache. Any analysis can be run against current data in a replicated database, leaving the transactional database resources to their normal activities, all while feeling confident your data is accurate and secure.