Data sync or replication between OpenEdge to PostgreSQL DB

Posted by desperado on 29-Sep-2019 17:01

There's a requirement to data sync or replicate from OpenEdge DB to PostgreSQL DB.

As per OpenEdge Pro2, it support only Microsoft SQL Server or Oracle target. Not supported for PostgreSQL DB.

Do we have any other tool and approach for data sync or replication between OpenEdge to Postgres DB?

All Replies

Posted by Satya Prasad on 30-Sep-2019 06:14

You are right. OpenEdge Pro2 supports Microsoft SQL Server and Oracle targets. There is no other tool to do data sync or replication to Postgres target database.
 
But, In this PI, Pro2 team is doing some research to support other targets(Postgres, Redshift etc ) as well. It will take good amount of time to ship in the product.
 
Thanks,
Satya
 

Posted by desperado on 30-Sep-2019 08:34

Thanks for reply. But do we have any other tools in suggestion which can be used to replicate data from openEdge to postgres sql

Posted by Valeriy Bashkatov on 04-Oct-2019 07:52

You can activate the OE CDC in your database and then retrieve the changes via SQL from a third system.

For example, in the following link you will find an example of streaming data from OpenEdge to Kafka

www.progress.com/.../streaming-your-data-from-openedge-to-kafka

You can do the same on the Postgresql side.

This thread is closed