AdaptOE FAQ

• By using Progress OpenEdge database triggers or Change Data Capture, we capture the delta events in the database, correct the data differences with SQL, and convert it to JSON in real-time. Managing the process from there is our secret sauce.
• Database triggers have been used successfully for replication for more than a decade as a proven method that has negligible impact on performance. For OpenEdge environments above version 11.7, Change Data Capture can be used to capture delta events – it’s really up to you.
• No more batch dumps, ODBC, or other expensive alternatives!

Progress 10.2B is the minimum. We are utilizing the JSON functions introduced to the product at this version.

• This is a subscription based solution that does not require a large capital expenditure of perpetual licenses plus annual maintenance fees.

No. For a cloud replication target this solution utilizes Azure Cloud services and has been built to leverage that platform. With the growing adaptation of Microsoft Azure, all the enhanced security, compliance, SQL licensing, and affordability, this was the primary choice for cloud hosting. We have engineered the product to be able to adopt related AWS components as a cloud alternative if demand warrants. If this is something you are interested in, let us know.

We also provide for a non-cloud replication target solution by supporting replication to an on-premises SQL database as well.

Absolutely. 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 option for archiving a Progress database if a company were to make the decision to migrate away from the technology.

We currently have customers running the solution in the QAD Cloud.

Yes, in addition to the standard features of Azure we have implemented end to end managed identity for Azure resource implementations (RBAC – role based access control). Key vault is also available for storage of secrets if needed.

This is why we choose Microsoft Azure as our primary cloud option. Keeping up with the ever changing regulations of data compliance is an impossible task for any company. With Azure, you can choose environments certified to meet standards like ITAR, GDPR, HIPAA, PCI, DSS.

No. AdaptOE is only for real-time replication of Progress to Azure or on-premises SQL and cannot be used as a DR solution for the Progress database.

Yes, we can replicate multiple databases on a single server and consolidate the data on the target SQL DB.

Many Progress customers, archive and delete data from their application. As a best practice, we keep the SQL replication in sync with the production Progress database and have the customer build a separate archive SQL database to load the archive data for reporting.