0

There's data sitting in OpenEdge Progress databases. We'd like to replicate that data to a PostgreSQL "datalake" using a software called HVR (high volume replication I think). What the software does is basically install a local agent and replicate data from a source DB to a target DB.

Does anybody know if Progress allows such a thing?

I know it has its own replication mechanisms but that's not what we're looking for.

1
1

You don't have many options here:

1) if you are on OE11.7 and later, you can use OpenEdge Change Data Capture to track data and replicate it http://knowledgebase.progress.com/articles/Article/How-to-implement-CDC-Change-Data-Capture-with-OpenEdge

2) if you are on older version, you might use Pro2 software. I am aware of Pro2SQL for MS SQL target and Pro2Oracle for Oracle DBA.

https://www.progress.com/campaigns/openedge/Pro2v5-Webinar

EDIT: did not read the question in full: your best option is to ask Progress itself, but I don't see why not: your agent will be just another user connecting to database, so if you have enough user licences, you should be fine.

Edit#2: on older versions of OE Pro2 uses older solution to track changes: it installs triggers for tables you want to replicate, they fire up and record change in auxhillary database, then replication agent ran on Management Server actually replicate records to Target. Management server also contains tools to generate SQL schema updates, new triggers if Source schema changes, etc.

CDC by itself allows you to track changed records but the rest is your responsibility: creating schema for target, generating SQL loads, etc. With newer version of OE, Pro2 utilizes CDC to speed up replication.

4
  • 11.7 is the current version at this time, and Pro2 uses CDC on 11.7 to dramatically improve performance.
    – Tim Kuehn
    Aug 1 '17 at 20:10
  • Yes, on older versions of OE Pro2 solution is to install triggers for tables you want to replicate, they fire up and record change in auxhillary database, then you need to have Management Server that runs agents that actually replicate records to Target. CDC allows you to track changed records but the rest is your responsibility: creating schema for target, generating SQL loads, etc.
    – user61244
    Aug 2 '17 at 2:48
  • Sorry, posted before finished comment: Pro2 does that for you.
    – user61244
    Aug 2 '17 at 2:49
  • You can edit your answer to include this...
    – Tim Kuehn
    Aug 2 '17 at 3:00

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.