open-source equivalent of golden-gate

вт, 11 февр. 2020 г. в 12:23, ROS Didier <didier.ros@edf.fr>:

In the Oracle world we use the product "golden gate" to execute
transactions from a source database (Oracle, Mysql) to a PostgreSQL
instance.

This allows 2 Oracle and PostgreSQL databases to be updated at the same
time in real time.

I would like to know if there is an equivalent open-source product.

There is a SQL/MED standard exactly for this:
https://wiki.postgresql.org/wiki/SQL/MED

Implemented in PostgreSQL as Foreign Data Wrappers:
https://wiki.postgresql.org/wiki/Fdw
You need to do the following:
1. Add wrapper via
https://www.postgresql.org/docs/current/sql-createextension.html
2. Create remote source via
https://www.postgresql.org/docs/current/sql-createserver.html
3. Create foreign table via
https://www.postgresql.org/docs/current/sql-createforeigntable.html

Note, that PostgreSQL provides only infrastructure, wrappers for different
remote systems are not supported by the PostgreSQL community,
except for postgres_fdw and csv_fdw provided by the project.

--
Victor Yegorov

On 02/11/20 07:51, Victor Yegorov wrote:

вт, 11 февр. 2020 г. в 12:23, ROS Didier <didier.ros@edf.fr>:

In the Oracle world we use the product "golden gate" to execute
transactions from a source database (Oracle, Mysql) to a PostgreSQL
instance.

Note, that PostgreSQL provides only infrastructure, wrappers for different
remote systems are not supported by the PostgreSQL community,
except for postgres_fdw and csv_fdw provided by the project.

I read the question as perhaps concerning the other direction, whether
there might be an open source foreign data wrapper installable in Oracle
for talking to PostgreSQL (which might, I suppose, also have a name like
"postgres_fdw", which helps explain the number of times I've rewritten
this sentence trying to make it unambiguous).

Regards,
-Chap

ROS Didier schrieb am 11.02.2020 um 11:23:

In the Oracle world we use the product "golden gate" to execute
transactions from a source database (Oracle, Mysql) to a PostgreSQL
instance.

This allows 2 Oracle and PostgreSQL databases to be updated at the
same time in real time.

I would like to know if there is an equivalent open-source product.

Thanks in advance

Best Regards
Didier ROS

The closest solutions to golden gate are probably

* https://debezium.io/
* https://www.symmetricds.org/

Thomas

From: Chapman Flack <chap@anastigmatix.net>

I read the question as perhaps concerning the other direction, whether
there might be an open source foreign data wrapper installable in Oracle
for talking to PostgreSQL (which might, I suppose, also have a name like
"postgres_fdw", which helps explain the number of times I've rewritten
this sentence trying to make it unambiguous).

Oracle Database Gateway for ODBC can be used:

Oracle Database Gateway for PostgreSQL - ORACLE-HELP
http://oracle-help.com/oracle-database/oracle-database-gateway-postgresql/

Regards
Takayuki Tsunakawa