Postgres Pro
Downloads
Home   >   mailing lists

Thread: best way sync data from Oracle to PostgreSQL?

best way sync data from Oracle to PostgreSQL?

From
Michael Moore
Date:
Our DBA's want to write a home-grown ETL system. Surely there has got to be a better way. What is the best NO COST solution for doing this? We have CLOBS and XML datatypes. We could "toString" the XML datatypes on the Oracle side if that helps. 

TIA, Mike

Re: best way sync data from Oracle to PostgreSQL?

From
Adrian Klaver
Date:
On 01/13/2016 08:37 AM, Michael Moore wrote:
> Our DBA's want to write a home-grown ETL system. Surely there has got to
> be a better way. What is the best NO COST solution for doing this? We
> have CLOBS and XML datatypes. We could "toString" the XML datatypes on
> the Oracle side if that helps.

Have you looked at Foreign Data Wrappers?:

http://www.postgresql.org/docs/9.4/static/ddl-foreign-data.html

in particular:

http://laurenz.github.io/oracle_fdw/

>
> TIA, Mike


-- 
Adrian Klaver
adrian.klaver@aklaver.com