Progress-Anywhere (OpenEdge to SQL Server Data Replication)
Seamlessly run your business critical applications on OpenEdge systems and your Management Information (MI), Business Intelligence (BI) and reporting on SQL Server.
• Let OpenEdge do what it does best by providing industry leading reliability and scalability to your business critical systems and users.
• Let SQL Server do what it does best by providing access to cutting edge MI, BI and Enterprise reporting solutions.
• Never let the performance of your live systems be compromised by the need to report on what they are doing.
• Never let the availability of timely MI, BI and reporting be constrained by the need to keep your live systems running smoothly.
What it Does
Progress-Anywhere is a batch data replicator. It can be pointed at any source Progress/OpenEdge database (9.1D +) to copy all data changes across to a target SQL Server database (2005 +).
• Replicate some or all tables in your source OpenEdge database.
• Replicate some or all fields in your source tables.
• Manage, tune and index the source and target databases completely independently.
• All data type and naming differences automatically transformed.
• SQL Server target database build script automatically created.
• Limitless custom transformations possible (via Professional Services): -
◦ Replicate multiple source tables into one target table and vice versa.
◦ Combine OpenEdge date and time fields into a single datetime field in SQL Server.
◦ Split, merge and convert records and fields as they are replicated.
• Scalable multi-threaded architecture proven in testing to replicate datasets up to 200 million records in one overnight batch run.
This solution is a low cost option, which can be purchased in a number of ways to suit your business. Contact Us now for a no obligation discussion on how this solution can solve your business reporting problems.