FREQUENTLY ASKED QUESTIONS
How does AdaptOE do the real-time data replication?
By using Progress OpenEdge database triggers or Change Data Capture (CDC), we capture on the delta events in the database, correct the data differences with SQL, and convert it to JSON in real-time. CDC is a newer technology and Database triggers have been used successfully for replication for over 15 years as a proven method that has negligible impact on performance. No more batch dumps, ODBC, or other expensive alternatives!
What is the minimum Progress OpenEdge version required?
Progress 10.2B is the minimum for the trigger based replication and 11.7 for CDC.
You say affordable, why?
This is a subscription based solution that does not require a large capital expenditure of perpetual licenses and annual maintenance fees. On average, we are saving our customer 2/3rds on the alternative solution.
What databases can I replicate to?
You can chose to replicate to an on premise SQL database, cloud instance like Azure, AWS or any other SQL hosted environment. It's you choice to have your target SQL data where ever you want!
Can I use it for a single data dump from Progress DB to SQL.
Yes, We offer a one time use license and services to dump the data from your Progress DB and load it back up with the schema and indexes to a SQL DB. This is good for archiving the Progress database as companies migrate away from the technology.
Can I use this with any Progress OpenEdge Application?
Yes you can!. As long as your source database is Progress OpenEdge 10.2B or higher, than we can replicate it to a SQL target.
Is this a solution for disaster recovery?
No, AdaptOE is only for real-time replication of Progress to SQL and cannot be used as a DR solution for the Progress database. You may want to look at Progress' OpenEdge Replication, formally known as Fathom.
Can you replicate multiple Progress databases?
Yes, we can replicated multiple database on a single server and consolidate the data on the SQL DB.
How do you handle archiving of OpenEdge data?
Many QAD customers, archive and delete data from their ERP. As best practice, we keep the SQL replication in sync with the production Progress database and have the customer build and separate archive SQL database to load the archive data for reporting.
All product and company names are trademarks™ or registered® trademarks of their respective holders. Use of them does not imply any affiliation with or endorsement by them.
Copyright©2020 Adaptivity, Inc -All Rights Reserve