Data sync or replication between OpenEdge to PostgreSQL DB - Forum - Community Groups - Progress Community

Data sync or replication between OpenEdge to PostgreSQL DB

 Forum

Data sync or replication between OpenEdge to PostgreSQL DB

This question is not answered

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
  • 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
     
  • Thanks for reply. But do we have any other tools in suggestion which can be used to replicate data from openEdge to postgres sql

  • 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.